public ActionResult AjaxSummary(jQueryDataTableParam param)
{
// TODO: investigate if this can be removed
// System.Globalization.CultureInfo CI = (System.Globalization.CultureInfo)Session["Culture"];
// Retrieve WO/WA Summary based on parameters
dataTableResult <WOWASummary> dtr =
woServ.CombinedSummary(param.sSearch,
Request.Form["sSortDir_0"] == "asc" ? false : true, // ???
param.iDisplayStart,
param.iDisplayLength);
//
//return what's left to datatables
var result = from p in dtr.query
select new[] { String.Format("{0:MM/dd/yyyy}", p.date),
p.weekday,
p.pending_wo > 0 ? p.pending_wo.ToString(): null,
p.pending_wa > 0 ? p.pending_wa.ToString(): null,
p.active_wo > 0 ? p.active_wo.ToString(): null,
p.active_wa > 0 ? p.active_wa.ToString(): null,
p.completed_wo > 0 ? p.completed_wo.ToString(): null,
p.completed_wa > 0 ? p.completed_wa.ToString(): null,
p.cancelled_wo > 0 ? p.cancelled_wo.ToString(): null,
p.cancelled_wa > 0 ? p.cancelled_wa.ToString(): null,
p.expired_wo > 0 ? p.expired_wo.ToString(): null,
p.expired_wa > 0 ? p.expired_wa.ToString(): null };
return(Json(new
{
param.sEcho,
iTotalRecords = dtr.totalCount,
iTotalDisplayRecords = dtr.filteredCount,
aaData = result
}));
}
public ActionResult AjaxSummary(jQueryDataTableParam param)
{
// Retrieve WO/WA Summary based on parameters
dataTableResult <WOWASummary> dtr =
_woServ.CombinedSummary(param.sSearch,
Request.Query["sSortDir_0"] != "asc",
param.iDisplayStart,
param.iDisplayLength);
//
//return what's left to datatables
var result = from p in dtr.query
select new[] {
public ActionResult AjaxSummary(jQueryDataTableParam param)
{
if (param.todaysdate != null)
{
var clientDate = DateTime.Parse(param.todaysdate);
var utcDate = TimeZoneInfo.ConvertTimeToUtc(clientDate, _clientTimeZoneInfo);
param.todaysdate = utcDate.ToString(CultureInfo.InvariantCulture);
}
// Retrieve WO/WA Summary based on parameters
dataTableResult <WOWASummary> dtr =
_woServ.CombinedSummary(param.sSearch,
Request.Query["sSortDir_0"] != "asc",
param.iDisplayStart,
param.iDisplayLength);
//
//return what's left to datatables
var result = from p in dtr.query
select new[] {
$"{p.date ?? TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, _clientTimeZoneInfo):MM/dd/yyyy}",
p.weekday,
p.pending_wo > 0 ? p.pending_wo.ToString(): null,
p.pending_wa > 0 ? p.pending_wa.ToString(): null,
p.active_wo > 0 ? p.active_wo.ToString(): null,
p.active_wa > 0 ? p.active_wa.ToString(): null,
p.completed_wo > 0 ? p.completed_wo.ToString(): null,
p.completed_wa > 0 ? p.completed_wa.ToString(): null,
p.cancelled_wo > 0 ? p.cancelled_wo.ToString(): null,
p.cancelled_wa > 0 ? p.cancelled_wa.ToString(): null,
p.expired_wo > 0 ? p.expired_wo.ToString(): null,
p.expired_wa > 0 ? p.expired_wa.ToString(): null
}.ToList();
return(Json(new
{
param.sEcho,
iTotalRecords = dtr.totalCount,
iTotalDisplayRecords = dtr.filteredCount,
aaData = result
}));
}
