public JsonResult UserList(Guid AccountId, string Type, int StartIndex, int Length, string Search, int ColumnSort, string Direction)
{
int count, filteredCount;
var userList = DataAccess.Account.GetAllAccountsLightWeight(StartIndex, Length, Search, ColumnSort, Direction, out count, out filteredCount).Select(x =>
{
return(new
{
Username = x.Username,
FirstName = x.FirstName,
LastName = x.LastName,
EmailAddress = x.EmailAddress,
Status = x.Status,
Permissions = string.Join("<br/>", x.Permissions.Distinct().Select(kvp => string.Concat(kvp.PermissionDescription))),
ID = x.ID,
Age = x.Age,
IsForCurrentClient = x.Permissions.FirstOrDefault(p => p.GetClientId() == UserHelper.SelectedClientId) != null
});
}).Where(x => Type == "SuperAdmin" || x.IsForCurrentClient).ToList();
Utilities.DataTableRequest dataTableRequest = Utilities.DataTableRequest.Parse(Request.Form);
dataTableRequest.OverrideSearch = true;
dataTableRequest.OverrideCount = count;
dataTableRequest.OverrideFilteredCount = filteredCount;
return(Json(
Utilities.DataTableJson(
dataTableRequest,
userList,
null,
x => x.Username, x => x.FirstName, x => x.LastName, x => x.EmailAddress, x => x.Status, x => x.Permissions, x => x.ID, x => x.Age), JsonRequestBehavior.AllowGet));
}
public JsonResult ListItemList()
{
Utilities.DataTableRequest dataTableRequest = Utilities.DataTableRequest.Parse(Request.Form);
string orderColumn = new string[] { "ListName", "Name", "Description", "Code", "Value", "SortOrder" }[dataTableRequest.orderColumn];
int count, filteredCount;
List <Data.Models.ListItem> list = DataAccess.ListItem.GetMaintenanceList(dataTableRequest.search, dataTableRequest.start, dataTableRequest.length, orderColumn, dataTableRequest.orderAscending, out count, out filteredCount);
dataTableRequest.OverrideSearch = true;
dataTableRequest.OverrideCount = count;
dataTableRequest.OverrideFilteredCount = filteredCount;
return(Json(
Utilities.DataTableJson(
dataTableRequest,
list.Select(li => new
{
ListName = li.FullListName,
Name = li.Name,
Description = li.Description,
Code = li.Code,
Value = li.Value,
SortOrder = li.SortOrder,
ID = li.ID,
Age = li.Age
}).ToList(),
null,
x => x.ListName, x => x.Name, x => x.Description, x => x.Code, x => x.Value, x => x.SortOrder, x => x.ID, x => x.Age)));
}
public JsonResult DeceasedList()
{
Utilities.DataTableRequest dataTableRequest = Utilities.DataTableRequest.Parse(Request.Form);
int count;
Data.Models.Account act = UserHelper.GetCurrentAccount();
string query = dataTableRequest.search;
var result = _patientService.ListDeceasedPatients(act.Username, out count, (dataTableRequest.start / dataTableRequest.length) + 1, dataTableRequest.length, query, "Firstname", true);
dataTableRequest.OverrideSearch = true;
dataTableRequest.OverrideCount = count;
dataTableRequest.OverrideFilteredCount = count;
return(Json(
Utilities.DataTableJson(
dataTableRequest,
result.Select(x => new
{
FirstName = x.Firstname,
LastName = x.Lastname,
BirthDate = x.DateOfBirth.HasValue ? string.Format("{0} ({1})", x.DateOfBirth.Value.ToString("dd MMM yyyy"), Convert.ToInt32(DateTime.Now.Subtract(x.DateOfBirth.Value).TotalDays / 365)) : string.Empty,
Gender = x.Gender == null ? string.Empty : x.Gender.Name,
Race = x.Race == null ? string.Empty : x.Race.Name,
MedicalScheme = x.MedicalScheme == null ? string.Empty : x.MedicalScheme.Name,
IDNumber = x.Details == null ? string.Empty : x.Details.IdentificationNumber,
GenderID = x.Gender == null ? string.Empty : x.Gender.Id.ToString(),
RaceID = x.Race == null ? string.Empty : x.Race.Id.ToString(),
Age = string.Empty,
ID = x.Id,
PatientId = x.Id.ToString("N"),
Providers = string.Join(", ", x.TeamMembers.GroupBy(y => y.Facility.Id).Select(y => y.First().Facility.Name))
}).ToList(),
null,
x => x.FirstName, x => x.LastName, x => x.BirthDate, x => x.Gender, x => x.Race, x => x.Providers, x => x.MedicalScheme, x => x.ID, x => x.Age, x => x.GenderID, x => x.RaceID, x => x.PatientId)));
}