public void DeleteRequisitionDetail(StaffRequisition requisition) { StaffRequisition oldRequisition = context.StaffRequisitions.Where(x => x.StaffRequisitionId == requisition.StaffRequisitionId).FirstOrDefault(); context.StaffRequisitions.Remove(oldRequisition); context.SaveChanges(); }
public List <RequisitionDetail> GetRequisitionDetails(string requisitionId) { StaffRequisition requisition = context.StaffRequisitions.Where(x => x.StaffRequisitionId == requisitionId && x.Status == "Pending" || x.Status == "Reject").FirstOrDefault(); List <RequisitionDetail> requisitionDetailList = requisition.RequisitionDetails.ToList <RequisitionDetail>(); return(requisitionDetailList); }
protected void btnSubmit_Click(object sender, EventArgs e) { StaffRequisition requisition = new StaffRequisition(); List <RequisitionDetail> requisitiondetails = new List <RequisitionDetail>(); requisition.StaffRequisitionId = lblRequisition.Text; requisition.DepartmentId = user.DepartmentId; requisition.StaffId = user.StaffId; requisition.CreateDate = Convert.ToDateTime(lblDate.Text); requisition.Status = "Pending"; foreach (GridViewRow row in gv_Items.Rows) { RequisitionDetail details = new RequisitionDetail(); details.StaffReqisitionId = lblRequisition.Text; details.ItemId = gv_Items.DataKeys[row.RowIndex].Value.ToString(); details.Quantity = Convert.ToInt32(row.Cells[3].Text); requisitiondetails.Add(details); } viewStationeryRequisitionController.saveDataToRequisition(requisition, requisitiondetails); dt = null; gv_Items.DataSource = dt; gv_Items.DataBind(); btnSubmit.CssClass = "btn btn-success disabled"; btnSubmit.Attributes.Add("disabled", "disabled"); btnSubmit.Text = "Sent"; txtQuantity.Text = ""; lblUOM.Text = ""; BindDropDownList(); SendMailToDepartmentHead(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Submit successfully') ;window.location = '" + "ViewStationaryRequisitionList.aspx';", true); }
public void RejectRequisitionList(string staffReqId, string remark) { StaffRequisition staffRequisition = context.StaffRequisitions.Where(x => x.StaffRequisitionId.Equals(staffReqId)).FirstOrDefault(); staffRequisition.Status = StatusType.Reject.ToString(); staffRequisition.Remark = remark; context.SaveChanges(); }
public void ApproveRequisitionList(string staffReqId, List <RequisitionDetail> requisitionDetailList, string remark, string staffId) { StaffRequisition staffRequisition = context.StaffRequisitions.Where(x => x.StaffRequisitionId.Equals(staffReqId)).FirstOrDefault(); string depReqId = GenerateDepartmentRequisitionId(staffRequisition.DepartmentId); if (staffRequisition != null) { staffRequisition.DepartmentRequisitionId = depReqId; staffRequisition.Status = StatusType.Approved.ToString(); staffRequisition.ApproveBy = staffId; staffRequisition.ApproveDate = Convert.ToDateTime(DateTime.Now.ToString()); staffRequisition.Remark = remark; context.SaveChanges(); } foreach (RequisitionDetail req in requisitionDetailList) { DepartmentRequisition depRequisition = context.DepartmentRequisitions.Where(x => x.DepartmentId.Equals(staffRequisition.DepartmentId) && x.ItemId.Equals(req.ItemId) && x.Status.Equals(StatusType.Pending.ToString())).FirstOrDefault(); if (depRequisition != null) { depRequisition.Needed += req.Quantity; context.SaveChanges(); } else { DepartmentRequisition departmentReq = new DepartmentRequisition(); departmentReq.DepartmentRequisitionId = depReqId; departmentReq.DepartmentId = staffRequisition.DepartmentId; departmentReq.ItemId = req.ItemId; departmentReq.Needed = req.Quantity; departmentReq.Actual = 0; departmentReq.Status = StatusType.Approved.ToString(); departmentReq.Remark = remark; departmentReq.CreateDate = DateTime.Now; context.DepartmentRequisitions.Add(departmentReq); context.SaveChanges(); } } }
public void saveDataToRequisition(StaffRequisition requisition, List <RequisitionDetail> requisitiondetails) { context.StaffRequisitions.Add(requisition); context.SaveChanges(); foreach (RequisitionDetail req in requisitiondetails) { RequisitionDetail reqDetail = context.RequisitionDetails.Where(x => x.StaffReqisitionId.Equals(req.StaffReqisitionId) && x.ItemId.Equals(req.ItemId)).FirstOrDefault(); if (reqDetail != null) { reqDetail.Quantity += req.Quantity; context.SaveChanges(); } else { RequisitionDetail d = new RequisitionDetail(); d.StaffReqisitionId = req.StaffReqisitionId; d.ItemId = req.ItemId; d.Quantity = req.Quantity; context.RequisitionDetails.Add(d); context.SaveChanges(); } } }
public void RemoveRequisitionDetail(StaffRequisition requisition) { viewStationaryRequisitionDAOImpl.DeleteRequisitionDetail(requisition); }
public void saveDataToRequisition(StaffRequisition requisition, List <RequisitionDetail> requisitiondetails) { viewStationaryRequisitionDAOImpl.saveDataToRequisition(requisition, requisitiondetails); }