public void insertrequesttostore(string deptid, string empid, DateTime date, List <HodReqItem> reqItems) //,date
{
Store_Request sr = new Store_Request()
{
Department_ID = deptid,
Employee_ID = empid,
Request_Date = date,
Status = "Pending"
};
model.Store_Request.Add(sr);
model.SaveChanges();
Store_Request storeid = model.Store_Request.OrderByDescending(x => x.StoreRequest_ID).Take(1).FirstOrDefault();
foreach (var v in reqItems)
{
Store_Request_items store_Request = new Store_Request_items();
store_Request.StoreRequest_ID = storeid.StoreRequest_ID;
store_Request.Item_Number = v.Itemnumber;
store_Request.Description = v.description;
store_Request.Req_Quantity = Convert.ToInt32(v.Quantity);
store_Request.Pend_Quantity = Convert.ToInt32(v.Quantity);
store_Request.Status = "Pending";
model.Store_Request_items.Add(store_Request);
model.SaveChanges();
}
}
public void insertrequesttostore(string deptid, string empid, DateTime date, List <HodReqItem> reqItems) //,date
{
Store_Request sr = new Store_Request()
{
Department_ID = deptid,
Employee_ID = empid,
Request_Date = date,
Status = "Pending"
};
model.Store_Request.Add(sr);
model.SaveChanges();
Store_Request storeid = model.Store_Request.OrderByDescending(x => x.StoreRequest_ID).Take(1).FirstOrDefault();
foreach (var v in reqItems)
{
// var xy = (from z in model.Inventories where z.Description == v.Description select z.Item_Number).SingleOrDefault();
Store_Request_items store_Request = new Store_Request_items();
store_Request.StoreRequest_ID = storeid.StoreRequest_ID;
store_Request.Item_Number = v.Itemnumber;
store_Request.Description = v.description;
store_Request.Req_Quantity = Convert.ToInt32(v.Quantity);
store_Request.Pend_Quantity = Convert.ToInt32(v.Quantity);
store_Request.Status = "Pending";
model.Store_Request_items.Add(store_Request);
model.SaveChanges();
}
// Response.Write("request approve and send to store request");
}
