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();
}
}
