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");
}
public static List <String> process(int id, Store_Request Request)
{
string rt = "";
List <string> status = new List <string>();
var relist = model.Store_Request_items.Where(x => x.StoreRequest_ID == id && x.Status == "Pending").ToList();
foreach (var v in relist)
{
var itemID = v.Item_Number;
var trslist = model.Wrehse_Trans_Dtl.Where(x => x.Available_Qunty != 0 && x.Available_Qunty > 0 && x.Item_number == itemID).FirstOrDefault();
if (trslist.Available_Qunty != 0)
{
if (trslist.Available_Qunty >= v.Pend_Quantity)
{
if (v.Delv_Quantity == null)
{
int? Req_quty = v.Pend_Quantity; //for dupliacte table
int? deliver_quantity = v.Req_Quantity; //for duplicate table
DateTime date = DateTime.Now; //for dupilcate table
string depart_id = Request.Department_ID; //for duplicate table
trslist.Available_Qunty = trslist.Available_Qunty - v.Req_Quantity;
v.Delv_Quantity = v.Req_Quantity;
v.Pend_Quantity = 0;
v.Status = "Done";
model.SaveChanges();
status.Add("Done");
Request_completed Completed = new Request_completed();
Completed.Department_ID = depart_id;
Completed.Item_Number = v.Item_Number;
Completed.Req_quantity = Req_quty;
Completed.Delivered_quantity = deliver_quantity;
Completed.Date = date;
Completed.StoreRequest_ID = v.StoreRequest_ID;
model.Request_completed.Add(Completed);
model.SaveChanges();
}
else
{
int? Req_quty = v.Pend_Quantity; //for dupliacte table
int? deliver_quantity = v.Pend_Quantity; //for duplicate table
DateTime date = DateTime.Now; //for dupilcate table
string depart_id = Request.Department_ID; //for duplicate table
trslist.Available_Qunty = trslist.Available_Qunty - v.Pend_Quantity;
v.Delv_Quantity = v.Delv_Quantity + v.Pend_Quantity;
v.Pend_Quantity = 0;
v.Status = "Done";
model.SaveChanges();
status.Add("Done");
Request_completed Completed = new Request_completed();
Completed.Department_ID = depart_id;
Completed.Item_Number = v.Item_Number;
Completed.Req_quantity = Req_quty;
Completed.Delivered_quantity = deliver_quantity;
Completed.Date = date;
Completed.StoreRequest_ID = v.StoreRequest_ID;
model.Request_completed.Add(Completed);
model.SaveChanges();
}
}
else
{
if (v.Delv_Quantity == null)
{
int bal = (int)(v.Req_Quantity - trslist.Available_Qunty);
int? deliver_quantity = trslist.Available_Qunty; // for duplicate table
int? Req_quty = v.Pend_Quantity; //for dupliacte table
DateTime date = DateTime.Now; //for dupilcate table
string depart_id = Request.Department_ID; //for duplicate table
trslist.Available_Qunty = 0;
v.Pend_Quantity = bal;
v.Delv_Quantity = v.Req_Quantity - bal;
model.SaveChanges();
status.Add("Pending");
Request_completed Completed = new Request_completed();
Completed.Department_ID = depart_id;
Completed.Item_Number = v.Item_Number;
Completed.Req_quantity = Req_quty;
Completed.Delivered_quantity = deliver_quantity;
Completed.Date = date;
Completed.StoreRequest_ID = v.StoreRequest_ID;
model.Request_completed.Add(Completed);
model.SaveChanges();
}
}
}
else
{
rt = "Available Qunty no more";
}
}
return(status);
}
