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