public void Delete(int POId)
{
QuickReceiptEntities ctx = new QuickReceiptEntities();
var existingPO = (from p in ctx.PurchaseOrders
where p.POId == POId
select p).FirstOrDefault();
if (existingPO == null)
{
throw new ObjectNotFoundException("Purchase Order with POId " + POId + "couldn't be found int the database. No deletion was performed.");
}
ctx.DeleteObject(existingPO);
ctx.SaveChanges();
}
public QuickReceipt.Models.PurchaseOrder Save(QuickReceipt.Models.PurchaseOrder po)
{
QuickReceiptEntities ctx = new QuickReceiptEntities();
var dbPO = Mapper.Map(po);
var existingPO = (from p in ctx.PurchaseOrders
where p.POId == po.POId
select p).FirstOrDefault();
if (existingPO != null)
{
existingPO.ProfileId = (po.ProfileId == 0 ? null : (int?)po.ProfileId);
existingPO.GroupId = (po.GroupId == 0 ? null : (int?)po.GroupId);
existingPO.GroupQRCode = po.GroupQRCode;
existingPO.PurchaseOrderNumber = po.PurchaseOrderNumber;
existingPO.QRCodeId = po.QRCodeId;
existingPO.VendorId = (po.VendorId == 0 ? null : (int?)po.VendorId);
existingPO.QRCodeShortURL = po.QRCodeShortURL;
}
else
{
ctx.PurchaseOrders.AddObject(dbPO);
}
ctx.SaveChanges();
return Mapper.Map(dbPO);
}
