public JsonResult ExpenseDataTable(int draw, int start, int length)
{
int Page = (start / length) + 1;
AjaxDataTable <ExpenseDataTableRow> ajaxDataTable = expenseService.GetExpenseDataTableRows(Page, length, "");
ajaxDataTable.Draw = draw;
return(Json(ajaxDataTable));
}
public async Task <JsonResult> DTT(int draw, int start, int length)
{
try
{
AjaxDataTable <CategoryDataTableRow> categoryAjaxDataTable = await categoryService.GetCategoryDataTable(1, 5, "", 0, AjaxDataTableCriteria.SortDirection.ASC);
return(Json(categoryAjaxDataTable));
}
catch (Exception e)
{
throw e;
}
}
public JsonResult GetMFChildSummary(AjaxDataTable param)
{
var client = new RestClient(CommonFunctions.GetAPIPath() + "Dashboard/GetMFChildTableSummary");
var request = new RestRequest(Method.POST);
IRestResponse response = client.Execute(request);
IEnumerable <MFReport> summary = JsonConvert.DeserializeObject <List <MFReport> >(response.Content);
HttpContext.Session.SetObject("ChildGridData", summary);
int totalconsumable = summary.Count();
var sortDirection = HttpContext.Request.Query["sSortDir_0"]; // asc or desc
var sortColumnIndex = Convert.ToInt32(HttpContext.Request.Query["iSortCol_0"]);
if (!string.IsNullOrEmpty(param.sSearch))
{
summary = summary.Where(z => z.Scheme.ToLower().Contains(param.sSearch.ToLower()));
}
summary = sortColumnIndex switch
{
1 => sortDirection == "asc" ? summary.OrderBy(z => z.Scheme) : summary.OrderByDescending(z => z.Scheme),
2 => sortDirection == "asc" ? summary.OrderBy(z => z.Units) : summary.OrderByDescending(z => z.Units),
3 => sortDirection == "asc" ? summary.OrderBy(z => z.MaturityDate) : summary.OrderByDescending(z => z.MaturityDate),
4 => sortDirection == "asc" ? summary.OrderBy(z => z.PurchaseNav) : summary.OrderByDescending(z => z.PurchaseNav),
5 => sortDirection == "asc" ? summary.OrderBy(z => z.ValueAtcost) : summary.OrderByDescending(z => z.ValueAtcost),
6 => sortDirection == "asc" ? summary.OrderBy(z => z.CurrentNAV) : summary.OrderByDescending(z => z.CurrentNAV),
7 => sortDirection == "asc" ? summary.OrderBy(z => z.CurrentMarketValuation) : summary.OrderByDescending(z => z.CurrentMarketValuation),
8 => sortDirection == "asc" ? summary.OrderBy(z => z.Dividend) : summary.OrderByDescending(z => z.Dividend),
9 => sortDirection == "asc" ? summary.OrderBy(z => z.AbsoluteGainOrLoss) : summary.OrderByDescending(z => z.AbsoluteGainOrLoss),
10 => sortDirection == "asc" ? summary.OrderBy(z => z.AbsoluteGainORLossPercentage) : summary.OrderByDescending(z => z.AbsoluteGainORLossPercentage),
11 => sortDirection == "asc" ? summary.OrderBy(z => z.XIRR) : summary.OrderByDescending(z => z.XIRR),
_ => sortDirection == "desc" ? summary.OrderBy(z => z.PurchaseNav) : summary.OrderByDescending(z => z.PurchaseNav),
};
int filteredconsumableCount = summary.Count();
if (param.iDisplayLength > 0)
{
summary = summary.Skip(param.iDisplayStart).Take(param.iDisplayLength);
}
return(Json(new
{
param.sEcho,
iTotalRecords = totalconsumable,
iTotalDisplayRecords = filteredconsumableCount,
aaData = summary
}));
}
public async Task <AjaxDataTable <CategoryDataTableRow> > GetCategoryDataTable(int Page, int Take, string Search, int OrderColIdx, string OrderDirection)
{
AjaxDataTableDTO <CategoryDataTableRowDTO> categoryAjaxDataTableDTO = await categoryDataTableRepository.GetCategoryDataTable(Page, Take, Search, OrderColIdx, OrderDirection);
AjaxDataTable <CategoryDataTableRow> categoryAjaxDataTable = new AjaxDataTable <CategoryDataTableRow>
{
Draw = categoryAjaxDataTableDTO.Draw,
RecordsFiltered = categoryAjaxDataTableDTO.RecordsFiltered,
RecordsTotal = categoryAjaxDataTableDTO.RecordsTotal,
Data = categoryAjaxDataTableDTO.Data.Select(x => new CategoryDataTableRow
{
Id = x.Id,
Name = x.Name
}).ToList()
};
return(categoryAjaxDataTable);
}
