public JsonResult AjaxYearAct(jQueryDataTableParam param)
{
DateTime yearDate;
DateTime beginDate;
DateTime endDate;
dataTableResult <ActivityData> year;
yearDate = voDate(param);
//From www.investopedia.com, Fiscal Year-End: The completion of a one-year, or 12-month, accounting period.
//A firm's fiscal year-end does not necessarily need to fall on December 31, and can actually fall on any day throughout the year.
beginDate = yearDate.AddMonths(-12).Date;
endDate = new DateTime(yearDate.Year, yearDate.Month, yearDate.Day, 23, 59, 59);
year = YearActView(beginDate, endDate);
var result = from d in year.query
select new
{
date = "Quarter beginning " + System.String.Format("{0:MMMM d, yyyy}", d.dateStart) + " and ending " + System.String.Format("{0:MMMM d, yyyy}", d.dateEnd),
safety = d.safety.ToString(),
skills = d.skills.ToString(),
esl = d.esl.ToString(),
basGarden = d.basGarden.ToString(),
advGarden = d.advGarden.ToString(),
finEd = d.finEd.ToString(),
osha = d.osha.ToString(),
drilldown = from g in d.drilldown
group g by new { g.info, g.activityType } into x
select new
{
name = x.Key.info,
type = x.Key.activityType,
count = x.Sum(y => y.count)
}
};
return(Json(new
{
iTotalRecords = year.totalCount, //total records, before filtering
iTotalDisplayRecords = year.filteredCount, //total records, after filtering
sEcho = param.sEcho, //unaltered copy of sEcho sent from the client side
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public JsonResult AjaxYwd(jQueryDataTableParam param)
{
DateTime yDate;
DateTime beginDate;
DateTime endDate;
dataTableResult <YearSumData> ywd;
yDate = voDate(param);
beginDate = yDate.AddMonths(-12).Date;
endDate = new DateTime(yDate.Year, yDate.Month, yDate.Day, 23, 59, 59);
ywd = yearSumView(beginDate, endDate);
var result = from d in ywd.query
select new
{
date = System.String.Format("{0:MM/dd/yyyy}", d.dateEnd),
datestring = "Quarter beginning " + System.String.Format("{0:MM/dd/yyyy}", d.dateStart) + " and ending " + System.String.Format("{0:MM/dd/yyyy}", d.dateEnd),
stillHere = d.stillHere.ToString(),
totalSignins = d.totalSignins.ToString(),
wentToClass = d.peopleWhoWentToClass.ToString(),
dispatched = d.dispatched.ToString(),
totalHours = d.totalHours.ToString(),
totalIncome = System.String.Format("{0:C}", d.totalIncome),
avgIncomePerHour = System.String.Format("{0:C}", d.avgIncomePerHour),
drilldown = new
{
newlyEnrolled = d.newlyEnrolled.ToString(), //dd
peopleWhoLeft = d.peopleWhoLeft.ToString(), //dd
uniqueSignins = d.uniqueSignins.ToString(), //dd
tempDispatched = d.tempDispatched.ToString(), //dd
permanentPlacements = d.permanentPlacements.ToString(), //dd
undupDispatched = d.undupDispatched.ToString(), //dd
}
};
return(Json(new
{
iTotalRecords = ywd.totalCount, //total records, before filtering
iTotalDisplayRecords = ywd.filteredCount, //total records, after filtering
sEcho = param.sEcho, //unaltered copy of sEcho sent from the client side
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
var vo = map.Map <jQueryDataTableParam, viewOptions>(param);
dataTableResult <WorkerList> list = serv.GetIndexView(vo);
var result = list.query
.Select(
e => map.Map <WorkerList, ViewModel.WorkerList>(e)
).AsEnumerable();
return(Json(new
{
param.sEcho,
iTotalRecords = list.totalCount,
iTotalDisplayRecords = list.filteredCount,
aaData = result
}));
}
public JsonResult AjaxMonthAct(jQueryDataTableParam param)
{
DateTime monthDate;
DateTime beginDate;
DateTime endDate;
dataTableResult <ActivityData> year;
monthDate = voDate(param);
beginDate = new DateTime(monthDate.Year, monthDate.Month, 1, 0, 0, 0);
endDate = new DateTime(monthDate.Year, monthDate.Month, DateTime.DaysInMonth(monthDate.Year, monthDate.Month), 23, 59, 59);
year = ActivityView(beginDate, endDate, "monthly");
var result = from d in year.query
select new
{
date = System.String.Format("{0:MMMM d, yyyy}", d.dateStart),
safety = d.safety.ToString(),
skills = d.skills.ToString(),
esl = d.esl.ToString(),
basGarden = d.basGarden.ToString(),
advGarden = d.advGarden.ToString(),
finEd = d.finEd.ToString(),
osha = d.osha.ToString(),
drilldown = from g in d.drilldown
group g by new { g.info, g.activityType } into x
select new
{
name = x.Key.info,
type = x.Key.activityType,
count = x.Sum(y => y.count)
}
};
return(Json(new
{
iTotalRecords = year.totalCount, //total records, before filtering
iTotalDisplayRecords = year.filteredCount, //total records, after filtering
sEcho = param.sEcho, //unaltered copy of sEcho sent from the client side
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public JsonResult AjaxMwd(jQueryDataTableParam param)
{
DateTime monthDate;
DateTime beginDate;
DateTime endDate;
dataTableResult <MonthlySumData> mwd;
monthDate = voDate(param);
beginDate = new DateTime(monthDate.Year, monthDate.Month, 1, 0, 0, 0);
endDate = new DateTime(monthDate.Year, monthDate.Month, System.DateTime.DaysInMonth(monthDate.Year, monthDate.Month));
mwd = monthSumView(beginDate, endDate);
var result = from d in mwd.query
select new
{
date = System.String.Format("{0:MM/dd/yyyy}", d.dateStart),
datestring = System.String.Format("{0:MMMM d}", d.dateStart),
stillHere = d.stillHere.ToString(),
totalSignins = d.totalSignins.ToString(),
wentToClass = d.peopleWhoWentToClass.ToString(),
dispatched = d.dispatched.ToString(),
totalHours = d.totalHours.ToString(),
totalIncome = System.String.Format("{0:C}", d.totalIncome),
avgIncomePerHour = System.String.Format("{0:C}", d.avgIncomePerHour),
drilldown = new
{
newlyEnrolled = d.newlyEnrolled.ToString(), //dd
peopleWhoLeft = d.peopleWhoLeft.ToString(), //dd
uniqueSignins = d.uniqueSignins.ToString(), //dd
tempDispatched = d.tempDispatched.ToString(), //dd
permanentPlacements = d.permanentPlacements.ToString(), //dd
undupDispatched = d.undupDispatched.ToString(), //dd
}
};
return(Json(new
{
iTotalRecords = mwd.totalCount, //total records, before filtering
iTotalDisplayRecords = mwd.filteredCount, //total records, after filtering
sEcho = param.sEcho, //unaltered copy of sEcho sent from the client side
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
var vo = map.Map <jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
dataTableResult <Service.DTO.WorkerSigninList> was = serv.GetIndexView(vo);
var result = was.query
.Select(e => map.Map <DTO.WorkerSigninList, ViewModel.WorkerSigninList>(e))
.AsEnumerable();
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = was.totalCount,
iTotalDisplayRecords = was.filteredCount,
aaData = result
}));
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
//Get all the records
var vo = _map.Map <jQueryDataTableParam, viewOptions>(param);
dataTableResult <EventList> list = _eventServ.GetIndexView(vo);
//return what's left to datatables
var result = list.query
.Select(e => _map.Map <EventList, ViewModel.EventList>(e))
.AsEnumerable();
return(Json(new
{
param.sEcho,
iTotalRecords = list.totalCount,
iTotalDisplayRecords = list.filteredCount,
aaData = result
}));
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
//Get all the records
var vo = map.Map <jQueryDataTableParam, viewOptions>(param);
IEnumerable <LookupList> list = serv.GetIndexView(vo);
var result = list
.Select(
e => map.Map <LookupList, ViewModel.LookupList>(e)
).AsEnumerable();
return(Json(new
{
param.sEcho,
iTotalRecords = serv.TotalCount(),
iTotalDisplayRecords = serv.TotalCount(),
aaData = result
}));
}
public JsonResult AjaxHandler(jQueryDataTableParam param)
{
var vo = map.Map <jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
dataTableResult <EmployersList> list = serv.GetIndexView(vo);
//return what's left to datatables
var result = list.query
.Select(e => map.Map <EmployersList, EmployerList>(e))
.AsEnumerable();
return(Json(new
{
param.sEcho,
iTotalRecords = list.totalCount,
iTotalDisplayRecords = list.filteredCount,
aaData = result
}));
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
var vo = map.Map <jQueryDataTableParam, viewOptions>(param);
dataTableResult <ActivitySigninList> list = serv.GetIndexView(vo);
MapperHelpers.ClientTimeZoneInfo = _clientTimeZoneInfo;
var result = list.query
.Select(
e => map.Map <ActivitySigninList, ViewModel.ActivitySigninList>(e)
).AsEnumerable();
return(Json(new
{
param.sEcho,
iTotalRecords = list.totalCount,
iTotalDisplayRecords = list.filteredCount,
aaData = result
}));
}
public JsonResult AjaxWec(jQueryDataTableParam param)
{
DateTime weekDate;
DateTime beginDate;
DateTime endDate;
dataTableResult <WeeklySumData> wec;
// jQuery passes in parameters that must be mapped to viewOptions
weekDate = voDate(param);
beginDate = weekDate.AddDays(-6).Date;
endDate = new DateTime(weekDate.Year, weekDate.Month, weekDate.Day, 23, 59, 59);
wec = WeekSumView(beginDate, endDate);
var result = from d in wec.query
select new
{
weekday = d.dayofweek.ToString(),
date = System.String.Format("{0:MM/dd/yyyy}", d.date),
totalSignins = d.totalSignins,
totalAssignments = d.noWeekJobs,
weekEstDailyHours = d.weekEstDailyHours,
weekEstPayment = System.String.Format("{0:C}", d.weekEstPayment),
weekHourlyWage = System.String.Format("{0:C}", d.weekHourlyWage),
drilldown = from j in d.topJobs
select new
{
// date = System.String.Format("{0:MM/dd/yyyy}", j.date),
skill = j.info,
count = j.count
}
};
return(Json(new
{
iTotalRecords = wec.totalCount, //total records, before filtering
iTotalDisplayRecords = wec.filteredCount, //total records, after filtering
sEcho = param.sEcho, //unaltered copy of sEcho sent from the client side
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
MapperHelpers.ClientTimeZoneInfo = _clientTimeZoneInfo;
var vo = _map.Map <jQueryDataTableParam, viewOptions>(param);
dataTableResult <WorkerSigninList> was = _serv.GetIndexView(vo);
var result = was.query
.Select(e => _map.Map <WorkerSigninList, ViewModel.WorkerSigninList>(e))
.ToList();
return(Json(new
{
param.sEcho,
iTotalRecords = was.totalCount,
iTotalDisplayRecords = was.filteredCount,
aaData = result
}));
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
//Get all the records
var vo = map.Map <jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
dataTableResult <DTO.PersonList> list = serv.GetIndexView(vo);
var result = list.query
.Select(e => map.Map <DTO.PersonList, ViewModel.PersonList>(e))
.AsEnumerable();
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.totalCount,
iTotalDisplayRecords = list.filteredCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
var vo = map.Map <jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
//Get all the records
dataTableResult <WorkOrdersList> dtr = woServ.GetIndexView(vo);
var result = dtr.query
.Select(
e => map.Map <WorkOrdersList, ViewModel.WorkOrdersList>(e)
).AsEnumerable();
return(Json(new
{
param.sEcho,
iTotalRecords = dtr.totalCount,
iTotalDisplayRecords = dtr.filteredCount,
aaData = result
}));
}
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
}));
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
MapperHelpers.ClientTimeZoneInfo = _clientTimeZoneInfo;
var vo = _map.Map <jQueryDataTableParam, viewOptions>(param);
//Get all the records
var dataTableResult = _woServ.GetIndexView(vo);
var result = dataTableResult.query
.Select(
e => _map.Map <WorkOrdersList, ViewModel.WorkOrdersList>(e)
).AsEnumerable();
return(Json(new
{
param.sEcho,
iTotalRecords = dataTableResult.totalCount,
iTotalDisplayRecords = dataTableResult.filteredCount,
aaData = result
}));
}
public JsonResult AjaxHandler(jQueryDataTableParam param)
{
dataTableResult <EmployersList> list;
try {
var vo = _map.Map <jQueryDataTableParam, viewOptions>(param);
list = _serv.GetIndexView(vo);
}
catch (Exception ex) {
throw ex; // TODO Chaim plz
}
//return what's left to datatables
var result = list.query
.Select(e => _map.Map <Service.DTO.EmployersList, ViewModel.EmployerList>(e))
.AsEnumerable();
return(Json(new
{
param.sEcho,
iTotalRecords = list.totalCount,
iTotalDisplayRecords = list.filteredCount,
aaData = result
}));
}
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["sSortDir_0"] == "asc" ? false : true,
param.iDisplayStart,
param.iDisplayLength);
//
//return what's left to datatables
var result = from p in dtr.query
select new[] { System.String.Format("{0:MM/dd/yyyy}", p.date),
p.weekday.ToString(),
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
{
sEcho = param.sEcho,
iTotalRecords = dtr.totalCount,
iTotalDisplayRecords = dtr.filteredCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public JsonResult AjaxHandler(jQueryDataTableParam param)
{
//Get all the records
var vo = _map.Map <jQueryDataTableParam, viewOptions>(param);
var culture = Request.HttpContext.Features.Get <IRequestCultureFeature>().RequestCulture.UICulture;
dataTableResult <ActivityList> list = _serv.GetIndexView(vo, culture.TwoLetterISOLanguageName);
MapperHelpers.ClientTimeZoneInfo = _clientTimeZoneInfo;
var result = list.query
.Select(
e => _map.Map <ActivityList, ViewModel.ActivityList>(e)
).AsEnumerable();
return(Json(new
{
param.sEcho,
iTotalRecords = list.totalCount,
iTotalDisplayRecords = list.filteredCount,
aaData = result
}));
}
