// GET: VehicleAdvertisementsMVC/Details/5 public ActionResult Details(int?Reference_ID = 0) { CarSalesVehicleAdvertisement CarSalesVehicleAdvertisement; CarSalesDBEntities db = new CarSalesDBEntities(); VehicleAdvertisement vehicleAdvertisement = db.VehicleAdvertisements.Find(Reference_ID); if (Reference_ID != 0) { CarSalesVehicleAdvertisement = new CarSalesVehicleAdvertisement() { Archived = vehicleAdvertisement.Archived, AudoMeter = vehicleAdvertisement.AudoMeter, BodyType = vehicleAdvertisement.BodyType, DateAdvertised = vehicleAdvertisement.DateAdvertised, Description = vehicleAdvertisement.Description, EngineCapacity = vehicleAdvertisement.EngineCapacity, Feature = vehicleAdvertisement.Feature, Fuel = vehicleAdvertisement.Fuel, IsFeatured = vehicleAdvertisement.IsFeatured, Make = vehicleAdvertisement.Make, Model = vehicleAdvertisement.Model, Price = vehicleAdvertisement.Price, Reference_ID = vehicleAdvertisement.Reference_ID, Reference_No = vehicleAdvertisement.Reference_No, Sold = vehicleAdvertisement.Sold, Spects = vehicleAdvertisement.Spects, Title = vehicleAdvertisement.Title, Transmission = vehicleAdvertisement.Transmission }; return(View(CarSalesVehicleAdvertisement)); } return(HttpNotFound()); }
public override void OnActionExecuting(ActionExecutingContext filterContext) { base.OnActionExecuting(filterContext); CarSalesDBEntities db = new CarSalesDBEntities(); bool CheckUrCondition = false; string userName = filterContext.HttpContext.User.Identity.Name; var identityUser = UserManager.FindByName(userName); if (identityUser != null) { Seller seller = db.Sellers.Where(e => e.AspNetUsersId == identityUser.Id).FirstOrDefault(); if (seller != null) { CheckUrCondition = true; } } if (!CheckUrCondition) { filterContext.Result = new RedirectToRouteResult(new RouteValueDictionary(new { controller = "Home", action = "Index" })); } }
public ActionResult SellerRegisterDetail(int ID, string SearchText = "", int PageNos = 10, int PageIndex = 1) { CarSalesDBEntities db = new CarSalesDBEntities(); Seller seller = db.Sellers.Find(ID); if (seller == null) { return(HttpNotFound()); } var vehicleAdvertisements = db.VehicleAdvertisements.Where(e => (SearchText.Length > 0 ? e.Title.Contains(SearchText.Trim()) : true)); var VehicleSeller = db.VehicleSellers.Where(e => e.SellerID == ID); vehicleAdvertisements = vehicleAdvertisements.Join(VehicleSeller, VAdvertisement => VAdvertisement.Reference_ID, VSeller => VSeller.VehicleID, (VAdvertisement, VSeller) => VAdvertisement); int PageCount = (vehicleAdvertisements.Count() + PageNos - 1) / PageNos; int SkipCount = (PageIndex - 1) * PageNos; var vehicleAdd = vehicleAdvertisements.OrderBy(p => p.Reference_ID).Skip(SkipCount).Take(PageNos); SellerRegisterModel SellerRegisterModel = new SellerRegisterModel(); SellerRegisterModel.Advertisement = vehicleAdd.Select(e => new CarSalesVehicleAdvertisement() { AudoMeter = e.AudoMeter, BodyType = e.BodyType, Description = e.Description, EngineCapacity = e.EngineCapacity, Feature = e.Feature, Fuel = e.Fuel, IsFeatured = e.IsFeatured, Make = e.Make, Model = e.Model, Price = e.Price, Reference_ID = e.Reference_ID, Reference_No = e.Reference_No, Spects = e.Spects, Title = e.Title, Transmission = e.Transmission }); SellerRegisterModel.PageIndex = PageIndex; SellerRegisterModel.PageNos = PageCount; SellerRegisterModel.SearchText = SearchText; SellerRegisterModel.AspNetUsersId = seller.AspNetUsersId; SellerRegisterModel.ContactEMail = seller.ContactEMail; SellerRegisterModel.ContactMobile = seller.ContactMobile; SellerRegisterModel.ContactPhone = seller.ContactPhone; SellerRegisterModel.ID = seller.ID; SellerRegisterModel.Name = seller.Name; SellerRegisterModel.PickupAddress = seller.PickupAddress; SellerRegisterModel.PostCode = seller.PostCode; return(View(SellerRegisterModel)); }
public async Task <ActionResult> SellerRegister(SellerRegisterModel model) { var identityUser = await UserManager.FindByNameAsync(model.ContactEMail); if (identityUser != null) { Seller seller = new Seller() { AspNetUsersId = identityUser.Id, ContactEMail = model.ContactEMail, ContactMobile = model.ContactMobile, ContactPhone = model.ContactPhone, Name = model.Name, PickupAddress = model.PickupAddress, PostCode = model.PostCode }; CarSalesDBEntities db = new CarSalesDBEntities(); db.Sellers.Add(seller); db.SaveChanges(); return(RedirectToAction("SellerRegisterDetail", "Account", new { ID = seller.ID })); } var result = await UserManager.PasswordValidator.ValidateAsync(model.Password); if (!result.Succeeded) { ModelState.AddModelError("", result.Errors.FirstOrDefault()); return(View(model)); } var user = new IdentityUser(model.ContactEMail) { Email = model.ContactEMail }; var identityResult = await UserManager.CreateAsync(user, model.Password); if (identityResult.Succeeded) { Seller seller = new Seller() { AspNetUsersId = user.Id, ContactEMail = model.ContactEMail, ContactMobile = model.ContactMobile, ContactPhone = model.ContactPhone, Name = model.Name, PickupAddress = model.PickupAddress, PostCode = model.PostCode }; CarSalesDBEntities db = new CarSalesDBEntities(); db.Sellers.Add(seller); db.SaveChanges(); var signInStatus = SignInManager.PasswordSignIn(user.Email, model.Password, true, true); return(RedirectToAction("SellerRegisterDetail", "Account", new { ID = seller.ID })); } ModelState.AddModelError("", identityResult.Errors.FirstOrDefault()); return(View(model)); }
public static Seller GetSeller(string username) { CarSalesDBEntities db = new CarSalesDBEntities(); var identityUser = db.AspNetUsers.Where(e => e.UserName == username).FirstOrDefault(); if (identityUser != null) { Seller seller = db.Sellers.Where(e => e.AspNetUsersId == identityUser.Id).FirstOrDefault(); if (seller != null) { return(seller); } } return(null); }
// GET: VehicleAdvertisementsMVC/Create public ActionResult Edit(int?Reference_ID = 0) { ViewBag.Src = ""; ViewBag.Message = ""; CarSalesVehicleAdvertisement CarSalesVehicleAdvertisement; CarSalesDBEntities db = new CarSalesDBEntities(); VehicleAdvertisement vehicleAdvertisement = db.VehicleAdvertisements.Find(Reference_ID); if (Reference_ID != 0) { CarSalesVehicleAdvertisement = new CarSalesVehicleAdvertisement() { Archived = vehicleAdvertisement.Archived, AudoMeter = vehicleAdvertisement.AudoMeter, BodyType = vehicleAdvertisement.BodyType, DateAdvertised = vehicleAdvertisement.DateAdvertised, Description = vehicleAdvertisement.Description, EngineCapacity = vehicleAdvertisement.EngineCapacity, Feature = vehicleAdvertisement.Feature, Fuel = vehicleAdvertisement.Fuel, IsFeatured = vehicleAdvertisement.IsFeatured, Make = vehicleAdvertisement.Make, Model = vehicleAdvertisement.Model, Price = vehicleAdvertisement.Price, Reference_ID = vehicleAdvertisement.Reference_ID, Reference_No = vehicleAdvertisement.Reference_No, Sold = vehicleAdvertisement.Sold, Spects = vehicleAdvertisement.Spects, Title = vehicleAdvertisement.Title, Transmission = vehicleAdvertisement.Transmission }; } else { var ConfigSettings = db.ConfigSettings.FirstOrDefault(); CarSalesVehicleAdvertisement = new CarSalesVehicleAdvertisement() { Reference_No = ConfigSettings.VehicleAdvertisementNextRefNo.Value.ToString("00000") }; ConfigSettings.VehicleAdvertisementNextRefNo = ConfigSettings.VehicleAdvertisementNextRefNo + 1; db.SaveChanges(); } return(View(CarSalesVehicleAdvertisement)); }
public ActionResult SellerRegisterEdit(int ID) { CarSalesDBEntities db = new CarSalesDBEntities(); Seller seller = db.Sellers.Find(ID); if (seller == null) { return(HttpNotFound()); } return(View(new SellerRegisterModel() { AspNetUsersId = seller.AspNetUsersId, ContactEMail = seller.ContactEMail, ContactMobile = seller.ContactMobile, ContactPhone = seller.ContactPhone, ID = seller.ID, Name = seller.Name, PickupAddress = seller.PickupAddress, PostCode = seller.PostCode })); }
public CarSalesVehicleAdvertisement() { CarSalesDBEntities db = new CarSalesDBEntities(); VehicleBody = db.VehicleBodies.Select(e => new CarSalesVehicleBody() { BodyDescription = e.BodyDescription, ID = e.ID, ImageURL = e.ImageURL }); VehicleFuel = db.VehicleFuels.Select(e => new CarSalesVehicleFuel() { FuelType = e.FuelType, ID = e.ID }); VehicleMake = db.VehicleMakes.Select(e => new CarSalesVehicleMake() { VehicleMake1 = e.VehicleMake1, ID = e.ID }); VehicleModel = db.VehicleModels.Select(e => new CarSalesVehicleModel() { VehicleModel1 = e.VehicleModel1, ID = e.ID, VehicleMakeID = e.VehicleMakeID }); }
public ActionResult SellerRegisterEdit(SellerRegisterModel SellerRegisterModel) { CarSalesDBEntities db = new CarSalesDBEntities(); Seller seller = db.Sellers.Find(SellerRegisterModel.ID); if (seller == null) { return(HttpNotFound()); } else { seller.Name = SellerRegisterModel.Name; seller.ContactEMail = SellerRegisterModel.ContactEMail; seller.ContactMobile = SellerRegisterModel.ContactMobile; seller.ContactPhone = SellerRegisterModel.ContactPhone; seller.PickupAddress = SellerRegisterModel.PickupAddress; seller.PostCode = SellerRegisterModel.PostCode; db.Entry(seller).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("SellerRegisterDetail", "Account", new { ID = seller.ID })); } }
public VehicleRepository(CarSalesDBEntities context) { this.context = context; entities = context.Set <T>(); }
public ActionResult Edit(CarSalesVehicleAdvertisement CarSalesVehicleAdvertisement, HttpPostedFileBase postedFile) { CarSalesDBEntities db = new CarSalesDBEntities(); if (ModelState.IsValid) { int SellerID = CarSales.API.Helper.HelperClass.GetSeller(System.Web.HttpContext.Current.User.Identity.Name).ID; VehicleAdvertisement VehicleAdvertisement = db.VehicleAdvertisements.Find(CarSalesVehicleAdvertisement.Reference_ID); if (VehicleAdvertisement == null) { VehicleAdvertisement = new VehicleAdvertisement(); } VehicleAdvertisement.Archived = CarSalesVehicleAdvertisement.Archived; VehicleAdvertisement.AudoMeter = CarSalesVehicleAdvertisement.AudoMeter; VehicleAdvertisement.BodyType = CarSalesVehicleAdvertisement.BodyType; VehicleAdvertisement.DateAdvertised = CarSalesVehicleAdvertisement.DateAdvertised; VehicleAdvertisement.Description = CarSalesVehicleAdvertisement.Description; VehicleAdvertisement.EngineCapacity = CarSalesVehicleAdvertisement.EngineCapacity; VehicleAdvertisement.Feature = CarSalesVehicleAdvertisement.Feature; VehicleAdvertisement.Fuel = CarSalesVehicleAdvertisement.Fuel; VehicleAdvertisement.IsFeatured = CarSalesVehicleAdvertisement.IsFeatured; VehicleAdvertisement.Make = CarSalesVehicleAdvertisement.Make; VehicleAdvertisement.Model = CarSalesVehicleAdvertisement.Model; VehicleAdvertisement.Price = CarSalesVehicleAdvertisement.Price; VehicleAdvertisement.Reference_ID = CarSalesVehicleAdvertisement.Reference_ID; VehicleAdvertisement.Reference_No = CarSalesVehicleAdvertisement.Reference_No; VehicleAdvertisement.Sold = CarSalesVehicleAdvertisement.Sold; VehicleAdvertisement.Spects = CarSalesVehicleAdvertisement.Spects; VehicleAdvertisement.Title = CarSalesVehicleAdvertisement.Title; VehicleAdvertisement.Transmission = CarSalesVehicleAdvertisement.Transmission; if (CarSalesVehicleAdvertisement.Reference_ID == 0) { db.VehicleAdvertisements.Add(VehicleAdvertisement); db.SaveChanges(); var VehicleSeller = new VehicleSeller() { SellerID = SellerID, VehicleID = VehicleAdvertisement.Reference_ID, }; db.VehicleSellers.Add(VehicleSeller); db.SaveChanges(); } else { db.SaveChanges(); } if (postedFile != null) { string path = Server.MapPath("~/Uploads/"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } postedFile.SaveAs(path + CarSalesVehicleAdvertisement.Reference_No + ".jpg"); } return(RedirectToAction("SellerRegisterDetail", "Account", new { ID = SellerID })); } return(View(CarSalesVehicleAdvertisement)); }