public DTResult <LoanManViewModel> GetGrid(DTParameters param)
{
var tableDataSource = this.GetAll().Select(m => new LoanManViewModel {
Id = m.Id, DateAdded = m.DateAdded, FullName = m.FullName
}).AsQueryable();
List <String> columnSearch = new List <string>();
foreach (var col in param.Columns)
{
columnSearch.Add(col.Search.Value);
}
var filterdData = FilterResult(param.Search.Value, tableDataSource, columnSearch, param.SearchFromLength);
List <LoanManViewModel> data = filterdData.OrderBy(param.SortOrder).Skip(param.Start).Take(param.Length).ToList();
int count = filterdData.Count();
DTResult <LoanManViewModel> result = new DTResult <LoanManViewModel>
{
draw = param.Draw,
data = data,
recordsFiltered = count,
recordsTotal = count
};
return(result);
}
public DTResult <AppSettingViewModel> GetGrid(DTParameters param)
{
var tableDataSource = this.GetAll().Select(m => new AppSettingViewModel {
Id = m.Id, AppName = m.AppName, AppShortName = m.AppShortName, AppVersion = m.AppVersion, IsToggleSidebar = m.IsToggleSidebar, IsBoxedLayout = m.IsBoxedLayout, IsFixedLayout = m.IsFixedLayout, IsToggleRightSidebar = m.IsToggleRightSidebar, Skin = m.Skin, FooterText = m.FooterText, Logo = m.Logo, LoginPageBackground = m.LoginPageBackground, TimeZone = m.TimeZone
}).AsQueryable();
List <String> columnSearch = new List <string>();
foreach (var col in param.Columns)
{
columnSearch.Add(col.Search.Value);
}
var filterdData = FilterResult(param.Search.Value, tableDataSource, columnSearch, param.SearchFromLength);
List <AppSettingViewModel> data = filterdData.OrderBy(param.SortOrder).Skip(param.Start).Take(param.Length).ToList();
int count = filterdData.Count();
DTResult <AppSettingViewModel> result = new DTResult <AppSettingViewModel>
{
draw = param.Draw,
data = data,
recordsFiltered = count,
recordsTotal = count
};
return(result);
}
public DTResult <NotificationViewModel> GetGrid(DTParameters param)
{
var tableDataSource = this.GetAll().Select(m => new NotificationViewModel {
Id = m.Id, TableName = m.TableName, TableId = m.TableId, Details = m.Details, ProcessToUrl = m.ProcessToUrl, IsRead = m.IsRead, AddedBy = m.AddedBy, DateAdded = m.DateAdded, ModifiedBy = m.ModifiedBy, DateModified = m.DateModified, ToUserId = m.ToUserId, ToRoleId = m.ToRoleId, UniqueId = m.UniqueId
}).AsQueryable();
List <String> columnSearch = new List <string>();
foreach (var col in param.Columns)
{
columnSearch.Add(col.Search.Value);
}
var filterdData = FilterResult(param.Search.Value, tableDataSource, columnSearch, param.SearchFromLength);
List <NotificationViewModel> data = filterdData.OrderBy(param.SortOrder).Skip(param.Start).Take(param.Length).ToList();
int count = filterdData.Count();
DTResult <NotificationViewModel> result = new DTResult <NotificationViewModel>
{
draw = param.Draw,
data = data,
recordsFiltered = count,
recordsTotal = count
};
return(result);
}
public DTResult <MenuPermissionViewModel> GetGrid(DTParameters param, int user, int role)
{
var conditionData = this.GetAll().AsQueryable();
if (role == Constants.AdminRole)
{
conditionData = this.GetAll().AsQueryable();
}
else
{
conditionData = this.GetAll().Where(i => i.UserId == user).AsQueryable();
}
var tableDataSource = conditionData.Select(m => new MenuPermissionViewModel {
Id = m.Id, MenuId = m.Menu_MenuId.MenuText, RoleId = m.Role_RoleId.RoleName, UserId = m.User_UserId.UserName, SortOrder = m.SortOrder, IsCreate = m.IsCreate, IsRead = m.IsRead, IsUpdate = m.IsUpdate, IsDelete = m.IsDelete, IsActive = m.IsActive
}).AsQueryable();
List <String> columnSearch = new List <string>();
foreach (var col in param.Columns)
{
columnSearch.Add(col.Search.Value);
}
var filterdData = FilterResult(param.Search.Value, tableDataSource, columnSearch, param.SearchFromLength);
List <MenuPermissionViewModel> data = filterdData.OrderBy(param.SortOrder).Skip(param.Start).Take(param.Length).ToList();
int count = filterdData.Count();
DTResult <MenuPermissionViewModel> result = new DTResult <MenuPermissionViewModel>
{
draw = param.Draw,
data = data,
recordsFiltered = count,
recordsTotal = count
};
return(result);
}
public DTResult <UserViewModel> GetGrid(DTParameters param, int user, int role)
{
var conditionData = this.GetAll().AsQueryable();
if (role == Constants.AdminRole)
{
conditionData = this.GetAll().AsQueryable();
}
else
{
conditionData = this.GetAll().Where(i => i.Id == user).AsQueryable();
}
var tableDataSource = conditionData.Select(m => new UserViewModel {
Id = m.Id, UserName = m.UserName, Password = m.Password, RoleId = m.RoleId, DateAdded = m.DateAdded, DateModified = m.DateModified, FullName = m.FullName, Email = m.Email, MobileNumber = m.MobileNumber, IsActive = m.IsActive, ChangePasswordCode = m.ChangePasswordCode, IsConfirm = m.IsConfirm, OnTime = m.OnTime, ClockTest = m.ClockTest, About = m.About
}).AsQueryable();
List <String> columnSearch = new List <string>();
foreach (var col in param.Columns)
{
columnSearch.Add(col.Search.Value);
}
var filterdData = FilterResult(param.Search.Value, tableDataSource, columnSearch, param.SearchFromLength);
List <UserViewModel> data = filterdData.OrderBy(param.SortOrder).Skip(param.Start).Take(param.Length).ToList();
int count = filterdData.Count();
DTResult <UserViewModel> result = new DTResult <UserViewModel>
{
draw = param.Draw,
data = data,
recordsFiltered = count,
recordsTotal = count
};
return(result);
}
