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