protected void BtnSubmitForm_Click(object sender, EventArgs e)
{
string deptId = HttpContext.Current.Profile.GetPropertyValue("department").ToString();
string fullName = HttpContext.Current.Profile.GetPropertyValue("fullname").ToString();
DateTime requestDate = DateTime.Now;
int requestId = RequisitionLogic.CreateRequisitionRecord(fullName, deptId, requestDate);
for (int i = 0; i < GridViewRequisitionForm.Rows.Count; i++)
{
string ItemID = (GridViewRequisitionForm.Rows[i].FindControl("LblItemID") as Label).Text;
int RequestedQuantity;
if (!int.TryParse((GridViewRequisitionForm.Rows[i].FindControl("TxtRequestedQuantity") as TextBox).Text, out RequestedQuantity))
{
}
string Status = "Pending";
string Priority = "No";
RequisitionRecordDetail r = RequisitionLogic.CreateRequisitionRecordDetail(requestId, ItemID, RequestedQuantity, Status, Priority);
}
statusMessage.Text = "Stationery Requisition Form Submitted Successfully.";
statusMessage.ForeColor = Color.Green;
statusMessage.Visible = true;
BtnSubmitForm.Visible = false;
GridViewRequisitionForm.DataSource = null;
GridViewRequisitionForm.DataBind();
LinkButtonGoBack.Visible = false;
Session["CartList"] = null;
}
// Retrieving status for each reqrecorddetails item
public static string GetStatus(int reqID)
{
using (SA45Team12AD context = new SA45Team12AD())
{
RequisitionRecordDetail rd = context.RequisitionRecordDetails.Where(x => x.RequestID.Equals(reqID)).First();
return((string)rd.Status);
}
}
// Retrieving priority for each reqrecorddetails item
public static string GetPriority(int reqDetailID)
{
using (SA45Team12AD context = new SA45Team12AD())
{
RequisitionRecordDetail rd = context.RequisitionRecordDetails.Where(x => x.RequestDetailID == reqDetailID).First();
return((string)rd.Priority);
}
}
public void CreateStationeryRequestDetails(int requestId, string itemId, int requestedQuantity)
{
RequisitionRecordDetail rRDetails = new RequisitionRecordDetail();
rRDetails.RequestID = requestId;
rRDetails.ItemID = itemId;
rRDetails.RequestedQuantity = requestedQuantity;
rRDetails.Status = "Approved";
rRDetails.Priority = "Yes";
using (SA45Team12AD ctx = new SA45Team12AD())
{
ctx.RequisitionRecordDetails.Add(rRDetails);
ctx.SaveChanges();
}
}
public static RequisitionRecordDetail CreateRequisitionRecordDetail(int requestId, string itemCode, int quantity, string status, string priority)
{
using (SA45Team12AD ctx = new SA45Team12AD())
{
RequisitionRecordDetail r = new RequisitionRecordDetail();
r.RequestID = requestId;
r.ItemID = itemCode;
r.RequestedQuantity = quantity;
r.Status = status;
r.Priority = priority;
ctx.RequisitionRecordDetails.Add(r);
ctx.SaveChanges();
return(r);
}
}
// Checking status for each reqrecorddetails item
public static bool CheckStatus(int reqID, string status)
{
using (SA45Team12AD context = new SA45Team12AD())
{
try
{
RequisitionRecordDetail rd = context.RequisitionRecordDetails.Where(x => x.RequestID == reqID).Where(y => y.Status.Equals(status)).First();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
