protected void DataBindStationeryRetrievalFormGridView() { using (StationeryRetrievalManager srm = new StationeryRetrievalManager()) { this.StationeryRetrievalFormGridView.DataSource = srm.GetAllStationeryRetrievalForms(); this.StationeryRetrievalFormGridView.DataBind(); } }
protected void CreateButton_Click(object sender, EventArgs e) { try { using (StationeryRetrievalManager sm = new StationeryRetrievalManager()) { DAL.User loggedInUser = Utilities.Membership.GetCurrentLoggedInUser(); StationeryRetrievalForm srf = sm.CreateStationeryRetrievalFormByAllRequisitions(loggedInUser); Response.Redirect("~/HandleRequest/StationeryRetrievalForm.aspx?ID=" + srf.StationeryRetrievalFormID); } } catch (Exception exception) { this.ErrorMessage.Text = exception.Message; } }
protected void DataBindStationeryRetrievalFormView() { stationeryRetrievalFormID = Convert.ToInt32(Request.QueryString["ID"]); using (StationeryRetrievalManager sm = new StationeryRetrievalManager()) { List<StationeryRetrievalForm> srfs = new List<StationeryRetrievalForm>(); StationeryRetrievalForm stationeryRetrievalForm = sm.GetStationeryRetrievalFormByID(this.StationeryRetrievalFormID); isRetrieved = (bool)stationeryRetrievalForm.IsRetrieved; isCollected = (bool)stationeryRetrievalForm.IsCollected; this.UpdateRetrievedQuantityButton.Visible = (!IsRetrieved); this.UpdateActualQuantityButton.Visible = (IsRetrieved && !IsCollected); srfs.Add(stationeryRetrievalForm); this.StationeryRetrievalFormView.DataSource = srfs; this.StationeryRetrievalFormView.DataBind(); } }
protected void StationeryRetrievalFormView_DataBound(object sender, EventArgs e) { if (this.StationeryRetrievalFormView.CurrentMode == FormViewMode.ReadOnly) { if (!this.IsRetrieved) { GridView StationeryRetrievalFormItemGridView = StationeryRetrievalFormView.FindControl("StationeryRetrievalFormItemGridView") as GridView; EntityCollection<StationeryRetrievalFormItem> items = DataBinder.Eval(this.StationeryRetrievalFormView.DataItem, "StationeryRetrievalFormItems") as EntityCollection<StationeryRetrievalFormItem>; StationeryRetrievalFormItemGridView.DataSource = items; StationeryRetrievalFormItemGridView.DataBind(); } else { GridView StationeryRetrievalFormItemByDeptGridView = StationeryRetrievalFormView.FindControl("StationeryRetrievalFormItemByDeptGridView") as GridView; using (StationeryRetrievalManager sm = new StationeryRetrievalManager()) { List<vw_GetStationeryRetrievalFormItemByDept> srfiByDept = sm.GetVwStationeryRetrievalFormItemByDeptsByFormID(this.StationeryRetrievalFormID); StationeryRetrievalFormItemByDeptGridView.DataSource = srfiByDept; StationeryRetrievalFormItemByDeptGridView.DataBind(); } Utilities.Format.MergeRowBySameValue(StationeryRetrievalFormItemByDeptGridView, 1); } } }
protected void UpdateRetrievedQuantity() { GridView StationeryRetrievalFormItemGridView = StationeryRetrievalFormView.FindControl("StationeryRetrievalFormItemGridView") as GridView; if (StationeryRetrievalFormItemGridView != null) { try { int srfID = Convert.ToInt32(this.StationeryRetrievalFormView.DataKey.Value); AdjustmentVoucherTransaction adj = new AdjustmentVoucherTransaction(); List<Stationery> stationeries = new List<Stationery>(); List<SpecialStationery> specialStationeries = new List<SpecialStationery>(); using (StationeryRetrievalManager srm = new StationeryRetrievalManager()) { DAL.StationeryRetrievalForm srf = srm.GetStationeryRetrievalFormByID(srfID); List<StationeryRetrievalFormItem> srfis = srf.StationeryRetrievalFormItems.ToList(); foreach (GridViewRow row in StationeryRetrievalFormItemGridView.Rows) { HiddenField StationeryRetrievalFormItemIDHiddenField = row.FindControl("StationeryRetrievalFormItemIDHiddenField") as HiddenField; int srfiID = Convert.ToInt32(StationeryRetrievalFormItemIDHiddenField.Value); TextBox QtyRetrieved = row.FindControl("QuantityRetrievedTextBox") as TextBox; StationeryRetrievalFormItem srfi = (from s in srfis where s.StationeryRetrievalFormItemID == srfiID select s).FirstOrDefault(); int quantityRetrieved = Convert.ToInt32(QtyRetrieved.Text); srfi.QuantityRetrieved = quantityRetrieved; StockLogTransaction stockLogTransaction = new StockLogTransaction(); stockLogTransaction.Reason = ""; stockLogTransaction.Quantity = quantityRetrieved; if (srfi.Stationery != null) { Stationery stationery = srfi.Stationery; stockLogTransaction.StationeryID = srfi.Stationery.StationeryID; StationeryPrice price = stationery.StationeryPrices.First(); stockLogTransaction.Price = price.Price; stationery.QuantityInHand -= quantityRetrieved; stationeries.Add(stationery); stockLogTransaction.Balance = stationery.QuantityInHand; } else { SpecialStationery specialStationery = srfi.SpecialStationery; stockLogTransaction.SpecialStationeryID = srfi.SpecialStationery.SpecialStationeryID; stockLogTransaction.Price = 0.0m; specialStationery.Quantity -= quantityRetrieved; stockLogTransaction.Balance = specialStationery.Quantity; specialStationeries.Add(specialStationery); } stockLogTransaction.DateCreated = DateTime.Now; stockLogTransaction.Type = (int) AdjustmentType.Consumption; adj.StockLogTransactions.Add(stockLogTransaction); } StationeryRetrievalForm newSRF = srm.UpdateReceivedQuantity(srf); newSRF = srm.SetRecommendedQuantity(newSRF.StationeryRetrievalFormID); using(CatalogManager cm = new CatalogManager()) { foreach (Stationery stationery in stationeries) { cm.UpdateStationery(stationery); } foreach (SpecialStationery specialStationery in specialStationeries) { cm.UpdateSpecialStationery(specialStationery); } } } } catch (Exception exception) { this.ErrorMessage.Text = exception.Message; } } }
protected void UpdateActualQuantity() { GridView StationeryRetrievalFormItemByDeptGridView = StationeryRetrievalFormView.FindControl("StationeryRetrievalFormItemByDeptGridView") as GridView; if (StationeryRetrievalFormItemByDeptGridView != null) { int srfID = Convert.ToInt32(this.StationeryRetrievalFormView.DataKey.Value); using (StationeryRetrievalManager srm = new StationeryRetrievalManager()) { StationeryRetrievalForm srf = srm.GetStationeryRetrievalFormByID(srfID); List<StationeryRetrievalFormItem> srfis = srf.StationeryRetrievalFormItems.ToList(); List<StationeryRetrievalFormItemByDept> srfiByDepts = new List<StationeryRetrievalFormItemByDept>(); foreach (StationeryRetrievalFormItem srfi in srfis) { srfiByDepts.AddRange(srfi.StationeryRetrievalFormItemByDepts); } foreach (GridViewRow row in StationeryRetrievalFormItemByDeptGridView.Rows) { HiddenField srfByDeptIDHiddenField = row.FindControl("srfByDeptIDHiddenField") as HiddenField; int srfiByDeptID = Convert.ToInt32(srfByDeptIDHiddenField.Value); TextBox ActualQty = row.FindControl("QuantityActualTextBox") as TextBox; StationeryRetrievalFormItemByDept srfiByDept = (from s in srfiByDepts where s.StationeryRetrievalFormItemByDeptID == srfiByDeptID select s).FirstOrDefault(); int qty = Convert.ToInt32(ActualQty.Text.Trim() == "" ? "0" : ActualQty.Text.Trim()); srfiByDept.QuantityActual = qty; } StationeryRetrievalForm newSRF = srm.UpdateActualQuantity(srf); } } }