protected void btnReGenReq_Click(object sender, EventArgs e) { DateTime date = (DateTime)Session["RegenerateDate"]; string depName = (string)Session["RegenerateDep"];; string requestedBy = (string)Session["RequestedBy"]; int empID = EFBroker_DeptEmployee.GetDeptRepEmpIDByDeptCode(depName); string depCode = EFBroker_DeptEmployee.GetDepartByEmpID(empID).DeptCode; List <RequestedItem> shortfallItem = (List <RequestedItem>)Session["RegenerateItems"]; List <RequestedItem> regenerateItem = new List <RequestedItem>(); foreach (GridViewRow r in gvRegenerate.Rows) { if (((CheckBox)r.FindControl("CheckBox")).Checked) { int i = r.RowIndex; regenerateItem.Add(shortfallItem[i]); } } RequisitionControl.addNewRequisitionItem(regenerateItem, date, status, empID, depCode); RedirectCheck(); }
public static List <ReqisitionListItem> PopulateGridView(List <Requisition> rlist) { itemList = new List <ReqisitionListItem>(); foreach (Requisition r in rlist) { date = r.RequestDate.Value.ToLongDateString(); requisitionNo = Convert.ToInt32(r.RequisitionID.ToString()); status = r.Status.ToString(); requestedBy = Convert.ToInt32(r.RequestedBy.ToString()); Department dep = EFBroker_DeptEmployee.GetDepartByEmpID(requestedBy); depCode = dep.DeptCode; department = dep.DeptName; item = new ReqisitionListItem(date, requisitionNo, department, status, requestedBy.ToString()); itemList.Add(item); } return(itemList); }
public void RegenerateRequisition(List <WCFRequestedItem> regenList) { int disbId = 0; List <RequestedItem> requItemList = new List <RequestedItem>(); foreach (WCFRequestedItem r in regenList) { RequestedItem rItem = new RequestedItem(r.Code, r.Description, Convert.ToInt32(r.ShortfallQty), RequisitionControl.getUOM(r.Code)); disbId = r.DisbId; requItemList.Add(rItem); } DateTime date = (disbCon.GetRegenrateDate(disbId)); string depName = EFBroker_Disbursement.GetDisbursmentbyDisbID(Convert.ToInt32(disbId)).Department.DeptName; string reqBy = EFBroker_DeptEmployee.GetDeptRepByDeptCode(depName); int empID = EFBroker_DeptEmployee.GetDeptRepEmpIDByDeptCode(depName); string depCode = EFBroker_DeptEmployee.GetDepartByEmpID(empID).DeptCode; string status = "Priority"; RequisitionControl.addNewRequisitionItem(requItemList, date, status, empID, depCode); }
// public void AddDisbursement(int requisitionId, List <int> requisitionNo) { List <int> disbursementIDList = new List <int>(); Disbursement d = new Disbursement(); List <int> requestedByList = new List <int>(); //EmpID List <string> departmentCodeList = new List <string>(); foreach (int i in requisitionNo) { requestedByList.Add((int)(EFBroker_Requisition.GetRequisitionByID(i).RequestedBy)); } //foreach requestedByList get depcode foreach (int i in requestedByList) { string departmentCode = EFBroker_DeptEmployee.GetDepartByEmpID(i).DeptCode.ToString(); if (departmentCodeList.Count() != 0) { bool add = true; foreach (string s in departmentCodeList) { if (s == departmentCode) { add = false; } } if (add) { departmentCodeList.Add(departmentCode); } } else { departmentCodeList.Add(departmentCode); } } //foreach depcode add disbursement + disbDetail foreach (string i in departmentCodeList) { //add Disbursement d.RetrievalID = requisitionId; d.DeptCode = i; d.Status = "Pending"; int disbursementId = EFBroker_Disbursement.AddNewDisbursment(d); disbursementIDList.Add(disbursementId);//auto increasement disbursementIDList after SaveChanges } foreach (int i in disbursementIDList) { string departmentCode = EFBroker_Disbursement.GetDisbursmentbyDisbID(i).DeptCode; foreach (int no in requisitionNo) { //update requisition table Requisition r = new Requisition(); r = EFBroker_Requisition.GetRequisitionByID(no); string dep = EFBroker_DeptEmployee.GetDepartByEmpID(r.RequestedBy ?? 0).DeptCode;//if null, ==0 if (dep == departmentCode) { r.Status = "InProgress";///////////////////////////////////////////// r.DisbursementID = i; EFBroker_Requisition.UpdateRequisition(r); } } AddDisbursemen_Item(i); } }