public List<QuickReceipt.Models.PurchaseOrder> List(int numToList)
{
QuickReceiptEntities ctx = new QuickReceiptEntities();
var orders = (from p in ctx.PurchaseOrders
where p.PurchaseOrderNumber.HasValue
select p).Take(numToList).ToList();
return Mapper.Map(orders);
}
public int GetUnusedQRCodeCount()
{
QuickReceiptEntities ctx = new QuickReceiptEntities();
var count = (from p in ctx.PurchaseOrders
where p.PurchaseOrderNumber == null && p.QRCodeShortURL != null
select p.QRCodeShortURL).Count();
return count;
}
public QuickReceipt.Models.PurchaseOrder Find(int poId)
{
QuickReceiptEntities ctx = new QuickReceiptEntities();
var dbPO = (from p in ctx.PurchaseOrders
where p.POId == poId
select p).FirstOrDefault();
if (dbPO == null)
return null;
return Mapper.Map(dbPO);
}
public QuickReceipt.Models.PurchaseOrder Find(string qrCode)
{
QuickReceiptEntities ctx = new QuickReceiptEntities();
var dbPO = (from p in ctx.PurchaseOrders
where p.QRCodeId == qrCode
select p).FirstOrDefault();
if (dbPO == null)
return null;
return Mapper.Map(dbPO);
}
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 List<string> ListUnusedQRUrls(int numToList)
{
QuickReceiptEntities ctx = new QuickReceiptEntities();
var urls = (from p in ctx.PurchaseOrders
where p.PurchaseOrderNumber == null && p.QRCodeShortURL != null
select p.QRCodeShortURL).Take(numToList).ToList();
return urls;
}
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);
}
