protected void Page_Load(object sender, EventArgs e) { if (HttpContext.Current.User.IsInRole("Department Employee") != true) { Response.Redirect("/Presentation/Login.aspx"); } if (!IsPostBack) { int id; int.TryParse(Request.QueryString["requisitionId"].ToString(),out id); req=se.ShowRequisitionDetail(id); if (req != null) { lblReqStatus.Text = req.ReqStatus; lblRDate.Text = req.ReqDate.ToShortDateString(); if (req.ReqApproveEmpID == null) { lblEName.Text = "Still Pending"; } else { lblEName.Text = req.employee.EmployeeName; } if (req.ReqReason == null||req.ReqReason==" "||req.ReqReason==string.Empty) { lblReason.Text = "Still Pending"; } else { lblReason.Text = req.ReqReason; } if (req.ReqApproveDate.ToString() == null||req.ReqApproveDate.ToString()==" "|| req.ReqApproveDate.ToString()==string.Empty) { lblADate.Text = "Still Pending"; } else { lblADate.Text = req.ReqApproveDate.ToString(); } } if (req.ReqStatus == "pending") { btnDelete.Visible = true; } else { btnDelete.Visible = false; } Binding(); } }
public requisition GetRequisitionDetailsByID(int searchReqID) { try { requisition currentreq=new requisition(); currentreq = (from r in entities.requisitions where r.ReqID == searchReqID select r).FirstOrDefault(); return currentreq; } catch (Exception ex) { throw ex; } }
public int createRequisition(requisition r) { try { requisition req = new requisition(); req.ReqEmpId = r.ReqEmpId; req.ReqStatus = r.ReqStatus; req.ReqDate = r.ReqDate; req.ReqDepID = r.ReqDepID; cntx.requisitions.Add(req); cntx.SaveChanges(); int id = req.ReqID; return id; } catch (Exception ex) { throw ex; } }
//method to manage outstanding requests public void CheckForOutStanding(Disbursement_M disbl) { List<requisitiondetail> rdlist = new List<requisitiondetail>(); checkdate = DateTime.Today; //checking requestions brfore today //checkdate = DateTime.Today.AddDays(2); requisitiondetail rcheck = new requisitiondetail(); //checking requisition rq = new requisition(); var m = from r in se.requisitiondetails where r.ReqItemID == disbl.ItemID && r.requisition.ReqDepID == disbl.DepID && r.ReqStatus=="approved" && r.requisition.ReqApproveDate < checkdate select r; rdlist = m.ToList(); rcheck = m.FirstOrDefault(); foreach (requisitiondetail rd in rdlist) { //if (rd.requisition.ReqReason == "outstanding") //{ // //rd.ReqStatus = "confirmed"; // //se.SaveChanges(); // //totalcount = totalcount + rd.ReqQuantityReq; // outstandingReqList.Add(rd); //} //else //{ // normalReqList.Add(rd); // //changing the status to confirmed // //rd.ReqStatus = "confirmed"; // //se.SaveChanges(); // //totalcount = totalcount + rd.ReqQuantityReq; //getting the count of items ordered by the dep //} rd.ReqStatus = "confirmed"; try { se.SaveChanges(); } catch (Exception ex) { string error; if (ex.InnerException != null) { Exception ex1; ex1 = ex.InnerException; error = ex1.InnerException.StackTrace; } else { string error1; error1 = ex.InnerException.Message; } } } if (disbl.QuantinHand < disbl.RequiredQuant) { int outstanding = disbl.RequiredQuant - disbl.QuantinHand; requisition outreq = new requisition(); requisitiondetail outreqdet = new requisitiondetail(); //creating an oustanding request automatically outreq.ReqApproveEmpID = rcheck.requisition.ReqApproveEmpID; outreq.ReqApproveDate = rcheck.requisition.ReqApproveDate; // come back here to make sure your logic is right outreq.ReqStatus = "outstanding"; outreq.ReqDate = rcheck.requisition.ReqDate; outreq.ReqDepID = rcheck.requisition.ReqDepID; outreq.ReqEmpId = rcheck.requisition.ReqEmpId; outreq.ReqReason = "outstanding"; try { se.requisitions.Add(outreq); se.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } //creating an autogenerated requestdetails for that particular item outreqdet.ReqID = outreq.ReqID; outreqdet.ReqItemID = disbl.ItemID; outreqdet.ReqQuantityReq = outstanding; outreqdet.ReqStatus = "approved"; try { se.requisitiondetails.Add(outreqdet); se.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } } }
public requisition ShowRequisitionDetail(int reqId) { requisition rr = new requisition(); try { var q = (from f in cntx.requisitions where f.ReqID == reqId //&& f.ReqStatus!="pending" select f).FirstOrDefault(); rr = q; } catch (Exception ex) { throw ex; } return rr; }