public ActionResult Create(Supplier supplier)
{
SupplierRepository repo = new SupplierRepository();
if (ModelState.IsValid)
{
int countSupplier = repo.SupplierDuplicationCheck(supplier);
//if exists. display an error.
if (countSupplier > 0)
{
ViewBag.DuplicateError = "Already Exists!";
return View(supplier);
}
int countAbbrevation = repo.SupplierAbbervationCheck(supplier);
//if yes, display an error
if (countAbbrevation > 0)
{
ViewBag.AbbrevationDuplicateError = "Already Exists! Choose New.";
return View(supplier);
}
db.Suppliers.Add(supplier);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(supplier);
}
public int SupplierDuplicationCheck(Supplier supplier)
{
//check if the input supplier name already exists
List<Supplier> _supplier = (from s in db.Suppliers
where s.Name == supplier.Name
select s).ToList();
return _supplier.Count;
}
public int SupplierAbbervationCheck(Supplier supplier)
{
//check if abbrevation already exists
List<Supplier> _supplierAbbr = (from s in db.Suppliers
where s.Abbrevation == supplier.Abbrevation
select s).ToList();
return _supplierAbbr.Count;
}
//Binding to Dropdownlist : Supplier
public JsonResult BindDatatoDropdownSupplier()
{
var supplierList = (from s in db.Suppliers
select new { s.ID, s.Name }).ToList();
List<Supplier> _supplier = new List<Supplier>();
foreach (var item in supplierList)
{
Supplier s = new Supplier();
s.ID = item.ID;
s.Name = item.Name;
_supplier.Add(s);
}
return Json(_supplier, JsonRequestBehavior.AllowGet);
}
public ActionResult Create(Supplier supplier)
{
SupplierRepository repo = new SupplierRepository();
if (ModelState.IsValid)
{
int countSupplier = repo.SupplierDuplicationCheck(supplier);
if (Request.IsAjaxRequest())
{
if (countSupplier > 0)
{
ViewBag.DuplicateError = "Already Exists!";
return Json("duplicate" , JsonRequestBehavior.AllowGet);
}
//Add supplier to dataSet
db.Suppliers.Add(supplier);
//save changes ToString database
db.SaveChanges();
//redirect to index
return Json("success", JsonRequestBehavior.AllowGet);
}
//If already exists. display an error.
if (countSupplier > 0)
{
ViewBag.DuplicateError = "Already Exists!";
return View(supplier);
}
//Add supplier to dataSet
db.Suppliers.Add(supplier);
//save changes ToString database
db.SaveChanges();
//redirect to index
return RedirectToAction("Index");
}
return View(supplier);
}
public ActionResult Edit(Supplier supplier)
{
if (ModelState.IsValid && supplier != null)
{
var original = db.Suppliers.Find(supplier.ID);
if(original.Name != supplier.Name)
{
SupplierRepository repo = new SupplierRepository();
int countSupplier = repo.SupplierDuplicationCheck(supplier);
//If already exists. display an error.
if (countSupplier > 0)
{
ViewBag.DuplicateError = "Already Exists!";
return View(supplier);
}
}
db.Entry(original).CurrentValues.SetValues(supplier);
//Save changes to Database
db.SaveChanges();
//redirect to Index page
return RedirectToAction("Index");
}
return View(supplier);
}
public ActionResult Edit(Supplier supplier)
{
SupplierRepository repo = new SupplierRepository();
if (ModelState.IsValid)
{
string supplierNameCheck = supplier.Name.ToUpper();
string abbrevationCheck = supplier.Abbrevation.ToUpper();
supplier.Name = supplierNameCheck;
supplier.Abbrevation = abbrevationCheck;
db.Entry(supplier).State = EntityState.Modified;
db.Suppliers.Add(supplier);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(supplier);
}