public void bundleSelectedRequisition(List<Requisition> lstReqNo, string reqFrmNo, string empID, string deptID, List<Requisition> lstRej)
{
var q = from lr in lstReqNo
join rd in ContextDB.Requisition_Detail on lr.Req_Form_No equals rd.Req_Form_No
join s in ContextDB.Stationary_Catalogue on rd.Item_Code equals s.Item_Code
group rd by new { rd.Item_Code, s.Description } into g
select new Requisition_Detail
{
//Req_Form_No = g.Key.Req_Form_No,
Item_Code = g.Key.Item_Code,
Description = g.Key.Description,
Qty = g.Sum(rd => rd.Qty)
};
RequisitionEnt reqE = new RequisitionEnt();
Requisition req = new Requisition();
req.Req_Form_No = reqFrmNo;
req.Emp_ID = empID;
req.Approval_Status = 3;
req.Approval_Date = DateTime.Now;
req.Approval_By = null;
req.Req_Status = false;
req.Notification = false;
req.Prior = false;
reqE.createRequisition(req);
foreach (var val in q)
{
Requisition_Detail rd = new Requisition_Detail();
rd.Req_Form_No = reqFrmNo;
rd.Item_Code = val.Item_Code;
rd.Description = val.Description;
rd.Qty = val.Qty;
RequisitionDetailEnt rdE = new RequisitionDetailEnt();
rdE.createReqDetail(rd);
}
foreach (var val in lstReqNo)
{
Requisition reqt = (Requisition)val;
reqt.Approval_Status = 2;
updateRequisition(reqt);
}
foreach (var val in lstRej)
{
Requisition reqt = (Requisition)val;
reqt.Approval_Status = 0;
updateRequisition(reqt);
}
}
public void submitRequisition(Requisition req)
{
RequisitionEnt reqEnt = new RequisitionEnt();
reqEnt.createRequisition(req);
}