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