public void AddSku(OrpSku newOrpSku)
{
if (newOrpSku != null)
{
_localRepo.Add(newOrpSku);
}
}
public void UpdateSku(string orpSkuName, OrpSku updatedOrpSku)
{
var skuToUpdate = _localRepo.Where(x => x.OrpSkuName.Equals(orpSkuName)).FirstOrDefault();
skuToUpdate.OrpSkuId = updatedOrpSku.OrpSkuId;
skuToUpdate.OrpSkuName = updatedOrpSku.OrpSkuName;
skuToUpdate.OrpSkuDescription = updatedOrpSku.OrpSkuDescription;
skuToUpdate.InUse = updatedOrpSku.InUse;
skuToUpdate.Product = updatedOrpSku.Product;
skuToUpdate.Term = updatedOrpSku.Term;
skuToUpdate.SkuPrice = updatedOrpSku.SkuPrice;
skuToUpdate.MsrpPrice = updatedOrpSku.MsrpPrice;
skuToUpdate.MfnFloorPrice = updatedOrpSku.MfnFloorPrice;
}
public OrpSku GetSkuByName(string orpSkuName)
{
OrpSku orpSku = null;
using (var ctx = new SkuInventoryEntities())
{
var foundSku = getSkuInventoryRecord(ctx, orpSkuName);
if (foundSku != null)
{
orpSku = getOrpSkuFromSkuInventory(foundSku);
}
}
return(orpSku);
}
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 UpdateSku(string orpSkuName, OrpSku updatedOrpSku)
{
using (var ctx = new SkuInventoryEntities())
{
var foundSku = getSkuInventoryRecord(ctx, orpSkuName);
if (foundSku == null)
{
return;
}
foundSku.ID = updatedOrpSku.OrpSkuId;
foundSku.Item_Description = updatedOrpSku.OrpSkuDescription;
foundSku.Item_Number = updatedOrpSku.OrpSkuName;
foundSku.InUse = updatedOrpSku.InUse.ToString();
foundSku.Term = updatedOrpSku.Term;
foundSku.Product = updatedOrpSku.Product;
foundSku.SkuPrice = (decimal?)updatedOrpSku.SkuPrice;
foundSku.MsrpPrice = (decimal?)updatedOrpSku.MsrpPrice;
foundSku.Comment = updatedOrpSku.Comment;
ctx.SaveChanges();
}
}
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();
}
}
public void OnOrpSkuReceived(OrpSku receivedOrpSku)
{
SelectedOrpSku = receivedOrpSku;
}
public void UpdateSku(string orpSkuName, OrpSku updatedOrpSku)
{
_repo.UpdateSku(orpSkuName, updatedOrpSku);
}
public void AddSku(OrpSku newOrpSku)
{
_repo.AddSku(newOrpSku);
}
