public ResponseMessage Paging(PagingModel model) { ResponseMessage responseMessage = new ResponseMessage(); List<TransactionHistoryModel> transactionHistoryModel = new List<TransactionHistoryModel>(); transactionHistoryModel = transactionHistoryService.Paging(model); responseMessage.totalRecords = transactionHistoryModel.Count(); transactionHistoryModel = transactionHistoryModel.OrderBy(x => x.CustomerEmail).Skip((model.CurrentPageIndex - 1) * model.PageSize).Take(model.PageSize).ToList(); transactionHistoryModel.ForEach(x => { JobModel jobModel = new JobModel(); ServiceProviderModel serviceProviderModel = new ServiceProviderModel(); if (x.JobId > 0) { jobModel = jobService.GetJobById(x.JobId); } serviceProviderModel = serviceProviderService.GetServiceProviderById(jobModel.ServiceProviderId); x.ServiceProviderName = serviceProviderModel.CompanyName; }); responseMessage.data = transactionHistoryModel; return responseMessage; }
public List<ServiceProviderModel> Paging(PagingModel model) { //unitOfWork.StartTransaction(); ServiceProviderRepository repo = new ServiceProviderRepository(unitOfWork); List<ServiceProviderModel> serviceProviderModelList = new List<ServiceProviderModel>(); List<ServiceProvider> serviceProviderList = new List<ServiceProvider>(); //ResponseMessage responseMessage = new ResponseMessage(); //PagingInfo Info = new PagingInfo(); string searchparam = model.SearchText == null ? "" : model.SearchText; serviceProviderList = repo.GetAll().Where(x => x.CompanyName.ToLower().Contains(searchparam.ToLower())).ToList(); //unitOfWork.Commit(); AutoMapper.Mapper.Map(serviceProviderList, serviceProviderModelList); return serviceProviderModelList; }
public List<EmployeeModel> Paging(PagingModel model) { //unitOfWork.StartTransaction(); EmployeeRepository repo = new EmployeeRepository(unitOfWork); List<EmployeeModel> employeeModelList = new List<EmployeeModel>(); List<Employee> employeeList = new List<Employee>(); //ResponseMessage responseMessage = new ResponseMessage(); //PagingInfo Info = new PagingInfo(); string searchparam = model.SearchText == null ? "" : model.SearchText; if(searchparam!="") employeeList = repo.GetAll().Where(x=>x.FirstName.ToLower().Contains(searchparam.ToLower())).ToList(); else employeeList = repo.GetAll().ToList(); //unitOfWork.Commit(); AutoMapper.Mapper.Map(employeeList, employeeModelList); return employeeModelList; }
public ResponseMessage Paging(PagingModel model) { ResponseMessage responseMessage = new ResponseMessage(); List<EmployeeModel> employeeModel = new List<EmployeeModel>(); employeeModel = employeeService.Paging(model); //var ids = employeeModel.Select(x => x.EmployeeId).ToList(); ServiceProviderEmployeeMappingService service = new ServiceProviderEmployeeMappingService(); responseMessage.totalRecords = employeeModel.Count(); employeeModel = employeeModel.OrderBy(x => x.FirstName).Skip((model.CurrentPageIndex - 1) * model.PageSize).Take(model.PageSize).ToList(); employeeModel = service.GetServiceProviderByEmployeeId(employeeModel); responseMessage.data = employeeModel; return responseMessage; }
public List<JobModel> Paging(PagingModel model) { //unitOfWork.StartTransaction(); JobRepository repo = new JobRepository(unitOfWork); List<JobModel> jobModelList = new List<JobModel>(); List<Job> jobList = new List<Job>(); //ResponseMessage responseMessage = new ResponseMessage(); //PagingInfo Info = new PagingInfo(); string searchparam = model.SearchText == null ? "" : model.SearchText; jobList = repo.GetAll().Where(x => x.Description.ToLower().Contains(searchparam.ToLower())).OrderByDescending(x=>x.JobId).ToList(); //unitOfWork.Commit(); AutoMapper.Mapper.Map(jobList, jobModelList); return jobModelList; }
public ResponseMessage Paging(PagingModel model) { ResponseMessage responseMessage = new ResponseMessage(); List<JobModel> jobModel = new List<JobModel>(); jobModel = jobService.Paging(model); responseMessage.totalRecords = jobModel.Count(); jobModel = jobModel.OrderBy(x => x.Description).Skip((model.CurrentPageIndex - 1) * model.PageSize).Take(model.PageSize).ToList(); responseMessage.data = jobModel; return responseMessage; }
public List<TransactionHistoryModel> Paging(PagingModel model) { //unitOfWork.StartTransaction(); TransactionHistoryRepository repo = new TransactionHistoryRepository(unitOfWork); List<TransactionHistoryModel> transactionHistoryModelList = new List<TransactionHistoryModel>(); List<TransactionHistory> transactionHistoryList = new List<TransactionHistory>(); //ResponseMessage responseMessage = new ResponseMessage(); //PagingInfo Info = new PagingInfo(); string searchparam = model.SearchText == null ? "" : model.SearchText; transactionHistoryList = repo.GetAll().Where(x => !string.IsNullOrEmpty(x.CustomerEmail) && x.CustomerEmail.ToLower().Contains(searchparam.ToLower())).OrderByDescending(x=>x.CartId).ToList(); //unitOfWork.Commit(); AutoMapper.Mapper.Map(transactionHistoryList, transactionHistoryModelList); return transactionHistoryModelList; }
public ResponseMessage RolesPaging(PagingModel model) { ResponseMessage responseMessage = new ResponseMessage(); string searchparam = model.SearchText == null ? "" : model.SearchText; List<RoleBindingModel> roles; URFXDbContext db = new URFXDbContext(); if (searchparam == "") { roles = db.Roles.Select(x => new RoleBindingModel() { Id = x.Id, Name = x.Name }).ToList(); } else { roles = db.Roles.Select(x => new RoleBindingModel() { Id = x.Id, Name = x.Name }).Where(y => y.Name.ToLower().Contains(searchparam.ToLower())).ToList(); } responseMessage.totalRecords = roles.Count(); roles = roles.OrderBy(x => x.Name).Skip((model.CurrentPageIndex - 1) * model.PageSize).Take(model.PageSize).ToList(); responseMessage.data = roles; return responseMessage; }
public ResponseMessage Paging(PagingModel model) { ResponseMessage responseMessage = new ResponseMessage(); var context = new URFXDbContext(); var role = context.Roles.Where(x => x.Name == URFXRoles.Admin.ToString()).SingleOrDefault(); string searchparam = model.SearchText == null ? "" : model.SearchText; List<ApplicationUser> users = UserManager.Users.Where(x => (x.Roles.Where(r => r.RoleId != role.Id).Count() > 0)).ToList(); users.ForEach(x => { var roles = UserManager.GetRoles(x.Id); var userRole = roles.FirstOrDefault(); x.Role = userRole; }); if (searchparam != "") { users = users.Where(x => x.Email.ToLower().Contains(searchparam.ToLower())).ToList(); } responseMessage.totalRecords = users.Count(); users = users.OrderBy(x => x.UserName).Skip((model.CurrentPageIndex - 1) * model.PageSize).Take(model.PageSize).ToList(); responseMessage.data = users; return responseMessage; }