public ActionResult AddExpense(input newExpense)
{
if (ModelState.IsValid)
{
db.inputs.Add(newExpense);
db.SaveChanges();
RedirectToAction("Expenses");
}
ViewBag.product = loadProducts();
ViewBag.userID = loadUsers();
ViewBag.status = loadFieldStates();
ViewBag.pigID = loadPigs();
return(View(newExpense));
}
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());
}