public ActionResult EditSupplier(int id) { supplier toBeEdited = db.suppliers.FirstOrDefault(u => u.supplierID == id); ViewBag.supplierState = loadFieldStates(); return(View(toBeEdited)); }
public ActionResult EditSupplier(supplier updated) { supplier toBeEdited = db.suppliers.FirstOrDefault(u => u.supplierID == updated.supplierID); toBeEdited.supplierName = updated.supplierName; toBeEdited.supplierPhoneNumber = updated.supplierPhoneNumber; toBeEdited.supplierEmail = updated.supplierEmail; toBeEdited.supplierState = updated.supplierState; db.SaveChanges(); return(RedirectToAction("Suppliers")); }
public ActionResult AddSupplier(supplier newSupplier) { if (ModelState.IsValid) { db.suppliers.Add(newSupplier); db.SaveChanges(); return(RedirectToAction("Suppliers")); } ViewBag.supplierState = loadFieldStates(); return(View()); }
public ActionResult SupplierDetails(int id) { supplier supplierInformation = db.suppliers.FirstOrDefault(u => u.supplierID == id); return(View(supplierInformation)); }
public ActionResult AddPigs(pigModel pigToAdd) { pig newPig = new pig(); pigRelationship newPigRelationship = new pigRelationship(); pig checkTagNumber = db.pigs.Where(u => u.tagNumber == pigToAdd.tagNumber).FirstOrDefault(); if (checkTagNumber != null) { loadPigDropDownList(); ViewBag.Message = "Tag number " + pigToAdd.tagNumber.ToString() + " already exist, please assign a unique tag"; return(View(pigToAdd)); } if (pigToAdd.source == 1) { newPig = AddPigDetails(pigToAdd, newPig); newPig.source = pigToAdd.source; if (pigToAdd.fatherID != "Unknown") { newPigRelationship.malePig = Convert.ToInt32(pigToAdd.fatherID); } if (pigToAdd.motherID != "Unknown") { newPigRelationship.femalePig = Convert.ToInt32(pigToAdd.motherID); } db.pigs.Add(newPig); //db.SaveChanges(); //pig newlyAddedPig = db.pigs.Single(u => u.tagNumber == newPig.tagNumber); newPigRelationship.siblings = Convert.ToInt32(newPig.pigNumber); newPigRelationship.status = 1; db.pigRelationships.Add(newPigRelationship); db.SaveChanges(); return(RedirectToAction("AllPigs")); } else if (pigToAdd.source == 2) { newPig = AddPigDetails(pigToAdd, newPig); newPig.source = pigToAdd.source; db.pigs.Add(newPig); //pig newlyAddedPig = db.pigs.Single(u => u.tagNumber == newPig.tagNumber); input boughtPig = new input(); boughtPig.product = 1; boughtPig.costPerProduct = pigToAdd.buyingPrice; boughtPig.numberOfProducts = 1; boughtPig.total = pigToAdd.buyingPrice; boughtPig.date = Convert.ToDateTime(pigToAdd.dateOfAcquisition.ToShortDateString()); boughtPig.userID = 1; boughtPig.status = 1; boughtPig.pigID = newPig.pigNumber; db.inputs.Add(boughtPig); supplier newSupplier = new supplier(); if (pigToAdd.supplierID == "Add Supplier") { newSupplier.supplierName = pigToAdd.supplierName; newSupplier.supplierEmail = pigToAdd.supplierEmail; newSupplier.supplierPhoneNumber = pigToAdd.supplierPhoneNumber; newSupplier.supplierState = 1; newSupplier.outSourcedPigs.Add(new outSourcedPig() { pigNumber = newPig.pigNumber, status = 1 }); db.suppliers.Add(newSupplier); } else { db.outSourcedPigs.Add(new outSourcedPig() { supplierID = Convert.ToInt32(pigToAdd.supplierID), pigNumber = newPig.pigNumber, status = 1 }); } if (pigToAdd.fatherID != "Unknown") { newPigRelationship.malePig = Convert.ToInt32(pigToAdd.fatherID); } if (pigToAdd.motherID != "Unknown") { newPigRelationship.femalePig = Convert.ToInt32(pigToAdd.motherID); } newPigRelationship.siblings = Convert.ToInt32(newPig.pigNumber); newPigRelationship.status = 1; db.pigRelationships.Add(newPigRelationship); db.SaveChanges(); return(RedirectToAction("AllPigs")); } return(View()); }