// Creating a single PODetails entry
public static bool CreateSinglePODetails(ReorderRecord r)
{
using (SA45Team12AD context = new SA45Team12AD())
{
try
{
// Finding the newly created PO record
PORecord pr = context.PORecords.OrderByDescending(x => x.PONumber).First();
// Req to populate the values for the new entry
InventoryCatalogue iv = context.InventoryCatalogues.Where(x => x.ItemID.Equals(r.ItemID)).First(); // To retrieve UOM
SupplierCatalogue sc = context.SupplierCatalogues.Where(x => x.ItemID.Equals(r.ItemID)).Where(y => y.SupplierID.Equals(r.SupplierID)).First(); // TO retrieve price
// Creating our new entry...
PORecordDetail pd = new PORecordDetail();
pd.PONumber = pr.PONumber;
pd.ItemID = r.ItemID;
pd.Quantity = r.OrderedQuantity;
pd.UOM = iv.UOM;
pd.UnitPrice = sc.Price;
context.PORecordDetails.Add(pd);
context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
// Creating a single PO entry
public static bool CreateSinglePO(ReorderRecord r)
{
using (SA45Team12AD context = new SA45Team12AD())
{
try
{
SupplierList s = context.SupplierLists.Where(x => x.SupplierID.Equals(r.SupplierID)).First();
PORecord p = new PORecord();
p.DateRequested = DateTime.Now;
p.RecipientName = "System-generated";
p.DeliveryAddress = "21 Lower Kent Ridge Rd, Singapore 119077"; // Default address
p.SupplierID = r.SupplierID;
p.CreatedBy = "Logic University Stationery Store";
p.ExpectedDelivery = DateTime.Now.AddDays(Convert.ToDouble(s.OrderLeadTime));
p.Status = "Pending";
context.PORecords.Add(p);
context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}