private SkuInventoryDb getSkuInventoryRecord(SkuInventoryEntities ctx, string orpSkuName) { SkuInventoryDb foundSku = null; foundSku = (from s in ctx.SkuInventoryDbs where s.Item_Number.Equals(orpSkuName) select s).FirstOrDefault(); return(foundSku); }
private OrpSku getOrpSkuFromSkuInventory(SkuInventoryDb skuInventory) { var orpSku = new OrpSku() { OrpSkuId = skuInventory.ID, OrpSkuName = skuInventory.Item_Number, OrpSkuDescription = skuInventory.Item_Description, Comment = skuInventory.Comment, InUse = skuInventory.InUse, Term = skuInventory.Term.Value, Product = skuInventory.Product, SkuPrice = skuInventory.SkuPrice, MsrpPrice = skuInventory.MsrpPrice }; return(orpSku); }
public void AddSku(OrpSku newOrpSku) { using (var ctx = new SkuInventoryEntities()) { if (getSkuInventoryRecord(ctx, newOrpSku.OrpSkuName) != null) { return; } var orpSku = new SkuInventoryDb() { ID = newOrpSku.OrpSkuId, Item_Description = newOrpSku.OrpSkuDescription, Item_Number = newOrpSku.OrpSkuName, InUse = newOrpSku.InUse.ToString(), Term = newOrpSku.Term, Product = newOrpSku.Product, SkuPrice = (decimal?)newOrpSku.SkuPrice, MsrpPrice = (decimal?)newOrpSku.MsrpPrice, }; ctx.SkuInventoryDbs.Add(orpSku); ctx.SaveChanges(); } }