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); }