public static jqGridLoadOptions GetLoadOptions(NameValueCollection queryString)
{
var lParams = queryString;
if (lParams == null)
{
return new jqGridLoadOptions();
}
var loadOptions = new jqGridLoadOptions
{
search =
string.IsNullOrEmpty(lParams["_search"])
? false
: bool.Parse(lParams["_search"]),
sortIndex = string.IsNullOrEmpty(lParams["sidx"]) ? null : lParams["sidx"],
sortOrder = string.IsNullOrEmpty(lParams["sord"]) ? null : lParams["sord"],
page = string.IsNullOrEmpty(lParams["page"]) ? 0 : int.Parse(lParams["page"]),
rows = string.IsNullOrEmpty(lParams["rows"]) ? 0 : int.Parse(lParams["rows"]),
searchParams = new Dictionary<string, string>()
};
if (loadOptions.search == true)
{
foreach (var param in lParams.AllKeys)
{
if (param != "_search" && param != "nd" && param != "page" && param != "rows" && param != "sidx" && param != "sord")
{
loadOptions.searchParams.Add(param, lParams[param]);
}
}
}
return loadOptions;
}
public List<SerializableProcurement> GetSerializableProcurements(jqGridLoadOptions loadOptions)
{
if (loadOptions == null)
throw new ArgumentNullException("loadOptions", "loadOptions is null.");
var sortIndex = loadOptions.sortIndex;
var sortOrder = loadOptions.sortOrder;
if (string.IsNullOrEmpty(sortIndex))
{
sortIndex = "CreatedOn";
sortOrder = "desc";
}
else
{
if (string.IsNullOrEmpty(sortOrder))
sortOrder = "asc";
}
IEnumerable<Procurement> procurements;
if (loadOptions.search == false)
{
procurements = dc.Procurements.OrderBy(sortIndex + " " + sortOrder);
}
else
{
AddLikePercentsToValues(loadOptions.searchParams);
var sql = BuildSerializableProcurementSqlStatement(sortIndex, sortOrder, loadOptions.searchParams);
procurements = dc.ExecuteQuery<Procurement>(sql, loadOptions.searchParams.Values.ToArray());
}
return procurements.Select(SerializableProcurement.ConvertProcurementToSerializableProcurement)
.ToList();
}
public List<SerializableDonor> GetSerializableParents(jqGridLoadOptions loadOptions)
{
var donorType = GetDonorTypeByName("Parent");
return GetSerializableDonors(loadOptions, donorType.DonorType_ID, "LastName");
}
public List<SerializableDonor> GetSerializableDonors(jqGridLoadOptions loadOptions, int donorTypeId, string defaultSortColumnName)
{
if (loadOptions == null)
throw new ArgumentNullException("loadOptions", "loadOptions is null.");
if (string.IsNullOrEmpty(loadOptions.sortIndex))
loadOptions.sortIndex = defaultSortColumnName;
if (string.IsNullOrEmpty(loadOptions.sortOrder))
loadOptions.sortOrder = "asc";
IEnumerable<Donor> donors;
if (loadOptions.search == false)
{
donors = dc.Donors.Where(x => x.DonorType_ID == donorTypeId).OrderBy(loadOptions.sortIndex + " " + loadOptions.sortOrder);
}
else
{
AddLikePercentsToValues(loadOptions.searchParams);
var sql = BuildSerializableDonorSqlStatement(loadOptions.sortIndex, loadOptions.sortOrder, loadOptions.searchParams, donorTypeId);
donors = dc.ExecuteQuery<Donor>(sql, loadOptions.searchParams.Values.ToArray());
}
return donors.Where(DonorIsNotClosed).Select(SerializableDonor.ConvertDonorToSerializableProcurement).ToList();
}
public List<SerializableDonor> GetSerializableBusinesses(jqGridLoadOptions loadOptions)
{
var donorType = GetDonorTypeByName("Business");
return GetSerializableDonors(loadOptions, donorType.DonorType_ID, "BusinessName");
}
