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 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 object GetPreview(ccEntities db, CC.Web.Models.jQueryDataTableParamModel jq) { var q = PreviewData(db); var filtered = q; if (!string.IsNullOrEmpty(jq.sSearch)) { filtered = filtered.Where(f => f.FundName.Contains(jq.sSearch) || f.AgencyGroupName.Contains(jq.sSearch) || f.Name.Contains(jq.sSearch) || f.CurrencyId.Equals(jq.sSearch)); } var ordered = filtered.OrderByField(jq.sSortCol_0, jq.bSortDir_0); return(new CC.Web.Models.jQueryDataTableResult <object> { aaData = ordered.Skip(jq.iDisplayStart).Take(jq.iDisplayLength).ToList(), iTotalDisplayRecords = filtered.Count(), iTotalRecords = q.Count(), sEcho = jq.sEcho }); }
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 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 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 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 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)); }