public ActionResult edit(int id) { try { CreditWorksEntities db = new CreditWorksEntities(); Vehicle_Category category = db.Vehicle_Category.Where(t => t.Id == id).FirstOrDefault(); if (category == null) { return(RedirectToAction("error", "Category")); } bool isOverlap = overlapRange(category.RangeMin, category.RangeMax); if (isOverlap) { return(RedirectToAction("error", "Category")); } return(View(category)); } catch (Exception) { throw; } }
public ActionResult Edit(int id, FormCollection formValues) { try { CreditWorksEntities db = new CreditWorksEntities(); Vehicle_Category category = db.Vehicle_Category.Where(t => t.Id == id).FirstOrDefault(); if (category == null) { return(RedirectToAction("Index", "Category")); } category.CategoryName = Request.Form["CategoryName"]; category.RangeMin = Convert.ToInt32(Request.Form["RangeMin"]); category.RangeMax = Convert.ToInt32(Request.Form["RangeMax"]); category.CategoryIcon = Request.Form["CategoryIcon"]; db.SaveChanges(); return(RedirectToAction("Index", "Category")); } catch (Exception) { throw; } }
public ActionResult submitForm(Vehicle_Category category) { try { CreditWorksEntities db = new CreditWorksEntities(); bool isOverlap = overlapRange(category.RangeMin, category.RangeMax); if (isOverlap) { return(RedirectToAction("error", "Category")); } db.Vehicle_Category.Add(new Vehicle_Category() { CategoryName = category.CategoryName, CategoryIcon = category.CategoryIcon, RangeMax = category.RangeMax, RangeMin = category.RangeMin }); db.SaveChanges(); return(RedirectToAction("Create", "Category")); } catch (Exception) { throw; } }
public ActionResult Create() { CreditWorksEntities db = new CreditWorksEntities(); ViewData["manufacturer"] = db.Vehicle_Manufacturer.ToList(); return(View()); }
public ActionResult index() { CreditWorksEntities db = new CreditWorksEntities(); ViewData.Model = db.Vehicle_Category.ToList(); return(View()); }
private static bool overlapRange(int rangeMin, int rangeMax) { if (rangeMax <= rangeMin) { return(true); } CreditWorksEntities db = new CreditWorksEntities(); int categoryId = db.VehicleInfo.Where(x => x.WeightOfVehicle >= rangeMin) .Where(y => y.WeightOfVehicle <= rangeMax).FirstOrDefault().CategoryId; if (categoryId == 0) { return(false); } else { return(true); } }
public ActionResult Delete(int id) { try { CreditWorksEntities db = new CreditWorksEntities(); var categoryList = db.Vehicle_Category; Vehicle_Category category = categoryList.Where(t => t.Id == id).FirstOrDefault(); int count = categoryList.Count(); if (category == null) { return(RedirectToAction("Index", "Category")); } VehicleInfo vehicle = db.VehicleInfo.Where(t => t.CategoryId == id).FirstOrDefault(); //Cannot delete if categoryId has been used by VehicleInfo if (vehicle != null) { return(RedirectToAction("error", "Category")); } //Cannot delete if less than 2 category if (count <= 2) { return(RedirectToAction("Index", "Category")); } categoryList.Remove(category); db.SaveChanges(); return(RedirectToAction("Index", "Category")); } catch (Exception) { throw; } }
public ActionResult SubmitForm(VehicleInfo info) { try { CreditWorksEntities db = new CreditWorksEntities(); List <Vehicle_Category> categoryList = db.Vehicle_Category.ToList(); //use range to find categoryId foreach (var category in categoryList) { if (category.RangeMin <= info.WeightOfVehicle && category.RangeMax >= info.WeightOfVehicle) { info.CategoryId = category.Id; } } //can not be created if can not find match Category Id if (info.OwnerName != null && info.YearOfManufacture != 0 && info.WeightOfVehicle != 0 && info.CategoryId != 0) { db.VehicleInfo.Add(new VehicleInfo() { ManufacturerId = info.ManufacturerId, OwnerName = info.OwnerName, CategoryId = info.CategoryId, WeightOfVehicle = info.WeightOfVehicle, YearOfManufacture = info.YearOfManufacture }); db.SaveChanges(); } return(RedirectToAction("Create", "VehicleInfo")); } catch (Exception) { throw; } }