public ActionResult LoadRelationships(IJqueryDatatableParam param) { List <Tuple <int, string> > sort = new List <Tuple <int, string> >(); if (!string.IsNullOrEmpty(param.sSortDir_0)) { sort.Add(new Tuple <int, string>(param.iSortCol_0, param.sSortDir_0)); } if (!string.IsNullOrEmpty(param.sSortDir_1)) { sort.Add(new Tuple <int, string>(param.iSortCol_1, param.sSortDir_1)); } if (!string.IsNullOrEmpty(param.sSortDir_2)) { sort.Add(new Tuple <int, string>(param.iSortCol_2, param.sSortDir_2)); } var items = _relationshipRepository.GetRelationships(); if (sort.Any()) { var sortItem = sort.First(); var sortColumn = sortItem.Item1; var sortDirection = sortItem.Item2; switch (sortColumn) { case 0: items = sortDirection == "asc" ? items.OrderBy(c => c.RelationshipId) : items.OrderByDescending(c => c.RelationshipId); break; case 1: items = sortDirection == "asc" ? items.OrderBy(c => c.Description) : items.OrderByDescending(c => c.Description); break; } } var totalRelationships = items.ToList().Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList(); var totalCount = totalRelationships.Count(); return(Json(new { param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = totalCount, aaData = totalRelationships }, JsonRequestBehavior.AllowGet)); }
public ActionResult LoadPropertyItems(IJqueryDatatableParam param) { return(LoadDatatable(param)); }
public ActionResult LoadNOKDetails(IJqueryDatatableParam param) { return(GetDataTable(param)); }
private ActionResult LoadDatatable(IJqueryDatatableParam param, long?Id = null) { List <Tuple <int, string> > sort = new List <Tuple <int, string> >(); if (!string.IsNullOrEmpty(param.sSortDir_0)) { sort.Add(new Tuple <int, string>(param.iSortCol_0, param.sSortDir_0)); } if (!string.IsNullOrEmpty(param.sSortDir_1)) { sort.Add(new Tuple <int, string>(param.iSortCol_1, param.sSortDir_1)); } if (!string.IsNullOrEmpty(param.sSortDir_2)) { sort.Add(new Tuple <int, string>(param.iSortCol_2, param.sSortDir_2)); } var items = Id.HasValue ? _propertyItemsRepository.GetPropertyItemsForPatient(Id.Value) : _propertyItemsRepository.GetPropertyItems(); if (sort.Any()) { var sortItem = sort.First(); var sortColumn = sortItem.Item1; var sortDirection = sortItem.Item2; switch (sortColumn) { case 0: items = sortDirection == "asc" ? items.OrderBy(c => c.PropertyId) : items.OrderByDescending(c => c.PropertyId); break; case 1: items = sortDirection == "asc" ? items.OrderBy(c => c.ItemName) : items.OrderByDescending(c => c.ItemName); break; case 2: items = sortDirection == "asc" ? items.OrderBy(c => c.Description) : items.OrderByDescending(c => c.Description); break; case 3: items = sortDirection == "asc" ? items.OrderBy(c => c.PatientId) : items.OrderByDescending(c => c.PatientId); break; case 4: items = sortDirection == "asc" ? items.OrderBy(c => c.Patient.FirstName).ThenBy(c => c.Patient.SurName) : items.OrderByDescending(c => c.Patient.FirstName).ThenBy(c => c.Patient.SurName); break; case 5: items = sortDirection == "asc" ? items.OrderBy(c => c.Qty) : items.OrderByDescending(c => c.Qty); break; } } var totalDetails = items.ToList().Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList(); var totalCount = totalDetails.Count(); return(Json(new { param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = totalCount, aaData = totalDetails }, JsonRequestBehavior.AllowGet)); }
private ActionResult GetDataTable(IJqueryDatatableParam param, long?PatientId = null) { List <Tuple <int, string> > sort = new List <Tuple <int, string> >(); if (!string.IsNullOrEmpty(param.sSortDir_0)) { sort.Add(new Tuple <int, string>(param.iSortCol_0, param.sSortDir_0)); } if (!string.IsNullOrEmpty(param.sSortDir_1)) { sort.Add(new Tuple <int, string>(param.iSortCol_1, param.sSortDir_1)); } if (!string.IsNullOrEmpty(param.sSortDir_2)) { sort.Add(new Tuple <int, string>(param.iSortCol_2, param.sSortDir_2)); } var details = PatientId.HasValue ? _NOKDetailsRepository.GetNOKDetailsForPatient(PatientId.Value) : _NOKDetailsRepository.GetNOKDetails(); if (sort.Any()) { var sortItem = sort.First(); var sortColumn = sortItem.Item1; var sortDirection = sortItem.Item2; switch (sortColumn) { case 0: details = sortDirection == "asc" ? details.OrderBy(c => c.NOKId) : details.OrderByDescending(c => c.NOKId); break; case 1: details = sortDirection == "asc" ? details.OrderBy(c => c.NOKName) : details.OrderByDescending(c => c.NOKName); break; case 2: details = sortDirection == "asc" ? details.OrderBy(c => c.PatientId) : details.OrderByDescending(c => c.PatientId); break; case 3: details = sortDirection == "asc" ? details.OrderBy(c => c.Patient.FirstName).ThenBy(c => c.Patient.SurName) : details.OrderByDescending(c => c.Patient.FirstName).ThenBy(c => c.Patient.SurName); break; case 4: details = sortDirection == "asc" ? details.OrderBy(c => c.Relationship.Description) : details.OrderByDescending(c => c.Relationship.Description); break; case 5: details = sortDirection == "asc" ? details.OrderBy(c => c.PhoneNumber) : details.OrderByDescending(c => c.PhoneNumber); break; case 6: details = sortDirection == "asc" ? details.OrderBy(c => c.EmailAddress) : details.OrderByDescending(c => c.EmailAddress); break; } } var totalDetails = details.ToList().Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList(); var totalCount = totalDetails.Count(); return(Json(new { param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = totalCount, aaData = totalDetails }, JsonRequestBehavior.AllowGet)); }