public static ReturnType UpdateStockItem(string stockitemCode, View_StockItemUnit stockitem)
{
return(DataProviderClass.Instance().UpdateStockItem(stockitemCode, stockitem));
}
public ReturnType UpdateStockItem(string stockitemCode, View_StockItemUnit stockitem)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*var result = alading.StockItem.Where(p => p.StockItemID == stockitemID).ToList();*/
var result = alading.StockItem.Where(p => p.StockItemCode == stockitemCode).ToList();
if (result.Count == 0)
{
return(ReturnType.NotExisted);
}
StockItem ob = result.First();
ob.OuterID = stockitem.OuterID;
ob.UnitCode = stockitem.UnitCode;
ob.Specification = stockitem.Specification;
ob.Model = stockitem.Model;
ob.TaxName = stockitem.TaxName;
ob.Tax = stockitem.Tax;
ob.ProductID = stockitem.ProductID;
ob.Name = stockitem.Name;
ob.SimpleName = stockitem.SimpleName;
ob.Cid = stockitem.Cid;
ob.CatName = stockitem.CatName;
ob.StockCid = stockitem.StockCid;
ob.StockCatName = stockitem.StockCatName;
ob.StockProps = stockitem.StockProps;
ob.KeyProps = stockitem.KeyProps;
ob.NotKeyProps = stockitem.NotKeyProps;
ob.SaleProps = stockitem.SaleProps;
ob.HasSaleProps = stockitem.HasSaleProps;
ob.StockProps = stockitem.StockProps;
ob.InputPids = stockitem.InputPids;
ob.InputStr = stockitem.InputStr;
ob.PicUrl = stockitem.PicUrl;
ob.StockItemImgs = stockitem.StockItemImgs;
ob.TotalQuantity = stockitem.TotalQuantity;
ob.IsConsignment = stockitem.IsConsignment;
ob.StockCheckUrl = stockitem.StockCheckUrl;
ob.Created = stockitem.Created;
ob.Modified = stockitem.Modified;
ob.StockItemRemark = stockitem.StockItemRemark;
ob.StockItemType = stockitem.StockItemType;
ob.Props = stockitem.Props;
ob.Property_Alias = stockitem.Property_Alias;
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.OthersError);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
