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