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());
}
}
}
