public ActionResult GetVehicleManufacturer(string search, int?pageNo) { try { if (search != null) { int PageNo = pageNo.HasValue ? pageNo.Value > 0 ? pageNo.Value : 1 : 1; AutoSolutionContext autoSolution = new AutoSolutionContext(); var model = autoSolution.VehicleManufacturers.OrderBy(x => x.VehicleManufacturerName).Where(x => x.VehicleManufacturerName.Contains(search)).Skip((PageNo - 1) * 10).Take(10).ToList(); int TotalCount = autoSolution.VehicleManufacturers.Where(x => x.VehicleManufacturerName.Contains(search)).Count(); //int TotalCount = _unitOfWork.VehicleManufacturer.Count(); VehicleManufacturerViewModel vehicleManufacturerView = new VehicleManufacturerViewModel(); vehicleManufacturerView.VehicleManufacturersList = model; vehicleManufacturerView.Pager = new Pager(TotalCount, pageNo, 10); return(PartialView("_VehicleManufacturer", vehicleManufacturerView)); } else { int PageNo = pageNo.HasValue ? pageNo.Value > 0 ? pageNo.Value : 1 : 1; AutoSolutionContext autoSolution = new AutoSolutionContext(); var model = autoSolution.VehicleManufacturers.OrderBy(x => x.VehicleManufacturerName).Skip((PageNo - 1) * 10).Take(10).ToList(); int TotalCount = _unitOfWork.VehicleManufacturer.Count(); VehicleManufacturerViewModel vehicleManufacturerView = new VehicleManufacturerViewModel(); vehicleManufacturerView.VehicleManufacturersList = model; vehicleManufacturerView.Pager = new Pager(TotalCount, pageNo, 10); return(PartialView("_VehicleManufacturer", vehicleManufacturerView)); } } catch (Exception) { return(View("Error")); } }
public ActionResult AddNew(VehicleManufacturerViewModel vehicleManufacturerViewModel) { if (ModelState.IsValid) { try { AutoSolutionContext autoSolutionContext = new AutoSolutionContext(); var isExist = autoSolutionContext.VehicleManufacturers.FirstOrDefault(x => x.VehicleManufacturerName.ToLower() == vehicleManufacturerViewModel.VehicleManufacturer.ToLower()); if (isExist != null) { return(RedirectToAction("GetVehicleManufacturer")); } else { VehicleManufacturer vehicle = new VehicleManufacturer(); vehicle.AddedDate = DateTime.Now; vehicle.IsActive = true; vehicle.UpdateDate = DateTime.Now; vehicle.VehicleManufacturerName = vehicleManufacturerViewModel.VehicleManufacturer; autoSolutionContext.VehicleManufacturers.Add(vehicle); autoSolutionContext.SaveChanges(); return(RedirectToAction("GetVehicleManufacturer")); } } catch (Exception) { throw; } } return(RedirectToAction("Index")); }