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"));
}
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 CitiesTable(CityProvinceViewModel cityProvinceViewModel, int?pageNo)
{
try
{
int PageNo = pageNo.HasValue ? pageNo.Value > 0 ? pageNo.Value : 1 : 1;
if (cityProvinceViewModel.SelectedProvince == null)
{
AutoSolutionContext autoSolution = new AutoSolutionContext();
var model = autoSolution.Cities.OrderBy(x => x.CityName).Skip((PageNo - 1) * 10).Take(10).ToList();
//var model = _unitOfWork.City.GetAll();
int TotalCount = _unitOfWork.City.Count();
CityProvinceViewModel cityProvinceView = new CityProvinceViewModel();
cityProvinceView.CitiesList = model;
cityProvinceView.Pager = new Pager(TotalCount, pageNo, 10);
return(PartialView("_CitiesTable", cityProvinceView));
}
else
{
int ProID = Convert.ToInt32(cityProvinceViewModel.SelectedProvince);
CityRepository cityRepository = new CityRepository(new AutoSolutionContext());
var cities = _unitOfWork.City.Get(x => x.ProvinceId == ProID);
CityProvinceViewModel cityProvinceViewModel1 = new CityProvinceViewModel();
cityProvinceViewModel1.CitiesList = cities.ToList();
return(PartialView("_CitiesTable", cityProvinceViewModel1));
}
}
catch (Exception)
{
return(View("Error"));
}
}
public JsonResult AddImages()
{
JsonResult jsonResult = new JsonResult();
List <object> PicJson = new List <object>();
AutoSolutionContext autoSolutionContext = new AutoSolutionContext();
var RequestPicx = Request.Files;
for (int i = 0; i < RequestPicx.Count; i++)
{
var pic = RequestPicx[i];
var FileName = pic.FileName;
//var FileName = Guid.NewGuid() + Path.GetExtension(pic.FileName);
var path = Server.MapPath("~/AutoImages/") + FileName;
pic.SaveAs(path);
var Dbimg = new Image();
Dbimg.AddedDate = DateTime.Now;
Dbimg.ImageName = FileName;
Dbimg.ImagePath = path;
autoSolutionContext.Images.Add(Dbimg);
autoSolutionContext.SaveChanges();
PicJson.Add(new
{
ID = Dbimg.ImageId,
PicURL = FileName
});
}
jsonResult.Data = PicJson;
return(jsonResult);
}
public UnitOfWork(AutoSolutionContext context)
{
_context = context;
User = new UserRepository(_context);
City = new CityRepository(_context);
CityArea = new CityAreaRepository(_context);
Province = new ProvinceRepository(_context);
ServiceCategory = new ServiceCategoryRepository(_context);
UserServiceCatogory = new UserServiceCatogoryRepository(_context);
VehicleManufacturer = new VehicleManufacturerRepository(_context);
RoleRepository = new RoleRepository(_context);
VehicleModel = new VehicleModelRepository(_context);
TransmissionType = new TransmissionTypeRepository(_context);
VehicleEngineType = new VehicleEngineTypeRepository(_context);
PartsProductsCategory = new PartsProductsCategoryRepository(_context);
PartsSubCategory = new PartsSubCategoryRepository(_context);
VehicleVersion = new VehicleVersionRepository(_context);
PartsProductManufacturer = new PartsProductManufacturerRepository(_context);
PartsProducts = new PartsProductsRepository(_context);
Template = new TemplateRepository(_context);
WishList = new WishListRepository(_context);
Order = new OrderRepository(_context);
OrderDetail = new OrderDetailRepository(_context);
OrderStatus = new OrderStatusRepository(_context);
}
public JsonResult GetCityArea(string Prefix, string SelectedCityId)
{
int CityID = Convert.ToInt32(SelectedCityId);
AutoSolutionContext autoSolutionContext = new AutoSolutionContext();
var ServiceCategory = (from ca in autoSolutionContext.CityAreas
where ca.CityAreaName.StartsWith(Prefix) && ca.CityId == CityID
select new
{
id = ca.CityAreaID,
label = ca.CityAreaName,
//val = ca.CityAreaName
}).ToList();
return(Json(ServiceCategory, JsonRequestBehavior.AllowGet));
}
public RoleRepository(AutoSolutionContext context)
: base(context)
{
}
public PartsProductsRepository(AutoSolutionContext context) : base(context)
{
}
public TransmissionTypeRepository(AutoSolutionContext context) : base(context)
{
}
public ProvinceRepository(AutoSolutionContext context) : base(context)
{
}
public VehicleModelRepository(AutoSolutionContext context)
: base(context)
{
}
public PartsSubCategoryRepository(AutoSolutionContext context)
: base(context)
{
}
public UserServiceCatogoryRepository(AutoSolutionContext context)
: base(context)
{
}
public VehicleEngineTypeRepository(AutoSolutionContext context) : base(context)
{
}
public OrderDetailRepository(AutoSolutionContext context) : base(context)
{
}
public Repository(AutoSolutionContext dbcontext)
{
_dbContext = dbcontext;
Entities = _dbContext.Set <TEntity>();
}
public UnitOfWork(AutoSolutionContext autoSolutionContext)
{
AutoSolutionContext = autoSolutionContext;
}
public VehicleVersionRepository(AutoSolutionContext context)
: base(context)
{
}
public ActionResult Edit(PartsProductsViewModel partsProductsViewModel)
{
try
{
// PartsProduct partsProduct = new PartsProduct();
var ImageIds = partsProductsViewModel.PictureIDs.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(ID => int.Parse(ID)).ToList();
if (partsProductsViewModel == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PartsProduct partsProduct = new PartsProduct();
partsProduct = _unitOfWork.PartsProducts.GetByID(partsProductsViewModel.PartsProductId);
AutoSolutionContext autoSolutionContext = new AutoSolutionContext();
var partimagesDeleted = autoSolutionContext.PartProductImages.Where(x => x.PartsProductId == partsProduct.PartsProductId).ToList();
foreach (var item in partimagesDeleted)
{
autoSolutionContext.PartProductImages.Remove(item);
// autoSolutionContext.Images.Remove(item.Image);
}
//foreach(var item in ImageIds)
// {
// var iamgeItem= autoSolutionContext.Images.Where(x => x.ImageId == item).FirstOrDefault();
// autoSolutionContext.Images.Remove(iamgeItem);
// }
autoSolutionContext.SaveChanges();
partsProduct.PartProductImages = new List <PartProductImages>();
foreach (var PicId in ImageIds)
{
PartProductImages partProductImages = new PartProductImages()
{
ImageId = PicId
};
partsProduct.PartProductImages.Add(partProductImages);
}
//vehicleVersion.VehicleVersionId = vehicleVersionViewModel.VehicleVersionId;
partsProduct.AddedDate = DateTime.Now;
partsProduct.EndYear = Convert.ToInt32(partsProductsViewModel.EndYear);
partsProduct.startYear = Convert.ToInt32(partsProductsViewModel.startYear);
partsProduct.UnitPrice = partsProductsViewModel.UnitPrice;
partsProduct.ShortDescription = partsProductsViewModel.ShortDescription;
partsProduct.LongDescription = partsProductsViewModel.LongDescription;
partsProduct.PartsProductName = partsProductsViewModel.PartsProductName;
partsProduct.VehicleManufacturerId = Convert.ToInt32(partsProductsViewModel.SelectedManufacturer);
partsProduct.PartsProductsSubCategoryId = Convert.ToInt32(partsProductsViewModel.SelectedPartsProductSubCategory);
partsProduct.VehicleModelId = Convert.ToInt32(partsProductsViewModel.SelectedModel);
partsProduct.PartsProductManufacturerId = Convert.ToInt32(partsProductsViewModel.SelectedPartProductManufacturer);
_unitOfWork.PartsProducts.Update(partsProduct);
_unitOfWork.Complete();
_unitOfWork.Dispose();
}
catch (Exception)
{
throw;
}
return(RedirectToAction("GetPartsProduct"));
}
public VehicleManufacturerRepository(AutoSolutionContext context) : base(context)
{
}
public UserRepository(AutoSolutionContext context)
: base(context)
{
}
public TemplateRepository(AutoSolutionContext context) : base(context)
{
}
public CityAreaRepository(AutoSolutionContext context) : base(context)
{
}
public OrderStatusRepository(AutoSolutionContext context) : base(context)
{
}
public PartsProductManufacturerRepository(AutoSolutionContext context) : base(context)
{
}
public WishListRepository(AutoSolutionContext context)
: base(context)
{
}
