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>January</th>
                    <th>February</th>
                    <th>March</th>
                    <th>April</th>
                    <th>May</th>
                    <th>June</th>
                    <th>July</th>
                    <th>August</th>
                    <th>September</th>
                    <th>October</th>
                    <th>November</th>
                    <th>December</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.January_Y / @item.January</td>
                    <td>@item.February_Y / @item.February</td>
                    <td>@item.March_Y / @item.March</td>
                    <td>@item.April_Y / @item.April</td>
                    <td>@item.May_Y / @item.May</td>
                    <td>@item.June_Y / @item.June</td>
                    <td>@item.July_Y / @item.July</td>
                    <td>@item.August_Y / @item.August</td>
                    <td>@item.September_Y / @item.September</td>
                    <td>@item.October_Y / @item.October</td>
                    <td>@item.November_Y / @item.November</td>
                    <td>@item.December_Y / @item.December</td>
                    <td>

@(Convert.ToInt32( item.JanuaryQ) + Convert.ToInt32( item.FebruaryQ) + Convert.ToInt32( item.MarchQ) + Convert.ToInt32( item.AprilQ) + Convert.ToInt32( item.MayQ) + Convert.ToInt32( item.JuneQ) + Convert.ToInt32( item.JulyQ) + Convert.ToInt32( item.AugustQ) + Convert.ToInt32( item.SeptemberQ) + Convert.ToInt32( item.OctoberQ) + Convert.ToInt32( item.NovemberQ) + Convert.ToInt32( item.DecemberQ)) /
        @(item.January + item.February + item.March + item.April + item.May + item.June + item.July + item.August + item.September + item.October + item.November + item.December)
                    </td>
                </tr>

}
            </tbody>
            <tfoot>

<tr>
                    <td colspan="16"></td>
                    <td>
                        Total: @(Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => Convert.ToInt32( x.JanuaryQ)) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => Convert.ToInt32( x.FebruaryQ)) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => Convert.ToInt32( x.MarchQ)) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => Convert.ToInt32( x.AprilQ)) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => Convert.ToInt32( x.MayQ)) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => Convert.ToInt32( x.JuneQ)) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => Convert.ToInt32( x.JulyQ)) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => Convert.ToInt32( x.AugustQ)) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => Convert.ToInt32( x.SeptemberQ)) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => Convert.ToInt32( x.OctoberQ)) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => Convert.ToInt32( x.NovemberQ)) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => Convert.ToInt32( x.DecemberQ))) /
                        @(Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.January) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.February) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.March) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.April) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.May) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.June) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.July) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.August) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.September) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.October) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.November) +
                        Model[0].FnActivityMonthWiseReports.Where(x => x.FiscalYear == group.Key.FiscalYear && x.AssignedByName == group.Key.AssignedByName).Sum(x => x.December))

</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>
    }