private void DeleteSalesOrderDetails(int id)
{
TimelyDepotContext db01 = new TimelyDepotContext();
//SalesOrderDetail salesorderdetails = null;
IQueryable <SalesOrderDetail> qryalesorderdetails = db.SalesOrderDetails.Where(sodt => sodt.SalesOrderId == id);
if (qryalesorderdetails.Count() > 0)
{
foreach (var item in qryalesorderdetails)
{
db.SalesOrderDetails.Remove(item);
}
db01.SaveChanges();
}
}
private void UpdateInventory(string[] szHeaders, string[] szRow, TimelyDepotContext db, ITEM item, int nPos, ref string szError)
{
//Asume
// 0 = ItemId
// 1 = PROD_CD
// 2 = UnitperCase
// 3 = CaseWeight
// 4 = UnitWeight
// 5 = CaseDimensionL
// 6 = CaseDimensionW
// 7 = CaseDimensionH
string szItemId = "";
szError = "";
try
{
szItemId = szRow[0];
item = db.ITEMs.Where(itm => itm.ItemID == szItemId).FirstOrDefault <ITEM>();
if (item != null)
{
item.UnitPerCase = szRow[2];
item.CaseWeight = szRow[3];
item.UnitWeight = szRow[4];
item.CaseDimensionL = szRow[5];
item.CaseDimensionW = szRow[6];
item.CaseDimensionH = szRow[7];
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception err)
{
szError = string.Format("Row {0}: {1} {2}", nPos, err.Message, err.StackTrace);
}
}
