public static IQueryable <TDbModel> ApplyDatabaseDataPagination <TDbModel>( this IQueryable <TDbModel> query, GridPagination pagination) where TDbModel : class => pagination?.PageSize > 0 ? query.Skip(pagination.Page * pagination.PageSize) .Take(pagination.PageSize) : query;
internal static async Task <List <Employee> > GetEmployeeGridDataAsync(GridPagination pagination, Ref <int> totalRecords) { List <Employee> data; using (SqlConnection conn = new SqlConnection( EnvironmentManager.GetConnectionString(EnvironmentManager.Database.DatabaseConnection))) { conn.Open(); await using (SqlCommand command = new SqlCommand("dbo.uspGetEmployeeGridData", conn)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@SortColumn", pagination.SortColumn); command.Parameters.AddWithValue("@SortOrder", pagination.SortOrder); command.Parameters.AddWithValue("@PageSize", pagination.PageSize); command.Parameters.AddWithValue("@CurrentPage", pagination.CurrentPage); command.Parameters.AddWithValue("@WhereCondition", pagination.WhereCondition); command.Parameters.Add("@TotalRecords", SqlDbType.Int); command.Parameters["@TotalRecords"].Direction = ParameterDirection.Output; data = EntityMapper.CreateEmployeeGridData(await command.ExecuteReaderAsync()); totalRecords.Value = Convert.ToInt32(command.Parameters["@TotalRecords"].Value); } } return(data); }
public CandidateReport() { InitializeComponent(); pagination = new GridPagination<CandidateDetail>(); //pagination.ReportFor = "Candidate"; uniDb = new UniDBDataContext(); }
public CandidateReport() { InitializeComponent(); columnPropertyInfos = typeof(CandidateDetail).GetProperties(); pagination = new GridPagination<CandidateDetail>(); //pagination.ReportFor = "Candidate"; uniDb = new UniDBDataContext(); }
public CompanyDetailsfrm(UniEnums.CompanyType companyType) { InitializeComponent(); _reportForm = new ReportForm<VendorDetail>(bindingNavigator1, dataGridView1, bindingNavigatorPositionItem.TextBox, lblReportStatus); _pagination = new GridPagination<CustomerDetail>(); _uniDb = new UniDBDataContext(); _companyType = companyType; }
public JsonResult StoreGroupAjaxDataProvider(GridPagination param) { var userId = _userManager.GetUserId(User); var uId = _context.Users.Where(x => x.Id == userId); //IEnumerable<StoreGroupMaster> StoreGroups = _context.StoreGroups.Where(x => x.IsDeleted == false).OrderByDescending(x => x.Id); //var totalStoreGroups = _context.StoreGroups.Count(); var viewModel = from stgp in _context.StoreGroups join imp in _context.Importers on stgp.ImporterName equals imp.Id.ToString() join dlr in _context.Dealers on stgp.DealerName equals dlr.Id.ToString() //join astC in _context.AssetCategory on ast.AssetCategory equals astC.Id where stgp.ImporterName == imp.Id.ToString() //where ast.AssetCategory == astC.Id //where ast.ControllerType == ctr.Id where stgp.IsDeleted == false where stgp.CreatedBy == userId select new { stgp.Id, impName = imp.ImporterName, dlrName = dlr.DealerName, stgp.Region, stgp.Area, stgp.City, stgp.HOAddress1, stgp.HOAddress2, stgp.HOAddress3, stgp.Postcode, stgp.StoreGroupName, stgp.StoreGroupPhone, stgp.StoreGroupRegion, stgp.Email, }; if (User.IsInRole("Administrator")) { viewModel = from stgp in _context.StoreGroups join imp in _context.Importers on stgp.ImporterName equals imp.Id.ToString() join dlr in _context.Dealers on stgp.DealerName equals dlr.Id.ToString() //join astC in _context.AssetCategory on ast.AssetCategory equals astC.Id where stgp.ImporterName == imp.Id.ToString() //where ast.AssetCategory == astC.Id //where ast.ControllerType == ctr.Id where stgp.IsDeleted == false // where stgp.CreatedBy == userId select new { stgp.Id, impName = imp.ImporterName, dlrName = dlr.DealerName, stgp.Region, stgp.Area, stgp.City, stgp.HOAddress1, stgp.HOAddress2, stgp.HOAddress3, stgp.Postcode, stgp.StoreGroupName, stgp.StoreGroupPhone, stgp.StoreGroupRegion, stgp.Email, }; } var totalStoreGroups = viewModel.ToList().Count(); var json = Newtonsoft.Json.JsonConvert.SerializeObject(param); var sortDirection = HttpContext.Request.Query["sSortDir_0"]; // asc or desc var sortColumnIndex = Convert.ToInt32(HttpContext.Request.Query["iSortCol_0"]); if (!string.IsNullOrEmpty(param.sSearch)) { viewModel = viewModel.Where(z => z.dlrName.ToLower().Contains(param.sSearch.ToLower()) || z.impName.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.StoreGroupName.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.StoreGroupPhone.ToLower().Contains(param.sSearch.ToLower()) || z.StoreGroupRegion.ToLower().Contains(param.sSearch.ToLower()) || z.Email.ToLower().Contains(param.sSearch.ToLower()) //|| z.Region.ToString().ToLower().Contains(param.sSearch.ToLower()) //|| z.Area.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.HOAddress1.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.HOAddress2.ToString().ToLower().Contains(param.sSearch.ToLower()) //|| z.HOAddress3.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.City.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.Postcode.ToString().ToLower().Contains(param.sSearch.ToLower())); } switch (sortColumnIndex) { case 1: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.impName) : viewModel.OrderByDescending(z => z.impName); break; case 2: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.dlrName) : viewModel.OrderByDescending(z => z.dlrName); break; case 3: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.StoreGroupName) : viewModel.OrderByDescending(z => z.StoreGroupName); break; case 4: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.StoreGroupPhone) : viewModel.OrderByDescending(z => z.StoreGroupName); break; case 5: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.StoreGroupRegion) : viewModel.OrderByDescending(z => z.StoreGroupRegion); break; case 6: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Email) : viewModel.OrderByDescending(z => z.Email); break; case 7: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Region) : viewModel.OrderByDescending(z => z.Region); break; case 8: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Area) : viewModel.OrderByDescending(z => z.Area); break; case 9: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.HOAddress1 + " " + z.HOAddress2 + " " + z.HOAddress3 + " " + z.City + " " + z.Postcode) : viewModel.OrderByDescending(z => z.HOAddress1 + " " + z.HOAddress2 + " " + z.HOAddress3 + " " + z.City + " " + z.Postcode); break; default: viewModel = viewModel.OrderByDescending(z => z.Id); break; } var filteredStoreGroupsCount = viewModel.Count(); viewModel = viewModel.Skip(param.iDisplayStart).Take(param.iDisplayLength); return(Json(new { sEcho = param.sEcho, // iTotalRecords = totalStoreGroups, iTotalRecords = filteredStoreGroupsCount, iTotalDisplayRecords = filteredStoreGroupsCount, aaData = viewModel })); }
//data provider method for the Dealers list. public JsonResult DealerAjaxDataProvider(GridPagination param) { var userId = _userManager.GetUserId(User); var uId = _context.Users.Where(x => x.Id == userId).Select(x => x.UserName).FirstOrDefault(); var viewModel = from dlr in _context.Dealers join imp in _context.Importers on dlr.ImporterName equals imp.Id.ToString() where dlr.ImporterName == imp.Id.ToString() where dlr.IsDeleted == false where dlr.CreatedBy == userId select new { dlr.Id, impName = imp.ImporterName, dlr.Region, dlr.Area, dlr.DealerName, dlr.DealerPhone, dlr.DealerRegion, dlr.Email, }; // IEnumerable<DealerMaster> Dealers = _context.Dealers; // IEnumerable<DealerMaster> Dealers = _context.Dealers.Where(x => x.IsDeleted == false).OrderByDescending(x => x.Id); if (User.IsInRole("Administrator")) { //IEnumerable<DealerMaster> Dealers = _context.Dealers.Where(x => x.IsDeleted == false).OrderByDescending(x => x.Id); viewModel = from dlr in _context.Dealers join imp in _context.Importers on dlr.ImporterName equals imp.Id.ToString() where dlr.ImporterName == imp.Id.ToString() where dlr.IsDeleted == false // where dlr.CreatedBy == userId select new { dlr.Id, impName = imp.ImporterName, dlr.Region, dlr.Area, dlr.DealerName, dlr.DealerPhone, dlr.DealerRegion, dlr.Email, }; } var totalDealers = viewModel.ToList().Count(); var json = Newtonsoft.Json.JsonConvert.SerializeObject(param); var sortDirection = HttpContext.Request.Query["sSortDir_0"]; // asc or desc var sortColumnIndex = Convert.ToInt32(HttpContext.Request.Query["iSortCol_0"]); if (!string.IsNullOrEmpty(param.sSearch)) { viewModel = viewModel.Where(z => z.DealerName.ToLower().Contains(param.sSearch.ToLower()) || z.DealerPhone.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.DealerRegion.ToLower().Contains(param.sSearch.ToLower()) // || z.CustomerName.ToLower().Contains(param.sSearch.ToLower()) // || z.CustomerNumber.ToLower().Contains(param.sSearch.ToLower()) || z.Email.ToLower().Contains(param.sSearch.ToLower()) || z.Region.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.Area.ToString().ToLower().Contains(param.sSearch.ToLower()) // || z.StoreCode.ToString().ToLower().Contains(param.sSearch.ToLower()) // || z.Type.ToString().ToLower().Contains(param.sSearch.ToLower()) // || z.StoreName.ToString().ToLower().Contains(param.sSearch.ToLower()) // || z.StoreAddress1.ToString().ToLower().Contains(param.sSearch.ToLower()) // || z.StoreAddress2.ToString().ToLower().Contains(param.sSearch.ToLower()) // || z.PostTown.ToString().ToLower().Contains(param.sSearch.ToLower()) // || z.StorePostcode.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.impName.ToString().ToLower().Contains(param.sSearch.ToLower())); // new line added } switch (sortColumnIndex) { case 1: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.impName) : viewModel.OrderByDescending(z => z.impName); break; case 2: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.DealerName) : viewModel.OrderByDescending(z => z.DealerName); break; case 3: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.DealerRegion) : viewModel.OrderByDescending(z => z.DealerRegion); break; case 4: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.DealerPhone) : viewModel.OrderByDescending(z => z.DealerPhone); break; //case 4: // Dealers = sortDirection == "asc" ? Dealers.OrderBy(z => z.CustomerName) : Dealers.OrderByDescending(z => z.CustomerName); // break; //case 5: // Dealers = sortDirection == "asc" ? Dealers.OrderBy(z => z.CustomerNumber) : Dealers.OrderByDescending(z => z.CustomerNumber); // break; case 5: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Email) : viewModel.OrderByDescending(z => z.Email); break; case 6: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Region) : viewModel.OrderByDescending(z => z.Region); break; case 7: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Area) : viewModel.OrderByDescending(z => z.Area); break; //case 9: // Dealers = sortDirection == "asc" ? Dealers.OrderBy(z => z.StoreCode) : Dealers.OrderByDescending(z => z.StoreCode); // break; //case 10: // Dealers = sortDirection == "asc" ? Dealers.OrderBy(z => z.Type) : Dealers.OrderByDescending(z => z.Type); // break; //case 11: // Dealers = sortDirection == "asc" ? Dealers.OrderBy(z => z.StoreName) : Dealers.OrderByDescending(z => z.StoreName); // break; //case 12: // Dealers = sortDirection == "asc" ? Dealers.OrderBy(z => z.StoreAddress1) : Dealers.OrderByDescending(z => z.StoreAddress1); // break; //case 13: // Dealers = sortDirection == "asc" ? Dealers.OrderBy(z => z.StoreAddress2) : Dealers.OrderByDescending(z => z.StoreAddress2); // break; //case 14: // Dealers = sortDirection == "asc" ? Dealers.OrderBy(z => z.PostTown) : Dealers.OrderByDescending(z => z.PostTown); // break; //case 15: // Dealers = sortDirection == "asc" ? Dealers.OrderBy(z => z.StorePostcode) : Dealers.OrderByDescending(z => z.StorePostcode); // break; default: viewModel = viewModel.OrderByDescending(z => z.Id); break; } var filteredDealersCount = viewModel.Count(); viewModel = viewModel.Skip(param.iDisplayStart).Take(param.iDisplayLength); return(Json(new { sEcho = param.sEcho, // iTotalRecords = totalDealers, iTotalRecords = filteredDealersCount, iTotalDisplayRecords = filteredDealersCount, aaData = viewModel })); }
//data provider method for the Users list. public JsonResult CustomerAjaxDataProvider(GridPagination param) { var userId = _userManager.GetUserId(User); var uId = _context.Users.Where(x => x.Id == userId); IEnumerable <CustomerMaster> Customers = _context.Customers.Where(x => x.IsDeleted == false).OrderByDescending(x => x.Id); var totalCustomers = Customers.ToList().Count(); var json = Newtonsoft.Json.JsonConvert.SerializeObject(param); var sortDirection = HttpContext.Request.Query["sSortDir_0"]; // asc or desc var sortColumnIndex = Convert.ToInt32(HttpContext.Request.Query["iSortCol_0"]); if (!string.IsNullOrEmpty(param.sSearch)) { Customers = Customers.Where(z => z.Area.ToLower().Contains(param.sSearch.ToLower()) || z.City.ToLower().Contains(param.sSearch.ToLower()) || z.CustomerName.ToLower().Contains(param.sSearch.ToLower()) || z.HOAddress1.ToLower().Contains(param.sSearch.ToLower()) || z.HOAddress2.ToLower().Contains(param.sSearch.ToLower()) || z.HOAddress3.ToLower().Contains(param.sSearch.ToLower()) || z.Postcode.ToLower().Contains(param.sSearch.ToLower()) || z.PostTown.ToLower().Contains(param.sSearch.ToLower()) || z.PrimaryContactName.ToLower().Contains(param.sSearch.ToLower()) || z.PrimaryContactNumber.ToLower().Contains(param.sSearch.ToLower()) || z.Region.ToLower().Contains(param.sSearch.ToLower()) || z.StoreAddress1.ToLower().Contains(param.sSearch.ToLower()) || z.StoreAddress2.ToLower().Contains(param.sSearch.ToLower()) || z.StoreCode.ToLower().Contains(param.sSearch.ToLower()) || z.StoreName.ToLower().Contains(param.sSearch.ToLower()) || z.StorePostcode.ToLower().Contains(param.sSearch.ToLower()) || z.Type.ToLower().Contains(param.sSearch.ToLower()) || z.Zone.ToLower().Contains(param.sSearch.ToLower()) || z.PrimaryEmail.ToLower().Contains(param.sSearch.ToLower())); } switch (sortColumnIndex) { case 1: Customers = sortDirection == "asc" ? Customers.OrderBy(z => z.CustomerName) : Customers.OrderByDescending(z => z.CustomerName); break; case 2: Customers = sortDirection == "asc" ? Customers.OrderBy(z => z.PrimaryEmail) : Customers.OrderByDescending(z => z.PrimaryEmail); break; case 3: Customers = sortDirection == "asc" ? Customers.OrderBy(z => z.PrimaryContactName) : Customers.OrderByDescending(z => z.PrimaryContactName); break; case 4: Customers = sortDirection == "asc" ? Customers.OrderBy(z => z.PrimaryContactNumber) : Customers.OrderByDescending(z => z.PrimaryContactNumber); break; case 5: Customers = sortDirection == "asc" ? Customers.OrderBy(z => z.HOAddress1 + " " + z.HOAddress2 + " " + z.HOAddress3 + " " + z.City + " " + z.Postcode) : Customers.OrderByDescending(z => z.HOAddress1 + " " + z.HOAddress2 + " " + z.HOAddress3 + " " + z.City + " " + z.Postcode); break; case 6: Customers = sortDirection == "asc" ? Customers.OrderBy(z => z.Zone) : Customers.OrderByDescending(z => z.Zone); break; case 7: Customers = sortDirection == "asc" ? Customers.OrderBy(z => z.Region) : Customers.OrderByDescending(z => z.Region); break; case 8: Customers = sortDirection == "asc" ? Customers.OrderBy(z => z.Area) : Customers.OrderByDescending(z => z.Area); break; case 9: Customers = sortDirection == "asc" ? Customers.OrderBy(z => z.StoreCode) : Customers.OrderByDescending(z => z.StoreCode); break; case 10: Customers = sortDirection == "asc" ? Customers.OrderBy(z => z.Type) : Customers.OrderByDescending(z => z.Type); break; case 11: Customers = sortDirection == "asc" ? Customers.OrderBy(z => z.StoreName) : Customers.OrderByDescending(z => z.StoreName); break; case 12: Customers = sortDirection == "asc" ? Customers.OrderBy(z => z.StoreAddress1 + " " + z.StoreAddress2 + " " + z.StoreCode + " " + z.PostTown + " " + z.StorePostcode) : Customers.OrderByDescending(z => z.StoreAddress1 + " " + z.StoreAddress2 + " " + z.StoreCode + " " + z.PostTown + " " + z.StorePostcode); break; default: Customers = Customers.OrderByDescending(z => z.Id); break; } var filteredCustomersCount = Customers.Count(); Customers = Customers.Skip(param.iDisplayStart).Take(param.iDisplayLength); return(Json(new { sEcho = param.sEcho, iTotalRecords = filteredCustomersCount, iTotalDisplayRecords = filteredCustomersCount, aaData = Customers })); }
public static async Task <List <Employee> > GetEmployeeGridDataAsync(GridPagination pagination, Ref <int> totalRecords) { return(await DataController.GetEmployeeGridDataAsync(pagination, totalRecords)); }
public JsonResult ImporterAjaxDataProvider(GridPagination param) { var userId = _userManager.GetUserId(User); var uId = _context.Users.Where(x => x.Id == userId); IEnumerable <ImporterMaster> Importers = _context.Importers.Where(x => x.IsDeleted == false).OrderByDescending(x => x.Id); var totalImporters = _context.Importers.Count(); var json = Newtonsoft.Json.JsonConvert.SerializeObject(param); var sortDirection = HttpContext.Request.Query["sSortDir_0"]; // asc or desc var sortColumnIndex = Convert.ToInt32(HttpContext.Request.Query["iSortCol_0"]); if (!string.IsNullOrEmpty(param.sSearch)) { Importers = Importers.Where(z => z.ImporterName.ToLower().Contains(param.sSearch.ToLower()) || z.ImporterPhone.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.ImporterRegion.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.Email.ToLower().Contains(param.sSearch.ToLower()) || z.Region.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.Area.ToString().ToLower().Contains(param.sSearch.ToLower())); } switch (sortColumnIndex) { case 1: Importers = sortDirection == "asc" ? Importers.OrderBy(z => z.ImporterName) : Importers.OrderByDescending(z => z.ImporterName); break; case 2: Importers = sortDirection == "asc" ? Importers.OrderBy(z => z.ImporterPhone) : Importers.OrderByDescending(z => z.ImporterPhone); break; case 3: Importers = sortDirection == "asc" ? Importers.OrderBy(z => z.ImporterRegion) : Importers.OrderByDescending(z => z.ImporterRegion); break; case 5: Importers = sortDirection == "asc" ? Importers.OrderBy(z => z.Email) : Importers.OrderByDescending(z => z.Email); break; case 6: Importers = sortDirection == "asc" ? Importers.OrderBy(z => z.Region) : Importers.OrderByDescending(z => z.Region); break; case 7: Importers = sortDirection == "asc" ? Importers.OrderBy(z => z.Area) : Importers.OrderByDescending(z => z.Area); break; default: Importers = Importers.OrderByDescending(z => z.Id); break; } var filteredImportersCount = Importers.Count(); Importers = Importers.Skip(param.iDisplayStart).Take(param.iDisplayLength); return(Json(new { sEcho = param.sEcho, iTotalRecords = totalImporters, // iTotalRecords = totalImporters, iTotalDisplayRecords = filteredImportersCount, aaData = Importers })); }
//data provider method for the asset list. public JsonResult AssetAjaxDataProvider(GridPagination param) { // Thread.Sleep(7000); var userId = _userManager.GetUserId(User); var uId = _context.Users.Where(x => x.Id == userId); //IEnumerable<AssetMaster> viewModel = _context.Assets; // IEnumerable<AssetMaster> viewModel = _context.Assets.Where(x => x.IsDeleted == false).OrderByDescending(x => x.Id); var viewModel = from ast in _context.Assets join ctr in _context.ControllerType on ast.ControllerType equals ctr.Id join astT in _context.AssetType on ast.AssetType equals astT.Id join astC in _context.AssetCategory on ast.AssetCategory equals astC.Id where ast.AssetType == astT.Id where ast.AssetCategory == astC.Id where ast.ControllerType == ctr.Id where ast.IsDeleted == false select new { ast.Id, AssetCategory = astC.AssetCategory, AssetType = astT.AssetType, ControllerType = ctr.ControllerType, ast.FG_Code, ast.Controllers, ast.Trays, ast.TraySize, ast.Handed, ast.Format, ast.Power, ast.Elements, ast.kWh_Rating_Element, ast.LightType, ast.Lights, ast.kWh_Rating_Light, ast.Fans, ast.kWh_Rating_Fan, ast.kWh_Rating_Damper, ast.kWh_Rating_WaterSolenoid, }; // var totalviewModel = _context.viewModel.Count(); var totalviewModel = viewModel.ToList().Count(); var json = Newtonsoft.Json.JsonConvert.SerializeObject(param); var sortDirection = HttpContext.Request.Query["sSortDir_0"]; // asc or desc var sortColumnIndex = Convert.ToInt32(HttpContext.Request.Query["iSortCol_0"]); if (!string.IsNullOrEmpty(param.sSearch)) { viewModel = viewModel.Where(z => z.AssetCategory.ToLower().Contains(param.sSearch.ToLower()) || z.AssetType.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.FG_Code.ToLower().Contains(param.sSearch.ToLower()) || z.Controllers.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.ControllerType.ToLower().Contains(param.sSearch.ToLower()) || z.Trays.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.TraySize.ToLower().Contains(param.sSearch.ToLower()) || z.Handed.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.Power.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.Elements.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.Format.ToLower().Contains(param.sSearch.ToLower())); } switch (sortColumnIndex) { case 1: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.FG_Code) : viewModel.OrderByDescending(x => x.FG_Code); break; case 2: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.AssetCategory) : viewModel.OrderByDescending(z => z.AssetCategory); break; case 3: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.AssetType) : viewModel.OrderByDescending(z => z.AssetType); break; case 4: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.ControllerType) : viewModel.OrderByDescending(z => z.ControllerType); break; case 5: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Controllers) : viewModel.OrderByDescending(z => z.Controllers); break; case 6: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Trays) : viewModel.OrderByDescending(z => z.Trays); break; case 7: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.TraySize) : viewModel.OrderByDescending(z => z.TraySize); break; case 8: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Handed) : viewModel.OrderByDescending(z => z.Handed); break; case 9: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Format): viewModel.OrderByDescending(z => z.Format); break; case 10: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Power) : viewModel.OrderByDescending(z => z.Power); break; case 11: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Elements) : viewModel.OrderByDescending(z => z.Elements); break; case 12: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.kWh_Rating_Element) : viewModel.OrderByDescending(z => z.kWh_Rating_Element); break; case 13: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.LightType) : viewModel.OrderByDescending(z => z.LightType); break; case 14: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Lights) : viewModel.OrderByDescending(z => z.Lights); break; case 15: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.kWh_Rating_Light) : viewModel.OrderByDescending(z => z.kWh_Rating_Light); break; case 16: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Fans) : viewModel.OrderByDescending(z => z.Fans); break; case 17: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.kWh_Rating_Fan) : viewModel.OrderByDescending(z => z.kWh_Rating_Fan); break; case 18: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.kWh_Rating_Damper) : viewModel.OrderByDescending(z => z.kWh_Rating_Damper); break; case 19: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.kWh_Rating_WaterSolenoid) : viewModel.OrderByDescending(z => z.kWh_Rating_WaterSolenoid); break; default: viewModel = viewModel.OrderByDescending(z => z.Id); break; } var filteredviewModelCount = viewModel.Count(); viewModel = viewModel.Skip(param.iDisplayStart).Take(param.iDisplayLength); return(Json(new { sEcho = param.sEcho, iTotalRecords = filteredviewModelCount, iTotalDisplayRecords = filteredviewModelCount, aaData = viewModel })); }
public JsonResult ControllerAjaxData(GridPagination param) { //GridPagination param = new GridPagination(); var userId = _userManager.GetUserId(User); var uId = _context.Users.Where(x => x.Id == userId); // IEnumerable<ControllerModule> Controllers = _context.Controller; IEnumerable <ControllerModule> Controllers = _context.Controller.Where(x => x.IsDeleted == false).OrderByDescending(x => x.Id); var totalControllers = _context.Controller.Count(); var json = Newtonsoft.Json.JsonConvert.SerializeObject(param); var sortDirection = HttpContext.Request.Query["sSortDir_0"]; // asc or desc var sortColumnIndex = Convert.ToInt32(HttpContext.Request.Query["iSortCol_0"]); if (!string.IsNullOrEmpty(param.sSearch)) { Controllers = Controllers.Where(z => z.AuthenticationCode.ToLower().Contains(param.sSearch.ToLower()) || z.ControllerDate.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.FirmwareVersion.ToLower().Contains(param.sSearch.ToLower()) || z.RecipeVersion.ToLower().Contains(param.sSearch.ToLower()) || z.RemoteKill.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.SerialNumber.ToLower().Contains(param.sSearch.ToLower()) || z.SevenDayTimer.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.Skins.ToLower().Contains(param.sSearch.ToLower()) || z.SleepDelay.ToLower().Contains(param.sSearch.ToLower()) || z.SoftwareVersion.ToLower().Contains(param.sSearch.ToLower()) || z.Status.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.Wallpaper.ToLower().Contains(param.sSearch.ToLower())); } switch (sortColumnIndex) { case 1: Controllers = sortDirection == "asc" ? Controllers.OrderBy(z => z.FG_Code) : Controllers.OrderByDescending(z => z.FG_Code); break; case 2: Controllers = sortDirection == "asc" ? Controllers.OrderBy(z => z.SerialNumber) : Controllers.OrderByDescending(z => z.SerialNumber); break; case 3: Controllers = sortDirection == "asc" ? Controllers.OrderBy(z => z.AuthenticationCode) : Controllers.OrderByDescending(z => z.AuthenticationCode); break; case 4: Controllers = sortDirection == "asc" ? Controllers.OrderBy(z => z.FirmwareVersion) : Controllers.OrderByDescending(z => z.FirmwareVersion); break; case 5: Controllers = sortDirection == "asc" ? Controllers.OrderBy(z => z.SoftwareVersion) : Controllers.OrderByDescending(z => z.SoftwareVersion); break; case 6: Controllers = sortDirection == "asc" ? Controllers.OrderBy(z => z.RecipeVersion) : Controllers.OrderByDescending(z => z.RecipeVersion); break; case 7: Controllers = sortDirection == "asc" ? Controllers.OrderBy(z => z.Skins) : Controllers.OrderByDescending(z => z.Skins); break; case 8: Controllers = sortDirection == "asc" ? Controllers.OrderBy(z => z.Wallpaper) : Controllers.OrderByDescending(z => z.Wallpaper); break; case 9: Controllers = sortDirection == "asc" ? Controllers.OrderBy(z => z.SevenDayTimer) : Controllers.OrderByDescending(z => z.SevenDayTimer); break; case 10: Controllers = sortDirection == "asc" ? Controllers.OrderBy(z => z.SleepDelay) : Controllers.OrderByDescending(z => z.SleepDelay); break; case 11: Controllers = sortDirection == "asc" ? Controllers.OrderBy(z => z.ControllerDate) : Controllers.OrderByDescending(z => z.ControllerDate); break; case 12: Controllers = sortDirection == "asc" ? Controllers.OrderBy(z => z.Status) : Controllers.OrderByDescending(z => z.Status); break; case 13: Controllers = sortDirection == "asc" ? Controllers.OrderBy(z => z.RemoteKill) : Controllers.OrderByDescending(z => z.RemoteKill); break; default: Controllers = Controllers.OrderByDescending(z => z.Id); break; } var filteredControllersCount = Controllers.Count(); // Controllers = Controllers.Skip(param.iDisplayStart).Take(param.iDisplayLength); return(Json(new { sEcho = param.sEcho, iTotalRecords = totalControllers, iTotalDisplayRecords = filteredControllersCount, aaData = Controllers })); }
//data provider method for the Users list. public JsonResult UserAjaxDataProvider(GridPagination param) { var userId = _userManager.GetUserId(User); var uId = _context.Users.Where(x => x.Id == userId); // IEnumerable<UserMaster> Users = _context.Users; var viewModel = from pd in _context.Users join p in _roleManager.Roles on pd.AccessRole equals p.Id where pd.AccessRole == p.Id where pd.IsDeleted == false select new { //Id = _context.Users.Select(x => x.Id), //Name = _context.Users.Select(x => x.FirstName) + " " + _context.Users.Select(x => x.LastName), //Email = _context.Users.Select(x => x.Email), //Role = _roleManager.Roles.Where(x => x.Id == pd.AccessRole).Select(x => x.Name) Id = pd.Id, Name = pd.FirstName + " " + pd.LastName, Email = pd.Email, Role = p.Name }; // var totalUsers = _context.Users.Count(); var totalUsers = viewModel.ToList().Count(); var json = Newtonsoft.Json.JsonConvert.SerializeObject(param); var sortDirection = HttpContext.Request.Query["sSortDir_0"]; // asc or desc var sortColumnIndex = Convert.ToInt32(HttpContext.Request.Query["iSortCol_0"]); if (!string.IsNullOrEmpty(param.sSearch)) { viewModel = viewModel.Where(z => z.Role.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.Email.ToString().ToLower().Contains(param.sSearch.ToLower()) || z.Name.ToLower().Contains(param.sSearch.ToLower())); } switch (sortColumnIndex) { case 1: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Name) : viewModel.OrderByDescending(z => z.Name); break; case 2: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Email) : viewModel.OrderByDescending(z => z.Email); break; case 3: viewModel = sortDirection == "asc" ? viewModel.OrderBy(z => z.Role) : viewModel.OrderByDescending(z => z.Role); break; default: viewModel = viewModel.OrderByDescending(z => z.Id); break; } var filteredUsersCount = viewModel.Count(); viewModel = viewModel.Skip(param.iDisplayStart).Take(param.iDisplayLength); return(Json(new { sEcho = param.sEcho, // iTotalRecords = totalUsers, iTotalRecords = filteredUsersCount, iTotalDisplayRecords = filteredUsersCount, aaData = viewModel })); }