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