public void updateRetrivalStatus(string depId, string itemNumber, int retrieved, List <string> reqIdLst1) //To update retrieval status and qty
{
List <string> reqIdLst = rda.getRequisitionIdByDepAndItem(depId, itemNumber);
foreach (string s in reqIdLst)
{
bool alreadyExist = reqIdLst1.Contains(s);
if (alreadyExist)
{
DisbursementBO dbo = new DisbursementBO();
string disId = generateDisbursementId();
dbo.DisbursementId = disId;
dbo.DepartmentId = depId;
dbo.ItemNumber = itemNumber;
dbo.RequisitionId = s;
dbo.Status = "Ready for collection";
dbo.OrderQuantity = rda.getOrderQuantityByReqIdAndItemNumber(s, itemNumber);
List <ReqIdAndQtyBO> rqLst = distributeQtyToReq(depId, itemNumber, retrieved, reqIdLst1); //3rd feb
foreach (ReqIdAndQtyBO r in rqLst)
{
if (r.ReqId == s)
{
dbo.DisbursementQuantity = r.DisbursedQty;
}
}
Disbursement d = dbConversion.convertDBoToD(dbo);
rda.createNewDisbursement(d);
rda.updateReqStatus(s);
}
}
}
public DisbursementBO convertDisbursementBO(Disbursement e)
{
dbo = new DisbursementBO();
dbo.DepartmentId = e.DepartmentID;
dbo.DisbursementId = e.DisbursementID;
dbo.ItemNumber = e.ItemNumber;
dbo.OrderQuantity = e.OrderQuantity;
dbo.DisbursementQuantity = e.DisbursementQuantity;
dbo.Status = e.Status;
dbo.RequisitionId = e.RequisitionID;
return(dbo);
}
public DisbursementBO convertDisbursement(Disbursement d)
{
dbbo = new DisbursementBO();
dbbo.DisbursementId = d.DisbursementID;
dbbo.DepartmentId = d.DepartmentID;
dbbo.Department = getDeptByDeptId(dbbo.DepartmentId);
dbbo.DisbursementQuantity = d.DisbursementQuantity;
dbbo.ItemNumber = d.ItemNumber;
dbbo.OrderQuantity = d.OrderQuantity;
dbbo.RequisitionId = d.RequisitionID;
dbbo.Status = d.Status;
return(dbbo);
}
public Disbursement convertDBoToD(DisbursementBO dbo)
{
Disbursement d = new Disbursement();
d.DepartmentID = dbo.DepartmentId;
d.DisbursementID = dbo.DisbursementId;
d.DisbursementQuantity = dbo.DisbursementQuantity;
d.ItemNumber = dbo.ItemNumber;
d.OrderQuantity = dbo.OrderQuantity;
d.RequisitionID = dbo.RequisitionId;
d.Status = dbo.Status;
return(d);
}
public List <DisbursementBO> getDisbursementItems(int departmentID)
{
List <DisbursementBO> lst = new List <DisbursementBO>();
var qry = (from dis in context.Disbursements
join disItem in context.Disbursement_Item on dis.DisbursementID equals disItem.DisbursementID
join i in context.Items on disItem.ItemID equals i.ItemID
where dis.DepartmentID == departmentID && disItem.Status == "Pending"
select new
{
disItem.Disbursement_ItemID,
disItem.DisbursementID,
i.Description,
disItem.Qty,
disItem.Status,
dis.CollectionDate,
i.ItemNumber,
i.UnitOfMeasure,
disItem.ItemID
}
).ToList();
foreach (var q in qry)
{
DisbursementBO di = new DisbursementBO();
di.DisbursementItemID = q.Disbursement_ItemID;
di.DisbursementID = (int)q.DisbursementID;
di.ItemDescription = q.Description;
di.Qty = (int)q.Qty;
di.CollectionDate = (DateTime)q.CollectionDate;
di.Status = q.Status;
di.ItemNumber = q.ItemNumber;
di.Uom = q.UnitOfMeasure;
di.ItemID = q.ItemID;
lst.Add(di);
}
return(lst);
}
