public JsonResult AjaxHandler(jQueryDataTableParam param)
{
//Get all the records
var vo = Mapper.Map<jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
dataTableResult<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)
{
//Get all the records
var vo = Mapper.Map<jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
dataTableResult<Person> list = personService.GetIndexView(vo);
var result = from p in list.query select new
{
tabref = "/Person/Edit/" + Convert.ToString(p.ID),
tablabel = p.firstname1 + ' ' + p.lastname1,
dwccardnum = p.Worker == null ? "" : p.Worker.dwccardnum.ToString(),
active = p.active ? Shared.True : Shared.False,
status = p.active,
workerStatus = p.Worker == null ? "Not a worker" : lcache.textByID(p.Worker.memberStatus, CI.TwoLetterISOLanguageName),
firstname1 = p.firstname1,
firstname2 = p.firstname2,
lastname1 = p.lastname1,
lastname2 = p.lastname2,
phone = p.phone,
dateupdated = Convert.ToString(p.dateupdated),
Updatedby = p.Updatedby,
recordid = Convert.ToString(p.ID)
};
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.totalCount,
iTotalDisplayRecords = list.filteredCount,
aaData = result
},
JsonRequestBehavior.AllowGet);
}
/// <summary>
/// GET: /Employer/AjaxHandler
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public JsonResult AjaxHandler(jQueryDataTableParam param)
{
var vo = Mapper.Map<jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
dataTableResult<Employer> list = serv.GetIndexView(vo);
//return what's left to datatables
var result = from p in list.query select new
{
tabref = _getTabRef(p),
tablabel = _getTabLabel(p),
active = Convert.ToString(p.active),
EID = Convert.ToString(p.ID),
recordid = Convert.ToString(p.ID),
name = p.name,
address1 = p.address1,
city = p.city,
phone = p.phone,
driverslicense = p.driverslicense,
licenseplate = p.licenseplate,
dateupdated = Convert.ToString(p.dateupdated),
Updatedby = p.Updatedby,
onlineSource = p.onlineSource ? Shared.True : Shared.False
};
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.totalCount,
iTotalDisplayRecords = list.filteredCount,
aaData = result
},
JsonRequestBehavior.AllowGet);
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
var vo = Mapper.Map<jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
dataTableResult<Worker> list = serv.GetIndexView(vo);
var result = from p in list.query select new
{
tabref = "/Worker/Edit/" + Convert.ToString(p.ID),
tablabel = p.Person.firstname1 + ' ' + p.Person.lastname1,
WID = p.ID.ToString(),
recordid = p.ID.ToString(),
dwccardnum = Convert.ToString(p.dwccardnum),
active = Convert.ToString(p.active),
wkrStatus = _getStatus(p),
firstname1 = p.Person.firstname1,
firstname2 = p.Person.firstname2,
lastname1 = p.Person.lastname1,
lastname2 = p.Person.lastname2,
memberexpirationdate = Convert.ToString(p.memberexpirationdate)
};
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.totalCount,
iTotalDisplayRecords = list.filteredCount,
aaData = result
},
JsonRequestBehavior.AllowGet);
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
//Get all the records
var vo = Mapper.Map<jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
dataTableResult<WorkAssignment> was = waServ.GetIndexView(vo);
var result = from p in was.query select new {
tabref = _getTabRef(p),
tablabel = _getTabLabel(p),
WOID = Convert.ToString(p.workOrderID),
WAID = Convert.ToString(p.ID),
recordid = Convert.ToString(p.ID),
pWAID = p.getFullPseudoID(),
employername = p.workOrder.Employer.name,
englishlevel = Convert.ToString(p.englishLevelID),
skill = lcache.textByID(p.skillID, CI.TwoLetterISOLanguageName),
hourlywage = System.String.Format("${0:f2}", p.hourlyWage),
hours = Convert.ToString(p.hours),
hourRange = p.hourRange > 0 ? Convert.ToString(p.hourRange) : "",
days = Convert.ToString(p.days),
description = p.description, // WA description now matches WO description unless they change it, see Create method
datecreated = Convert.ToString(p.datecreated),
dateupdated = Convert.ToString(p.dateupdated),
updatedby = p.Updatedby,
dateTimeofWork = p.workOrder.dateTimeofWork.AddHours(Convert.ToDouble(WebConfigurationManager.AppSettings["TimeZoneDifferenceFromPacific"])).ToString(),
timeofwork = p.workOrder.dateTimeofWork.AddHours(Convert.ToDouble(WebConfigurationManager.AppSettings["TimeZoneDifferenceFromPacific"])).ToShortTimeString(),
status = p.workOrder.status.ToString(),
earnings = System.String.Format("${0:f2}",p.getMinEarnings),
maxEarnings = System.String.Format("${0:f2}", p.getMaxEarnings),
WSIID = p.workerSigninID ?? 0,
WID = p.workerAssignedID ?? 0,
assignedWorker = p.workerAssigned != null ? p.workerAssigned.dwccardnum + " " + p.workerAssigned.Person.fullName() : "",
requestedList = p.workOrder.workerRequests.Select(a => a.fullNameAndID).ToArray(),
asmtStatus = _getStatus(p)
};
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = was.totalCount,
iTotalDisplayRecords = was.filteredCount,
aaData = result
},
JsonRequestBehavior.AllowGet);
}
/// <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 = Mapper.Map<jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
if (!User.Identity.IsAuthenticated) vo.authenticated = false;
dataTableResult<Activity> list = serv.GetIndexView(vo);
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = list.totalCount,
iTotalDisplayRecords = list.filteredCount,
aaData = from p in list.query
select dtResponse(ref p)
},
JsonRequestBehavior.AllowGet);
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
var vo = Mapper.Map<jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
dataTableResult<wsiView> was = _serv.GetIndexView(vo);
//return what's left to datatables
var result = from p in was.query select new
{
WSIID = p.ID,
recordid = p.ID.ToString(),
dwccardnum = p.dwccardnum,
fullname = p.fullname,
firstname1 = p.firstname1,
firstname2 = p.firstname2,
lastname1 = p.lastname1,
lastname2 = p.lastname2,
dateforsignin = p.dateforsignin.AddHours(Convert.ToDouble(WebConfigurationManager.AppSettings["TimeZoneDifferenceFromPacific"])).ToString(),
dateforsigninstring = p.dateforsignin.AddHours(Convert.ToDouble(WebConfigurationManager.AppSettings["TimeZoneDifferenceFromPacific"])).ToShortTimeString(),
WAID = p.waid ?? 0,
memberStatus = lcache.textByID(p.memberStatus, CI.TwoLetterISOLanguageName),
memberInactive = p.w.isInactive,
memberSanctioned = p.w.isSanctioned,
memberExpired = p.w.isExpired,
memberExpelled = p.w.isExpelled,
imageID = p.imageID,
lotterySequence = p.lotterySequence,
expirationDate = p.expirationDate.ToShortDateString(),
skills = _getSkillCodes(p.englishlevel, p.skill1, p.skill2, p.skill3),
program = lcache.getByID(p.typeOfWorkID).ltrCode
};
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = was.totalCount,
iTotalDisplayRecords = was.filteredCount,
aaData = result
},
JsonRequestBehavior.AllowGet);
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
//Get all the records
var vo = Mapper.Map<jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
IEnumerable<Lookup> list = serv.GetIndexView(vo);
var result = from p in list
select new
{
tabref = "/Config/Edit/" + Convert.ToString(p.ID),
tablabel = p.category + ' ' + p.text_EN,
category = p.category,
selected = p.selected,
text_EN = p.text_EN,
text_ES = p.text_ES,
subcategory = p.subcategory,
level = p.level,
//wage = p.wage,
//minHour = p.minHour,
//fixedJob = p.fixedJob,
//sortorder = p.sortorder,
//typeOfWorkID = p.typeOfWorkID,
//specialtiy = p.speciality,
ltrCode = p.ltrCode,
dateupdated = Convert.ToString(p.dateupdated),
Updatedby = p.Updatedby,
recordid = Convert.ToString(p.ID)
};
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = serv.TotalCount(),
iTotalDisplayRecords = serv.TotalCount(),
aaData = result
},
JsonRequestBehavior.AllowGet);
}
/// <summary>
///
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
//[Authorize(Roles = "Administrator, Manager, Check-in")]
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
var vo = Mapper.Map<jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
dataTableResult<asiView> was = serv.GetIndexView(vo);
//return what's left to datatables
var result = from p in was.query
select new
{
WSIID = p.ID,
recordid = p.ID.ToString(),
dwccardnum = p.dwccardnum,
fullname = p.fullname,
firstname1 = p.firstname1,
firstname2 = p.firstname2,
lastname1 = p.lastname1,
lastname2 = p.lastname2,
dateforsignin = p.dateforsignin,
dateforsigninstring = p.dateforsignin.ToShortDateString(),
memberStatus = lcache.textByID(p.memberStatus, CI.TwoLetterISOLanguageName),
memberInactive = p.w.isInactive,
memberSanctioned = p.w.isSanctioned,
memberExpired = p.w.isExpired,
memberExpelled = p.w.isExpelled,
imageID = p.imageID,
expirationDate = p.expirationDate.ToShortDateString(),
};
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = was.totalCount,
iTotalDisplayRecords = was.filteredCount,
aaData = result
},
JsonRequestBehavior.AllowGet);
}
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
var vo = Mapper.Map<jQueryDataTableParam, viewOptions>(param);
vo.CI = this.CI;
// Retrieve employer ID of signed in Employer
string employerID = HttpContext.User.Identity.GetUserId();
Employer employer = eServ.GetRepo().GetAllQ().Where(e => e.onlineSigninID == employerID).FirstOrDefault();
if (employer != null)
{
vo.EmployerID = employer.ID;
}
else
{
// TODO: add error processing.
}
//Get all the records
dataTableResult<WorkOrder> dtr = woServ.GetIndexView(vo);
// TODO: investigate this
param.showOrdersWorkers = true;
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = dtr.totalCount,
iTotalDisplayRecords = dtr.filteredCount,
aaData = from p in dtr.query
select dtResponse (p, param.showOrdersWorkers)
},
JsonRequestBehavior.AllowGet);
}
//
//
public ActionResult AjaxHandler(jQueryDataTableParam param)
{
//Get all the records
var vo = Mapper.Map<jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
dataTableResult<Event> list = _serv.GetIndexView(vo);
//return what's left to datatables
var result = from p in list.query select new
{
tabref = _getTabRef(p),
tablabel = _getTabLabel(p, CI.TwoLetterISOLanguageName),
recordid = p.ID,
notes = p.notes,
datefrom = p.dateFrom.ToShortDateString(),
dateto = p.dateTo == null ? "" : ((DateTime)p.dateTo).ToShortDateString(),
fileCount = p.JoinEventImages.Count(),
type = lcache.textByID(p.eventType, CI.TwoLetterISOLanguageName),
dateupdated = Convert.ToString(p.dateupdated),
Updatedby = p.Updatedby
};
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["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 ActionResult AjaxHandler(jQueryDataTableParam param)
{
var vo = Mapper.Map<jQueryDataTableParam, viewOptions>(param);
vo.CI = CI;
//Get all the records
dataTableResult<WorkOrder> dtr = woServ.GetIndexView(vo);
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = dtr.totalCount,
iTotalDisplayRecords = dtr.filteredCount,
aaData = from p in dtr.query
select dtResponse( p, param.showOrdersWorkers)
},
JsonRequestBehavior.AllowGet);
}
