public static string Update(int ID, int ProductID, string ParentSKU, string SKU, double Stock, int StockStatus, double Regular_Price, double CostOfGood,
double RetailPrice, string Image, bool ManageStock, bool IsHidden, DateTime ModifiedDate, string ModifiedBy, int SupplierID, string SupplierName,
double MinimumInventoryLevel, double MaximumInventoryLevel)
{
using (var dbe = new inventorymanagementEntities())
{
tbl_ProductVariable ui = dbe.tbl_ProductVariable.Where(a => a.ID == ID).SingleOrDefault();
if (ui != null)
{
ui.ProductID = ProductID;
ui.ParentSKU = ParentSKU;
ui.SKU = SKU;
ui.Stock = Stock;
ui.StockStatus = StockStatus;
ui.Regular_Price = Regular_Price;
ui.CostOfGood = CostOfGood;
ui.RetailPrice = RetailPrice;
ui.Image = Image;
ui.ManageStock = ManageStock;
ui.IsHidden = IsHidden;
ui.ModifiedBy = ModifiedBy;
ui.ModifiedDate = ModifiedDate;
ui.SupplierID = SupplierID;
ui.SupplierName = SupplierName;
ui.MinimumInventoryLevel = MinimumInventoryLevel;
ui.MaximumInventoryLevel = MaximumInventoryLevel;
int kq = dbe.SaveChanges();
return(ui.ID.ToString());
}
else
{
return(null);
}
}
}
public static string Insert(int ProductID, string ParentSKU, string SKU, double Stock, int StockStatus, double Regular_Price, double CostOfGood,
double RetailPrice, string Image, bool ManageStock, bool IsHidden, DateTime CreatedDate, string CreatedBy, int SupplierID, string SupplierName,
double MinimumInventoryLevel, double MaximumInventoryLevel)
{
using (var dbe = new inventorymanagementEntities())
{
tbl_ProductVariable ui = new tbl_ProductVariable();
ui.ProductID = ProductID;
ui.ParentSKU = ParentSKU;
ui.SKU = SKU;
ui.Stock = Stock;
ui.StockStatus = StockStatus;
ui.Regular_Price = Regular_Price;
ui.CostOfGood = CostOfGood;
ui.RetailPrice = RetailPrice;
ui.Image = Image;
ui.ManageStock = ManageStock;
ui.IsHidden = IsHidden;
ui.CreatedDate = CreatedDate;
ui.CreatedBy = CreatedBy;
ui.SupplierID = SupplierID;
ui.SupplierName = SupplierName;
ui.MinimumInventoryLevel = MinimumInventoryLevel;
ui.MaximumInventoryLevel = MaximumInventoryLevel;
dbe.tbl_ProductVariable.Add(ui);
dbe.SaveChanges();
int kq = ui.ID;
return(kq.ToString());
}
}
public static tbl_ProductVariable GetBySKU(string SKU)
{
using (var dbe = new inventorymanagementEntities())
{
tbl_ProductVariable ai = dbe.tbl_ProductVariable.Where(a => a.SKU == SKU).SingleOrDefault();
if (ai != null)
{
return(ai);
}
else
{
return(null);
}
}
}
public static string UpdateProductID(int ID, int ProductID)
{
using (var dbe = new inventorymanagementEntities())
{
tbl_ProductVariable ui = dbe.tbl_ProductVariable.Where(a => a.ID == ID).SingleOrDefault();
if (ui != null)
{
ui.ProductID = ProductID;
int kq = dbe.SaveChanges();
return(kq.ToString());
}
else
{
return(null);
}
}
}
public static string UpdateColorSize(int ID, string color, string size)
{
using (var dbe = new inventorymanagementEntities())
{
tbl_ProductVariable ui = dbe.tbl_ProductVariable.Where(a => a.ID == ID).SingleOrDefault();
if (ui != null)
{
ui.color = color;
ui.size = size;
int kq = dbe.SaveChanges();
return(kq.ToString());
}
else
{
return(null);
}
}
}
public static string UpdateStockStatus(int ID, int StockStatus, bool IsHidden, DateTime ModifiedDate, string ModifiedBy)
{
using (var dbe = new inventorymanagementEntities())
{
tbl_ProductVariable ui = dbe.tbl_ProductVariable.Where(a => a.ID == ID).SingleOrDefault();
if (ui != null)
{
ui.StockStatus = StockStatus;
ui.IsHidden = IsHidden;
ui.ModifiedBy = ModifiedBy;
ui.ModifiedDate = ModifiedDate;
int kq = dbe.SaveChanges();
return(kq.ToString());
}
else
{
return(null);
}
}
}
