protected void GridViewVPR_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { RequisitionRecord record = (RequisitionRecord)e.Row.DataItem; int ReuestID = record.RequestID; Label LblDateProcessed = e.Row.FindControl("LblDateProcessed") as Label; if (record.ApprovedDate != null) { LblDateProcessed.Text = ((DateTime)record.ApprovedDate).ToString("d"); } else { LblDateProcessed.Text = "null"; } RequisitionRecord re = (RequisitionRecord)e.Row.DataItem; int RequestID1 = re.RequestID; Label LblStatus = e.Row.FindControl("LblStatus") as Label; string status = RequisitionLogic.GetRecordStatus(re.RequestID); if (status != null) { LblStatus.Text = status; } } }
// Retrieving deptID from the requisition record table public static string GetReqRemarks(int reqID) { using (SA45Team12AD context = new SA45Team12AD()) { RequisitionRecord rd = context.RequisitionRecords.Where(x => x.RequestID.Equals(reqID)).First(); return((string)rd.Remarks); } }
//----------------- Li Jianing's Code Ends Here------------------// //-------------------- Lim Chang Siang and Yuan Yishu's Code Starts Here-----------------------// public static int CreateRequisitionRecord(string requestorName, string departmentId, DateTime requestDate) { using (SA45Team12AD ctx = new SA45Team12AD()) { RequisitionRecord r = new RequisitionRecord(); r.RequestorName = requestorName; r.DepartmentID = departmentId; r.RequestDate = requestDate; ctx.RequisitionRecords.Add(r); ctx.SaveChanges(); return(r.RequestID); } }
public int CreateSystemStationeryRequest(DateTime requestDate, string deptId, string remarks) { RequisitionRecord rRecord = new RequisitionRecord(); using (SA45Team12AD ctx = new SA45Team12AD()) { rRecord.DepartmentID = deptId; rRecord.Remarks = remarks; rRecord.RequestorName = "DisbursementLogic"; rRecord.RequestDate = DateTime.Now.Date; rRecord.ApprovedDate = DateTime.Now.Date; rRecord.ApproverName = "System Generated Request"; ctx.RequisitionRecords.Add(rRecord); ctx.SaveChanges(); return(rRecord.RequestID); } }
protected void Page_Load(object sender, EventArgs e) { // Retrieving from the link our req ID reqID = Request.QueryString["RequestID"]; // Retrieving our req record using the reqID retrieved RequisitionRecord tempR = RequisitionLogic.FindRequisitionRecord(Convert.ToInt32(reqID)); if (!IsPostBack) { // Populating the labels... LblReqFormID.Text = Convert.ToString("RQ" + tempR.RequestID); LblEmployeeName.Text = tempR.RequestorName; LblDateCreated.Text = tempR.RequestDate.Value.ToString("MM/dd/yyyy"); LblStatus.Text = RequisitionLogic.GetStatus(Convert.ToInt32(reqID)); if (String.IsNullOrWhiteSpace(tempR.Remarks)) { TxtRemarks.Text = "No remarks."; } else { TxtRemarks.Text = tempR.Remarks; } // Toggling the visibilty of the "Approve" and "Reject" controls --- If "Pending", will still remain invisible if (RequisitionLogic.GetStatus(Convert.ToInt32(reqID)).Equals("Pending")) { TxtRemarks.Text = ""; BtnApprove.Visible = true; BtnReject.Visible = true; LblDateApproved.Text = "Pending"; LblMessage.Text = "To approve or reject this request, kindly select one of the following options below."; } else { // Other attrs LblMessage.Text = ""; // For previously approved request LblDateApproved.Text = tempR.ApprovedDate.Value.ToString("MM/dd/yyyy"); TxtRemarks.Attributes.Add("readonly", "readonly"); } } // Populating the gridview GridViewDetails.DataSource = RequisitionLogic.FindRequisitionRecordDetailsByReqID(Convert.ToInt32(reqID)); GridViewDetails.DataBind(); }
// Rejecting the requisition record protected void BtnReject_Click(object sender, EventArgs e) { string temp = RequisitionLogic.ProcessRequsitionRequest(Convert.ToInt32(reqID), "Rejected", RequisitionLogic.GetCurrentDeptUserName(), TxtRemarks.Text); LblMessage.Text = temp; // Modifying the textbox if successful if (temp.Contains("successfully")) { TxtRemarks.Attributes.Add("readonly", "readonly"); BtnApprove.Visible = false; BtnReject.Visible = false; RequisitionRecord tR = RequisitionLogic.FindRequisitionRecord(Convert.ToInt32(reqID)); LblDateApproved.Text = tR.ApprovedDate.Value.ToString("MM/dd/yyyy"); LblStatus.Text = RequisitionLogic.GetStatus(Convert.ToInt32(reqID)); } }
// Processing requisition requests by DEPARTMENT HEAD public static string ProcessRequsitionRequest(int reqID, string status, string approverName, string remarks) { using (SA45Team12AD context = new SA45Team12AD()) { // Updating the status of all items in the request List <RequisitionRecordDetail> rd = context.RequisitionRecordDetails.Where(x => x.RequestID == reqID).ToList(); RequisitionRecord r = context.RequisitionRecords.Where(x => x.RequestID == reqID).First(); try { // Updating the status in the ReqDetails table foreach (var item in rd) { item.Status = status; } // Updating the reques in ReqRecords table r.ApprovedDate = DateTime.Now; r.ApproverName = approverName; if (!String.IsNullOrWhiteSpace(remarks)) { r.Remarks = remarks; } // Confirming changes to the DB context.SaveChanges(); } catch (Exception) { return(("Procedure was unsuccessful.").ToString()); } if (status.Equals("Approved")) { return(("Request R" + reqID + ", was successfully approved.").ToString()); } else { return(("Request R" + reqID + ", was successfully rejected.").ToString()); } } }