public JsonResult AjaxMonthWkr(jQueryDataTableParam param)
{
DateTime mDate;
DateTime beginDate;
DateTime endDate;
mDate = voDate(param);
beginDate = new DateTime(mDate.Year, mDate.Month, 1, 0, 0, 0);
endDate = new DateTime(mDate.Year, mDate.Month, System.DateTime.DaysInMonth(mDate.Year, mDate.Month));
dataTableResult <NewWorkerData> newWkr = NewWorkerView(beginDate, endDate, "monthly");
var result = from d in newWkr.query
select new
{
date = System.String.Format("{0:MMMM d}", d.dateStart),
singleAdults = d.singleAdults.ToString(),
familyHouseholds = d.familyHouseholds.ToString(),
newSingleAdults = d.newSingleAdults.ToString(),
newFamilyHouseholds = d.newFamilyHouseholds.ToString(),
zipCompleteness = d.zipCompleteness
};
return(Json(new
{
iTotalRecords = newWkr.totalCount,
iTotalDisplayRecords = newWkr.filteredCount,
sEcho = param.sEcho,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public JsonResult AjaxYearWkr(jQueryDataTableParam param)
{
DateTime yDate;
DateTime beginDate;
DateTime endDate;
yDate = voDate(param);
beginDate = yDate.AddMonths(-12).Date;
endDate = new DateTime(yDate.Year, yDate.Month, yDate.Day, 23, 59, 59);
dataTableResult <NewWorkerData> newWkr = NewWorkerView(beginDate, endDate, "yearly");
var result = from d in newWkr.query
select new
{
date = System.String.Format("{0:MM/d/yyyy}", d.dateStart) + " to " + System.String.Format("{0:MM/d/yyyy}", d.dateEnd),
singleAdults = d.singleAdults.ToString(),
familyHouseholds = d.familyHouseholds.ToString(),
newSingleAdults = d.newSingleAdults.ToString(),
newFamilyHouseholds = d.newFamilyHouseholds.ToString(),
zipCompleteness = d.zipCompleteness
};
return(Json(new
{
iTotalRecords = newWkr.totalCount,
iTotalDisplayRecords = newWkr.filteredCount,
sEcho = param.sEcho,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public JsonResult AjaxDcl(jQueryDataTableParam param)
{
DateTime dclDate;
dclDate = voDate(param);
// pass filter parameters to service level
// Call view model from service layer:
dataTableResult <DailySumData> dcl = DaySumView(dclDate);
//
//return what's left to datatables
var result = from d in dcl.query
select new
{
date = System.String.Format("{0:MM/dd/yyyy}", d.date),
dwcList = d.dwcList,
dwcPropio = d.dwcPropio,
hhhList = d.hhhList,
hhhPropio = d.hhhPropio,
uniqueSignins = d.uniqueSignins,
totalSignins = d.totalSignins,
totalAssignments = d.totalAssignments,
cancelledJobs = d.cancelledJobs
};
return(Json(new
{
iTotalRecords = dcl.totalCount, //total records, before filtering
iTotalDisplayRecords = dcl.filteredCount, //total records, after filtering
sEcho = param.sEcho, //unaltered copy of sEcho sent from the client side
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public JsonResult AjaxWeekWkr(jQueryDataTableParam param)
{
DateTime wDate;
DateTime beginDate;
DateTime endDate;
wDate = voDate(param);
beginDate = wDate.AddDays(-6).Date;
endDate = new DateTime(wDate.Year, wDate.Month, wDate.Day, 23, 59, 59);
dataTableResult <NewWorkerData> newWkr = NewWorkerView(beginDate, endDate, "weekly");
var result = from d in newWkr.query
orderby d.dateStart ascending
select new
{
date = System.String.Format("{0:dddd}", d.dateStart),
singleAdults = d.singleAdults.ToString(),
familyHouseholds = d.familyHouseholds.ToString(),
newSingleAdults = d.newSingleAdults.ToString(),
newFamilyHouseholds = d.newFamilyHouseholds.ToString(),
zipCompleteness = d.zipCompleteness
};
return(Json(new
{
iTotalRecords = newWkr.totalCount,
iTotalDisplayRecords = newWkr.filteredCount,
sEcho = param.sEcho,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public void GetIndexView()
{
//
//Arrange
// get find latest workorder, get date from it, and add a day (make sure we're only records for this test)
var Date = frb.ToServ <IWorkOrderService>().GetSummary().OrderByDescending(a => a.date).First().date.Value.AddDays(1);
frb.AddWorkOrder(dateTimeOfWork: Date).AddWorkOrder(dateTimeOfWork: Date).AddWorkOrder(dateTimeOfWork: Date);
frb.AddWorkOrder(dateTimeOfWork: Date).AddWorkOrder(dateTimeOfWork: Date).AddWorkOrder(dateTimeOfWork: Date);
viewOptions o = new viewOptions();
o.CI = new CultureInfo("en-US", false);
o.sSearch = Date.ToShortDateString();
o.EmployerID = null;
o.status = null;
o.orderDescending = true;
o.displayStart = 0;
o.displayLength = 20;
o.sortColName = "WOID";
//
//Act
dataTableResult <DTO.WorkOrdersList> result = frb.ToServ <IWorkOrderService>().GetIndexView(o);
//
//Assert
IEnumerable <DTO.WorkOrdersList> query = result.query.ToList();
Assert.IsNotNull(result, "IEnumerable is Null");
Assert.IsNotNull(query, "IEnumerable.query is null");
Assert.AreEqual(6, query.Count(), "Expected 6, but GetIndexView returned {0} records", query.Count());
}
/// <summary>
/// GET: /Activity/AjaxHandler
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
//[Authorize(Roles = "Administrator, Manager, Teacher")]
public JsonResult AjaxHandler(jQueryDataTableParam param)
{
//Get all the records
var vo = map.Map <jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
if (!User.Identity.IsAuthenticated)
{
vo.authenticated = false;
}
dataTableResult <DTO.ActivityList> list = serv.GetIndexView(vo);
var result = list.query
.Select(
e => map.Map <DTO.ActivityList, ViewModel.ActivityList>(e)
).AsEnumerable();
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.totalCount,
iTotalDisplayRecords = list.filteredCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
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 JsonResult AjaxHandler(jQueryDataTableParam param)
{
//Get all the records
var vo = map.Map <jQueryDataTableParam, viewOptions>(param);
dataTableResult <Email> list = serv.GetIndexView(vo);
return(Json(new
{
param.sEcho,
iTotalRecords = list.totalCount,
iTotalDisplayRecords = list.filteredCount,
aaData = from p in list.query
select new
{
recordid = Convert.ToString(p.ID),
//relatedTo = _getRelatedTo(p),
tabref = _getTabRef(p),
tablabel = _getTabLabel(p),
p.emailFrom,
p.emailTo,
p.subject,
status = def.byID(p.statusID),
transmitAttempts = p.transmitAttempts.ToString(),
lastAttempt = p.lastAttempt.ToString(),
dateupdated = Convert.ToString(p.dateupdated),
p.updatedby,
hasAttachment = string.IsNullOrEmpty(p.attachment) ? Shared.False : Shared.True
}
}));
}
public JsonResult AjaxMonthEmp(jQueryDataTableParam param)
{
DateTime mDate;
DateTime beginDate;
DateTime endDate;
mDate = voDate(param);
beginDate = new DateTime(mDate.Year, mDate.Month, 1, 0, 0, 0);
endDate = new DateTime(mDate.Year, mDate.Month, System.DateTime.DaysInMonth(mDate.Year, mDate.Month));
dataTableResult <ZipModel> newEmp = EmployerReportView(beginDate, endDate);
var result = from d in newEmp.query
select new
{
zips = d.zips.ToString(),
jobs = d.jobs.ToString(),
emps = d.emps.ToString(),
drilldown = from j in d.skills
select new
{
skill = j.info,
count = j.count
}
};
return(Json(new
{
iTotalRecords = newEmp.totalCount,
iTotalDisplayRecords = newEmp.filteredCount,
sEcho = param.sEcho,
aaData = result
}));
}
public JsonResult AjaxHandler(jQueryDataTableParam param)
{
//Get all the records
var vo = map.Map <jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
dataTableResult <Domain.Email> list = serv.GetIndexView(vo);
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.totalCount,
iTotalDisplayRecords = list.filteredCount,
aaData = from p in list.query
select new
{
recordid = Convert.ToString(p.ID),
//relatedTo = _getRelatedTo(p),
tabref = _getTabRef(p),
tablabel = _getTabLabel(p),
emailFrom = p.emailFrom,
emailTo = p.emailTo,
subject = p.subject,
status = lcache.textByID(p.statusID, CI.TwoLetterISOLanguageName),
transmitAttempts = p.transmitAttempts.ToString(),
lastAttempt = p.lastAttempt.ToString(),
dateupdated = Convert.ToString(p.dateupdated),
updatedby = p.updatedby,
hasAttachment = string.IsNullOrEmpty(p.attachment) ? Shared.False : Shared.True
}
},
JsonRequestBehavior.AllowGet));
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
if (param.todaysdate != null)
{
var clientDate = DateTime.Parse(param.todaysdate);
var utcDate = TimeZoneInfo.ConvertTimeToUtc(clientDate, _clientTimeZoneInfo);
param.todaysdate = utcDate.ToString(CultureInfo.InvariantCulture);
}
//Get all the records
var vo = map.Map <jQueryDataTableParam, viewOptions>(param);
dataTableResult <WorkAssignmentsList> was = waServ.GetIndexView(vo);
MapperHelpers.ClientTimeZoneInfo = _clientTimeZoneInfo;
var result = was.query
.Select(e => map.Map <WorkAssignmentsList, ViewModel.WorkAssignmentsList>(e))
.AsEnumerable();
return(Json(new
{
param.sEcho,
iTotalRecords = was.totalCount,
iTotalDisplayRecords = was.filteredCount,
aaData = result
}));
}
/// <summary>
/// GET: /Activity/AjaxHandler
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
//[Authorize(Roles = "Administrator, Manager, Teacher")]
public JsonResult AjaxHandler(jQueryDataTableParam param)
{
//Get all the records
var vo = map.Map <jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
var userIdentity = new ClaimsIdentity("Cookies");
if (!userIdentity.IsAuthenticated)
{
vo.authenticated = false;
}
dataTableResult <ActivityList> list = serv.GetIndexView(vo);
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
}));
}
public ActionResult AjaxYearEmp(jQueryDataTableParam param)
{
DateTime yDate;
DateTime beginDate;
DateTime endDate;
yDate = voDate(param);
beginDate = yDate.AddMonths(-12).Date;
endDate = new DateTime(yDate.Year, yDate.Month, yDate.Day, 23, 59, 59);
dataTableResult <ZipModel> newEmp = EmployerReportView(beginDate, endDate);
var result = from d in newEmp.query
select new
{
zips = d.zips.ToString(),
jobs = d.jobs.ToString(),
emps = d.emps.ToString(),
drilldown = from j in d.skills
select new
{
skill = j.info,
count = j.count
}
};
return(Json(new
{
iTotalRecords = newEmp.totalCount,
iTotalDisplayRecords = newEmp.filteredCount,
sEcho = param.sEcho,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
private dataTableResult <T> GetDataTableResult <T>(IEnumerable <T> query)
{
var result = new dataTableResult <T>();
result.filteredCount = query.Count();
result.query = query;
result.totalCount = query.Count();
return(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 Get()
{
var vo = new viewOptions();
vo.displayLength = 10;
vo.displayStart = 0;
dataTableResult <DTO.WorkAssignmentsList> list = serv.GetIndexView(vo);
var result = list.query
.Select(
e => map.Map <DTO.WorkAssignmentsList, Machete.Web.ViewModel.Api.WorkAssignment>(e)
).AsEnumerable();
return(new JsonResult(new { data = result }));
}
public IHttpActionResult Get()
{
var vo = new viewOptions();
vo.displayLength = 10;
vo.displayStart = 0;
dataTableResult <DTO.EmployersList> list = serv.GetIndexView(vo);
var result = list.query
.Select(
e => map.Map <DTO.EmployersList, ViewModel.EmployersList>(e)
).AsEnumerable();
return(Json(new { data = result }));
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
//Get all the records
var vo = map.Map <jQueryDataTableParam, viewOptions>(param);
dataTableResult <PersonList> list = serv.GetIndexView(vo);
var result = list.query
.Select(e => map.Map <PersonList, ViewModel.PersonList>(e))
.AsEnumerable();
return(Json(new {
param.sEcho,
iTotalRecords = list.totalCount,
iTotalDisplayRecords = list.filteredCount,
aaData = result
}));
}
public IHttpActionResult Get()
{
var vo = new viewOptions();
vo.displayLength = 500; // TODO dumping on the client; will address Angular using search later
vo.displayStart = 0;
vo.employerGuid = userSubject;
vo.CI = Thread.CurrentThread.CurrentCulture;
dataTableResult <Service.DTO.WorkOrdersList> list = woServ.GetIndexView(vo);
var result = list.query
.Select(
e => map.Map <Service.DTO.WorkOrdersList, ViewModel.WorkOrder>(e)
).AsEnumerable();
return(Json(new { data = result }));
}
public ActionResult Get()
{
var vo = new viewOptions();
vo.displayLength = 10;
vo.displayStart = 0;
vo.employerGuid = UserSubject;
dataTableResult <DTO.WorkOrdersList> list = _serv.GetIndexView(vo);
MapperHelpers.ClientTimeZoneInfo = _clientTimeZoneInfo;
var result = list.query
.Select(
e => _map.Map <DTO.WorkOrdersList, ViewModel.Api.WorkOrder>(e)
).AsEnumerable();
return(new JsonResult(new { data = result }));
}
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 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 void GetIndexView_check_search_dwccardnum()
{
//
// Arrange
frb.AddWorker(skill1: 63).AddWorkerSignin();
var w = frb.ToWorker();
var wsi = frb.ToWorkerSignin();
//
//Act
_dOptions.dwccardnum = w.dwccardnum;
dataTableResult <DTO.WorkerSigninList> result = frb.ToServ <IWorkerSigninService>().GetIndexView(_dOptions);
//
//Assert
List <DTO.WorkerSigninList> tolist = result.query.ToList();
Assert.AreEqual(1, result.query.Count());
Assert.AreEqual(63, tolist[0].skill1);
}
public ActionResult <IEnumerable <WorkOrderVM> > Get()
{
var vo = new viewOptions();
vo.displayLength = 500; // TODO dumping on the client; will address Angular using search later
vo.displayStart = 0;
vo.employerGuid = UserSubject;
vo.CI = Thread.CurrentThread.CurrentCulture;
dataTableResult <Service.DTO.WorkOrdersList> list = serv.GetIndexView(vo);
MapperHelpers.ClientTimeZoneInfo = _clientTimeZoneInfo;
var result = list.query
.Select(
e => map.Map <Service.DTO.WorkOrdersList, WorkOrderVM>(e)
).AsEnumerable();
return(Ok(new { data = result }));
}
public new ActionResult <WorkOrderVM> Get(
[FromQuery] ApiRequestParams apiRequestParams)
{
var vo = new viewOptions();
vo.displayLength = apiRequestParams.pageSize;
vo.displayStart = apiRequestParams.Skip;
vo.employerGuid = UserSubject;
dataTableResult <DTO.WorkOrdersList> list = serv.GetIndexView(vo);
MapperHelpers.ClientTimeZoneInfo = _clientTimeZoneInfo;
var result = list.query
.Select(
e => map.Map <DTO.WorkOrdersList, WorkOrderVM>(e)
).AsEnumerable();
return(Ok(new { data = result }));
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
var vo = map.Map <jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
dataTableResult <DTO.WorkerList> list = serv.GetIndexView(vo);
var result = list.query
.Select(
e => map.Map <DTO.WorkerList, ViewModel.WorkerList>(e)
).AsEnumerable();
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.totalCount,
iTotalDisplayRecords = list.filteredCount,
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)
{
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 void GetIndexView_workerRequested()
{
// Arrange
var worker = frb.AddWorker(skill1: 63);
frb.AddWorkerSignin(worker);
frb.AddWorkerRequest(worker);
//
//Act
_dOptions.dwccardnum = worker.dwccardnum;
_dOptions.wa_grouping = "requested";
var wsi = frb.ToServ <IWorkerSigninService>();
dataTableResult <DTO.WorkerSigninList> result = wsi.GetIndexView(_dOptions);
//
//Assert
List <DTO.WorkerSigninList> tolist = result.query.ToList();
Assert.AreEqual(63, tolist[0].skill1);
Assert.AreEqual(1, result.query.Count());
}
