public static string Warelist(List <ClerkViewRequest> updatelist, Employee user)
{
try
{
Wrehse_Trans trans = new Wrehse_Trans();
trans.Employee_ID = user.Employee_ID;
trans.Trans_Date = DateTime.Now;
model.Wrehse_Trans.Add(trans);
model.SaveChanges();
Wrehse_Trans last = model.Wrehse_Trans.OrderByDescending(x => x.Trans_ID).Take(1).FirstOrDefault();
foreach (var v in updatelist)
{
Wrehse_Trans_Dtl trans_Dtl = new Wrehse_Trans_Dtl();
trans_Dtl.Trans_ID = last.Trans_ID;
trans_Dtl.Item_number = v.itemnumber;
trans_Dtl.Retrived_Qunty = v.CollectedQuntity;
trans_Dtl.Available_Qunty = v.CollectedQuntity;
model.Wrehse_Trans_Dtl.Add(trans_Dtl);
var inventoriesChange = model.Inventories.Where(x => x.Item_Number.Equals(v.itemnumber)).FirstOrDefault();
inventoriesChange.Quantity -= v.CollectedQuntity;
model.SaveChanges();
if (v.DamagedQuantity > 0)
{
Dmg_Goods_Dtl d = new Dmg_Goods_Dtl();
d.Item_number = v.itemnumber;
d.Damage_Qnty = v.DamagedQuantity;
d.Location = "warehouse";
d.Details = "Damage";
d.Employee_ID = user.Employee_ID;
d.Dmg_Date = System.DateTime.Today;
inventoriesChange.Quantity -= v.DamagedQuantity;
model.Dmg_Goods_Dtl.Add(d);
model.SaveChanges();
}
}
return("UPDATE SUCCESS AND get all item fro store and down from inventory and add damage if ");
}
catch (Exception)
{
return("ERROR IN UPDATING WAREHOUSE");
}
}
public static void recordDamageDetails(String Itemnumber, int Quantity, String Location)
{
Dmg_Goods_Dtl dmg = new Dmg_Goods_Dtl();
dmg.Item_number = Itemnumber;
dmg.Damage_Qnty = Quantity;
dmg.Location = Location;
dmg.Employee_ID = "ENG002";
dmg.Details = " ";
dmg.Dmg_Date = System.DateTime.Now;
model.Dmg_Goods_Dtl.Add(dmg);
model.SaveChanges();
}
public string rollbackrequest(string itemnumber, string departid, int qunty)
{
using (model)
{
Employee user = (Employee)Session["user"];
Dmg_Goods_Dtl dmg_Goods = new Dmg_Goods_Dtl();
dmg_Goods.Item_number = itemnumber;
dmg_Goods.Damage_Qnty = qunty;
dmg_Goods.Location = departid;
dmg_Goods.Dmg_Date = DateTime.Now;
dmg_Goods.Employee_ID = user.Employee_ID;
dmg_Goods.Details = "Pending";
model.Dmg_Goods_Dtl.Add(dmg_Goods);
model.SaveChanges();
}
return(null);
}
