public JsonResult IndexData(CC.Web.Models.jQueryDataTableParamModel p) { var usersModel = new UsersModel(); var source = usersModel.GetUsers(db, this.Permissions); var sSortCol_0 = Request["mDataProp_" + p.iSortCol_0]; var bSortAsc_0 = p.sSortDir_0 == "asc"; var filtered = source; if (!string.IsNullOrEmpty(p.sSearch)) { filtered = filtered.Where(f => System.Data.Objects.SqlClient.SqlFunctions.StringConvert((decimal)f.Id).Trim().Equals(p.sSearch) || f.Username.Contains(p.sSearch) || f.Role.Contains(p.sSearch) || f.RoleEnd.Contains(p.sSearch) ); } var data = filtered.OrderByField(sSortCol_0, bSortAsc_0).Skip(p.iDisplayStart).Take(p.iDisplayLength); var result = new CC.Web.Models.jQueryDataTableResult() { aaData = data, sEcho = p.sEcho, iTotalRecords = source.Count(), iTotalDisplayRecords = filtered.Count() }; return(this.MyJsonResult(result)); }
public JsonResult IndexData(CC.Web.Models.jQueryDataTableParamModel p) { var source = from ag in db.Languages select new { Id = ag.Id, Name = ag.Name, }; var sSortCol_0 = Request["mDataProp_" + p.iSortCol_0]; var bSortAsc_0 = p.sSortDir_0 == "asc"; var filtered = source; if (!string.IsNullOrEmpty(p.sSearch)) { filtered = filtered.Where(f => f.Name.Contains(p.sSearch) || f.Id.Contains(p.sSearch) ); } var data = filtered.OrderByField(sSortCol_0, bSortAsc_0).Skip(p.iDisplayStart).Take(p.iDisplayLength); var result = new CC.Web.Models.jQueryDataTableResult() { aaData = data, sEcho = p.sEcho, iTotalRecords = source.Count(), iTotalDisplayRecords = filtered.Count() }; return(this.MyJsonResult(result)); }
public JsonResult IndexData(CC.Web.Models.jQueryDataTableParamModel p) { var source = from ag in db.Agencies.Where(this.Permissions.AgencyFilter) select new { Id = ag.Id, Name = ag.Name, Ser = ag.AgencyGroup.Name }; var sSortCol_0 = Request["mDataProp_" + p.iSortCol_0]; var bSortAsc_0 = p.sSortDir_0 == "asc"; var filtered = source; if (!string.IsNullOrEmpty(p.sSearch)) { filtered = filtered.Where(f => System.Data.Objects.SqlClient.SqlFunctions.StringConvert((decimal)f.Id).Trim().Equals(p.sSearch) || f.Name.Contains(p.sSearch) || f.Ser.Contains(p.sSearch) ); } var data = filtered.OrderByField(sSortCol_0, bSortAsc_0).Skip(p.iDisplayStart).Take(p.iDisplayLength); var result = new CC.Web.Models.jQueryDataTableResult() { aaData = data, sEcho = p.sEcho, iTotalRecords = source.Count(), iTotalDisplayRecords = filtered.Count() }; return(this.MyJsonResult(result)); }
public ActionResult SubsidyLevelsData(CC.Web.Models.jQueryDataTableParamModel p) { var source = from sc in db.ScSubsidyAmounts select new { LevelId = sc.LevelId, FullSubsidy = sc.FullSubsidy, StartDate = sc.StartDate, Amount = sc.Amount }; var sSortCol_0 = Request["mDataProp_" + p.iSortCol_0]; var bSortAsc_0 = p.sSortDir_0 == "asc"; var filtered = source; if (!string.IsNullOrEmpty(p.sSearch)) { filtered = filtered.Where(f => System.Data.Objects.SqlClient.SqlFunctions.StringConvert((decimal)f.LevelId).Trim().Equals(p.sSearch) || System.Data.Objects.SqlClient.SqlFunctions.StringConvert((decimal)f.Amount).Trim().Equals(p.sSearch) ); } var data = filtered.OrderByField(sSortCol_0, bSortAsc_0).Skip(p.iDisplayStart).Take(p.iDisplayLength).OrderBy(f => f.LevelId).ThenBy(f => f.StartDate); var result = new CC.Web.Models.jQueryDataTableResult() { aaData = data, sEcho = p.sEcho, iTotalRecords = source.Count(), iTotalDisplayRecords = filtered.Count() }; return(this.MyJsonResult(result)); }
public JsonResult IndexData(CC.Web.Models.jQueryDataTableParamModel p) { var q = db.Resources.AsQueryable(); var filtered = q; if (!string.IsNullOrEmpty(p.sSearch)) { filtered = filtered.Where(f => f.Culture.Contains(p.sSearch) || f.Key.Contains(p.sSearch) || f.Value.Contains(p.sSearch)); } var ordered = filtered.OrderByField(p.sSortCol_0, p.bSortDir_0); if (!string.IsNullOrEmpty(p.sSortCol_1)) { ordered = ordered.ThenByField(p.sSortCol_1, p.bSortDir_1); } var result = new CC.Web.Models.jQueryDataTableResult <Resource> { aaData = ordered.Skip(p.iDisplayStart).Take(p.iDisplayLength).ToList(), iTotalDisplayRecords = filtered.Count(), iTotalRecords = q.Count(), sEcho = p.sEcho }; return(this.MyJsonResult(result)); }
public JsonResult PreviewData(Guid id, int?subReportId, CC.Web.Models.jQueryDataTableParamModel jq) { Service service = getservicebyimportid(id); var reportingMethodId = service.ReportingMethodId; var importHelper = CC.Web.Models.Import.ClientReports.ClientReportImportFactory.GetByReportingTypeId(reportingMethodId, this.Permissions); CC.Web.Models.jQueryDataTableResult <object> result = null; while (result == null) { try { result = importHelper.GetPreviewData(id, jq); } catch (System.Data.SqlClient.SqlException ex) { //rerun the query on deadlock exception if (!(ex.Message.StartsWith("Transaction") && ex.Message.Contains("was deadlocked"))) { //rethrow if it's anything else throw; } } } result.sEcho = jq.sEcho; return(this.MyJsonResult(result, JsonRequestBehavior.AllowGet)); }
public JsonResult IndexDataTable(CC.Web.Models.AgencyReportingIndexModel model) { var all = model.GetAgencyReportingData(db, Permissions); if (User.IsInRole("RegionReadOnly")) { model.SelectedRegionId = db.Users.Where(f => f.UserName == User.Identity.Name).Select(f => f.RegionId).SingleOrDefault(); } var filtered = model.ApplyFilter(all); if (!string.IsNullOrEmpty(model.sSearch)) { filtered = filtered.Where(f => f.AgencyGroupName.Contains(model.sSearch) || f.AgencyName.Contains(model.sSearch) || f.ServiceTypeName.Contains(model.sSearch) || f.ServiceName.Contains(model.sSearch)); } var sorted = model.ApplySort(filtered); var data = new CC.Web.Models.jQueryDataTableResult() { sEcho = model.sEcho, iTotalDisplayRecords = filtered.Count(), iTotalRecords = all.Count(), aaData = sorted.Skip(model.iDisplayStart).Take(model.iDisplayLength) }; return(MyJsonResult(data)); }
public JsonResult IndexData(CC.Web.Models.jQueryDataTableParamModel p) { var source = from ag in db.AgencyGroups.Where(this.Permissions.AgencyGroupsFilter) select new { Id = ag.Id, Name = ag.Name, Addr1 = ag.Addr1, Addr2 = ag.Addr2, City = ag.City, State = ag.State.Code, Country = ag.Country.Code, Region = ag.Country.Region.Name, CanSubmitRevisionReports = ag.CanSubmitRevisionReports, ForceIsraelID = ag.ForceIsraelID, ReportingPeriodId = ag.ReportingPeriodId, RequiredMatch = ag.RequiredMatch, ExcludeFromReports = ag.ExcludeFromReports, ag.Culture, DefaultCurrency = ag.DefaultCurrency, CfsDate = ag.CfsDate }; var sSortCol_0 = Request["mDataProp_" + p.iSortCol_0]; var bSortAsc_0 = p.sSortDir_0 == "asc"; var filtered = source; if (!string.IsNullOrEmpty(p.sSearch)) { filtered = filtered.Where(f => System.Data.Objects.SqlClient.SqlFunctions.StringConvert((decimal)f.Id).Trim().Equals(p.sSearch) || f.Name.Contains(p.sSearch) || f.Addr1.Contains(p.sSearch) || f.Addr2.Contains(p.sSearch) || f.City.Contains(p.sSearch) || f.Region.Contains(p.sSearch) || f.Country.Equals(p.sSearch) || f.State.Equals(p.sSearch) || f.DefaultCurrency.Contains(p.sSearch) ); } var data = filtered.OrderByField(sSortCol_0, bSortAsc_0).Skip(p.iDisplayStart).Take(p.iDisplayLength); var result = new CC.Web.Models.jQueryDataTableResult() { aaData = data, sEcho = p.sEcho, iTotalRecords = source.Count(), iTotalDisplayRecords = filtered.Count() }; return(this.MyJsonResult(result)); }
public JsonResult IndexData(CC.Web.Models.jQueryDataTableParamModel p) { var poFiles = (from m in db.MainReports where m.ProgramOverviewFileName != null select new MissingFilesRow { MainReportId = m.Id, FileName = m.ProgramOverviewFileName, FileType = "Program Overview" }); var mhsaFiles = (from m in db.MainReports where m.MhsaFileName != null select new MissingFilesRow { MainReportId = m.Id, FileName = m.MhsaFileName, FileType = "Mhsa" }); var dbq = poFiles.Union(mhsaFiles); var q = (from item in dbq.ToList() where !IsFileExists(item.MainReportId, item.FileType) select new MissingFilesRow { MainReportId = item.MainReportId, FileName = item.FileName, FileType = item.FileType }).AsQueryable(); var filtered = q; if (!string.IsNullOrEmpty(p.sSearch)) { filtered = filtered.Where(f => f.FileName.Contains(p.sSearch) || f.FileType.Contains(p.sSearch)); } var ordered = filtered.OrderByField(p.sSortCol_0, p.bSortDir_0); if (!string.IsNullOrEmpty(p.sSortCol_1)) { ordered = ordered.ThenByField(p.sSortCol_1, p.bSortDir_1); } var result = new CC.Web.Models.jQueryDataTableResult <MissingFilesRow> { aaData = ordered.Skip(p.iDisplayStart).Take(p.iDisplayLength).ToList(), iTotalDisplayRecords = filtered.Count(), iTotalRecords = q.Count(), sEcho = p.sEcho }; return(this.MyJsonResult(result)); }
public JsonResult DafDateRangeDataTable(CC.Web.Models.AgencyReportingDafDateRangeModel model) { var all = model.GetAgencyReportingData(db, Permissions); var filtered = model.ApplyFilter(all); var sorted = model.ApplySort(filtered); var data = new CC.Web.Models.jQueryDataTableResult() { sEcho = model.sEcho, iTotalDisplayRecords = filtered.Count(), iTotalRecords = all.Count(), aaData = sorted.Skip(model.iDisplayStart).Take(model.iDisplayLength) }; return(MyJsonResult(data)); }
public JsonResult ReportedHcClientsDataTable(CC.Web.Models.AgencyReportingHomecareModel model) { var all = model.GetAgencyReportingData(db, Permissions); if (User.IsInRole("RegionReadOnly")) { model.SelectedRegionId = db.Users.Where(f => f.UserName == User.Identity.Name).Select(f => f.RegionId).SingleOrDefault(); } var data = new CC.Web.Models.jQueryDataTableResult() { sEcho = model.sEcho, iTotalDisplayRecords = all.Count() > model.iDisplayLength ? model.iDisplayStart + model.iDisplayLength + 1 : model.iDisplayStart + 1, aaData = all.Take(model.iDisplayLength) }; return(MyJsonResult(data)); }
public JsonResult SocializationClientCountDataTable(CC.Web.Models.AgencyReportingSocializationClientsCount model) { var all = model.GetAgencyReportingData(db, Permissions); var filtered = model.ApplyFilter(all); if (!string.IsNullOrEmpty(model.sSearch)) { filtered = filtered.Where(f => f.AgencyGroupName.Contains(model.sSearch) || f.AgencyName.Contains(model.sSearch) || f.Remarks.Contains(model.sSearch)); } var sorted = model.ApplySort(filtered); var data = new CC.Web.Models.jQueryDataTableResult() { sEcho = model.sEcho, iTotalDisplayRecords = filtered.Count(), iTotalRecords = all.Count(), aaData = sorted.Skip(model.iDisplayStart).Take(model.iDisplayLength) }; return(MyJsonResult(data)); }
public JsonResult HomecareDetailsDataTable(CC.Web.Models.AgencyReportingHomecareDetailsModel model) { if (model.CurId == null) { var empty = new CC.Web.Models.jQueryDataTableResult() { sEcho = model.sEcho, iTotalDisplayRecords = 0, aaData = new List <CC.Web.Models.AgencyReportingHomecareDetailsRow>() }; return(MyJsonResult(empty)); } var all = model.GetAgencyReportingData(db, Permissions); var data = new CC.Web.Models.jQueryDataTableResult() { sEcho = model.sEcho, iTotalDisplayRecords = all.Count() > model.iDisplayLength ? model.iDisplayStart + model.iDisplayLength + 1 : model.iDisplayStart + 1, aaData = all.Take(model.iDisplayLength) }; return(MyJsonResult(data)); }