private void UpdateCatalogInventory(ICatalogInventory inv)
{
inv.UpdateDate = DateTime.Now;
var dto = new CatalogInventoryDto()
{
CatalogKey = inv.CatalogKey,
ProductVariantKey = inv.ProductVariantKey,
Count = inv.Count,
LowCount = inv.LowCount,
CreateDate = inv.CreateDate,
UpdateDate = inv.UpdateDate
};
//Database.Update(dto);
Database.Execute(
"UPDATE merchCatalogInventory SET Count = @invCount, LowCount = @invLowCount, UpdateDate = @invUpdateDate WHERE catalogKey = @catalogKey AND productVariantKey = @productVariantKey",
new
{
invCount = inv.Count,
invLowCount = inv.LowCount,
invUpdateDate = inv.UpdateDate,
catalogKey = inv.CatalogKey,
productVariantKey = inv.ProductVariantKey
});
}
private void AddCatalogInventory(ICatalogInventory inv)
{
inv.CreateDate = DateTime.Now;
inv.UpdateDate = DateTime.Now;
var dto = new CatalogInventoryDto()
{
CatalogKey = inv.CatalogKey,
ProductVariantKey = inv.ProductVariantKey,
Count = inv.Count,
LowCount = inv.LowCount,
CreateDate = inv.CreateDate,
UpdateDate = inv.UpdateDate
};
Database.Insert(dto);
}