Mr.Combet Webshell 🔥

Edit File Name : _UserWiseActivityReportingList.cshtml

@using PagedList.Mvc;
@using RER_Project.BusinessLayer.BusinessService

@model PagedList.IPagedList<RER_Project.DataAccess.ViewModels.WorkPlan.WorkPlanViewModel>

@if (Model[0].Fn_WorkPlanDetailViewList.Count > 0)
    {
    <div class="table-responsive" style="margin-top: 16px;">
        @foreach (var group in Model[0].FnActivityMonthWiseReports.GroupBy(x => new { x.FiscalYear, x.AssignedByName }).OrderByDescending(x => x.Key.FiscalYear))
        {
        <h4 style="background-color: #e9e9e9; padding: 8px 8px;">@group.Key.FiscalYear (@group.Key.AssignedByName)</h4>

<table class="footable table table-hover dataTables" id="sum_table" data-page-size="10" data-filter=#filter>
            <thead>
                <tr>
                    <th>Component</th>
                    <th>Sub Component</th>
                    <th>Activity</th>
                    <th>Assigned To</th>
                    <th>Shrawan</th>
                    <th>Bhadra</th>
                    <th>Asoj</th>
                    <th>Kartik</th>
                    <th>Mangsir</th>
                    <th>Poush</th>
                    <th>Magh</th>
                    <th>Falgun</th>
                    <th>Chaitra</th>
                    <th>Baishakh</th>
                    <th>Jestha</th>
                    <th>Asar</th>
                    <th>Total</th>
                </tr>
            </thead>
            <tbody>
                @foreach (var item in Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName))
                {
                <tr>
                    <td>@SubComponentService.GetComponentName(item.ActivityId)</td>
                    <td>@SubComponentService.GetSubComponentName(item.ActivityId)</td>
                    <td>@item.Activity</td>
                    <td>@item.PriorityActivityOneSupportName</td>
                    <td>@item.ShrawanQ / @item.Shrawan</td>
                    <td>@item.BhadraQ / @item.Bhadra</td>
                    <td>@item.AsojQ / @item.Aswin</td>
                    <td>@item.KartikQ / @item.Kartik</td>
                    <td>@item.MangsirQ / @item.Mansir</td>
                    <td>@item.PoushQ / @item.Poush</td>
                    <td>@item.MaghQ / @item.Magh</td>
                    <td>@item.FalgunQ / @item.Falgun</td>
                    <td>@item.ChaitraQ / @item.Chaitra</td>
                    <td>@item.BaishakhQ / @item.Baishakh</td>
                    <td>@item.JesthaQ / @item.Jestha</td>
                    <td>@item.AsarQ / @item.Asar</td>
                    <td>
                        @(item.ShrawanQ + item.BhadraQ + item.AsojQ + item.KartikQ + item.MangsirQ + item.PoushQ + item.MaghQ + item.FalgunQ + item.ChaitraQ + item.BaishakhQ + item.JesthaQ + item.AsarQ) /
                        @(item.Shrawan + item.Bhadra + item.Aswin + item.Kartik + item.Mansir + item.Poush + item.Magh + item.Falgun + item.Chaitra + item.Baishakh + item.Jestha + item.Asar)
                    </td>
                </tr>

}

</tbody>
            <tfoot>

<tr>
                    <td>
                        Total: @(Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.ShrawanQ) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.BhadraQ) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.AsojQ) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.KartikQ) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.MangsirQ) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.PoushQ) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.MaghQ) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.FalgunQ) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.ChaitraQ) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.BaishakhQ) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.JesthaQ) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.AsarQ)) /
                        @(Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.Shrawan) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.Bhadra) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.Aswin) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.Kartik) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.Mansir) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.Poush) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.Magh) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.Falgun) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.Chaitra) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.Baishakh) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.Jestha) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.Asar))

</td>
                </tr>

</tfoot>
        </table>

}
        <div id="myPager" align="center">
            @if (Model.Count > 0)
            {
            @Html.PagedListPager(Model, page => Url.Action("UserWiseIndex", new { page,ViewBag.userId,ViewBag.fyId,ViewBag.componentId, ViewBag.subComponentId  }), PagedListRenderOptions.ClassicPlusFirstAndLast)
            }
        </div>
    </div>
    }
    else
    {
    <div><center>No Data</center></div>
    }