private static pig AddPigDetails(pigModel pigToAdd, pig newPig)
{
newPig.tagNumber = pigToAdd.tagNumber;
newPig.pigColor = pigToAdd.pigColor;
newPig.pigSex = pigToAdd.pigSex;
newPig.description = pigToAdd.description;
newPig.status = pigToAdd.status;
newPig.dateOfAcquisition = pigToAdd.dateOfAcquisition;
newPig.approximateAgeInMonths = pigToAdd.approximateAgeInMonths;
newPig.approximateAgeInYears = pigToAdd.approximateAgeInYears;
return(newPig);
}
public ActionResult AddASale(sale newSale)
{
if (ModelState.IsValid)
{
pig soldPig = db.pigs.Find(newSale.pigNumber);
soldPig.pigState.state = "Sold";
db.sales.Add(newSale);
db.SaveChanges();
return(RedirectToAction("AllSales"));
}
ViewBag.pigNumber = loadActivePigs();
ViewBag.userID = loadUsers();
ViewBag.status = loadFieldStates();
ViewBag.customerID = loadCustomers();
return(View(newSale));
}
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());
}
