protected void Page_Load(object sender, EventArgs e) { requisitionManager = new RequisitionManager(); currentUser = Utilities.Membership.GetCurrentLoggedInUser(); requisitions = requisitionManager.GetAllUnApprovedRequisitionByDepartmentID(currentUser.DepartmentID); if (requisitions != null) { GridView1.DataSource = requisitions; DataBind(); } if (requisitions.Count == 0) { ApproveAllButton.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { requisitionManager = new RequisitionManager(); UserManager u = new UserManager(); requisitions = requisitionManager.GetAllUnApprovedRequisitionByDepartmentID(1); if (requisitions != null) { GridView1.DataSource = requisitions; DataBind(); } if(requisitions.Count == 0) { Button1.Visible = false; Response.Write("No pending requests for approval."); } // ApproveSingleRequest(); }
protected void UpdateButton_Click(object sender, EventArgs e) { if (!Page.IsValid) return; try { using (TransactionScope ts = new TransactionScope()) { for (int i = 0; i < this.DistributionGridView.Rows.Count; i++) { GridViewRow gridViewRow = DistributionGridView.Rows[i]; HiddenField IsSpecialHiddenField = gridViewRow.FindControl("IsSpecialHiddenField") as HiddenField; HiddenField RequisitionIDHiddenField = gridViewRow.FindControl("RequisitionIDHiddenField") as HiddenField; HiddenField StationeryIDHiddenField = gridViewRow.FindControl("StationeryIDHiddenField") as HiddenField; HiddenField SpecialStationeryIDHiddenField = gridViewRow.FindControl("SpecialStationeryIDHiddenField") as HiddenField; HiddenField QuantityDisbursedHiddenField = gridViewRow.FindControl("QuantityDisbursedHiddenField") as HiddenField; TextBox QuantityTextBox = gridViewRow.FindControl("QuantityTextBox") as TextBox; bool isSpecial = Convert.ToBoolean(IsSpecialHiddenField.Value); int RequisitionID = Convert.ToInt32(RequisitionIDHiddenField.Value); int StationeryID = Convert.ToInt32(StationeryIDHiddenField.Value); int SpecialStationeryID = Convert.ToInt32(SpecialStationeryIDHiddenField.Value); int QuantityDisbursed = Convert.ToInt32(QuantityDisbursedHiddenField.Value); int QuantityDistributed = Convert.ToInt32(QuantityTextBox.Text.Trim()); using (RequisitionManager rm = new RequisitionManager()) { Requisition rq = rm.GetRequisitionByID(RequisitionID); if (!isSpecial) { List<RequisitionItem> rqItems = (from item in rq.RequisitionItems where item.StationeryID == StationeryID select item).ToList(); for (int j = 0; j < rqItems.Count && QuantityDisbursed > 0; j++) { RequisitionItem rqItem = rqItems[j]; if (QuantityDisbursed > rqItem.QuantityRequested) { rqItem.QuantityIssued = rqItem.QuantityRequested; QuantityDisbursed = QuantityDisbursed - rqItem.QuantityRequested; } else if (QuantityDisbursed > 0) { rqItem.QuantityIssued = QuantityDisbursed; QuantityDisbursed = 0; } } } else { List<SpecialRequisitionItem> srqItems = (from sitem in rq.SpecialRequisitionItems where sitem.SpecialStationeryID == SpecialStationeryID select sitem).ToList(); for (int j = 0; j < srqItems.Count && QuantityDisbursed > 0; j++) { SpecialRequisitionItem srqItem = srqItems[j]; if (QuantityDisbursed > srqItem.QuantityRequested) { srqItem.QuantityIssued = srqItem.QuantityRequested; QuantityDisbursed = QuantityDisbursed - srqItem.QuantityRequested; } else if (QuantityDisbursed > 0) { srqItem.QuantityIssued = QuantityDisbursed; QuantityDisbursed = 0; } } } Status status = rm.GetStatusByName(new StatusSearchDTO() { Name = "Fulfilled" }); rq.Status = status; rm.UpdateRequisition(rq); } } using (DisbursementManager dm = new DisbursementManager()) { Disbursement disbursement = dm.FindDisbursementByID(this.DisbursementId); disbursement.IsDistributed = true; dm.UpdateDisbursement(disbursement); } ts.Complete(); } Response.Redirect("~/Distribution/Disbursements.aspx"); } catch (Exception exception) { this.ErrorMessage.Text = exception.Message; } }
protected void Page_Load(object sender, EventArgs e) { //Create instance of new requisition Requisition r = new Requisition(); UserDAO user = new UserDAO(); RequisitionManager rq = new RequisitionManager(); CatalogDAO cat = new CatalogDAO(); //set the properties of requisition object r.DepartmentID = user.GetDepartmentByID(1).DepartmentID; r.CreatedBy = user.GetUserByID(1).UserID; r.StatusID = rq.GetStatusByID(new Status() { StatusID = 1}).StatusID; r.ApprovedBy = user.GetUserByID(2).UserID; r.UrgencyID = rq.GetUrgencyByID(new Urgency() { UrgencyID = 1 }).UrgencyID; r.RequisitionForm = "test"; r.DateRequested = DateTime.Now; //r.DateApproved = DateTime.Now; //Create a new requisitionitem for the current requisition RequisitionItem rqi = new RequisitionItem() { RequisitionID = r.RequisitionID, StationeryID = cat.GetAllStationeries().FirstOrDefault<Stationery>().StationeryID, QuantityRequested = 10, QuantityIssued = 10, Price = 5 }; //Create a new specialrequisitionitem for the current requisition SpecialRequisitionItem spi = new SpecialRequisitionItem() { RequisitionID = r.RequisitionID, SpecialStationeryID = 1, QuantityRequested = 10, QuantityIssued = 10, Price = 5, Name = "arav", Description = "test" }; //Add Child objects of the requisition objects //Add requisitionitem to requisition object r.RequisitionItems.Add(rqi); //Add specialitem to requisition object r.SpecialRequisitionItems.Add(spi); //Persist requisition to database //EF is very intelligent. It will also persist to requistionitem and specialrequistionitem rq.CreateRequisition(r); r = rq.GetAllRequisition().Last<Requisition>(); r.RequisitionItems.Last<RequisitionItem>().QuantityIssued = 6; rq.UpdateRequisition(r); spi = rq.GetAllSpecialRequisitionItems(r).Last<SpecialRequisitionItem>(); rq.DeleteSpecialRequisitionItem(spi); //Testing databinding after creation of requisitions if (!IsPostBack) { GridView1.DataSource = rq.GetAllRequisitionItems(r); GridView1.DataBind(); if (r != null) { GridView2.DataSource = rq.GetAllRequisition(); GridView2.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { requisitionManager = new RequisitionManager(); cManager = new CatalogManager(); CancelButton.Visible = false; if (!IsPostBack) { UrgencyDDL.DataSource = requisitionManager.GetAllUrgencies(); UrgencyDDL.DataTextField = "Name"; UrgencyDDL.DataValueField = "UrgencyID"; DataBind(); foreach (ListItem item in UrgencyDDL.Items) { if (item.Text == "Normal") { item.Selected = true; } } requisition = CreateRequisition(); Session["Requisition"] = requisition; } if (Session["Requisition"] != null) { requisition = (Requisition)Session["Requisition"]; } string key = string.Empty; int val = 0; NameValueCollection nv = Request.QueryString; if (nv.HasKeys()) { key = nv.GetKey(0); try { val = Convert.ToInt32(nv.Get(0)); } catch (Exception) { } } if (key == "RequestID" && val > 0) { requisition = requisitionManager.GetRequisitionByID(val); if (requisition != null) { Panel1.Visible = false; Panel2.Visible = false; RequestItemGridView.Columns[0].Visible = false; RequestItemGridView.Columns[1].Visible = false; SpecialRequestItemGridView.Columns[0].Visible = false; Panel4.Visible = false; SubmitButton.Visible = false; if (requisition.Status.Name == "Pending") { CancelButton.Visible = true; } GridDataBind(); } } }