/// <summary> /// Bindings the list. /// </summary> /// <param name="status">The status.</param> private void BindingList(EnumHelper.Status status) { SqlDataReader reader; reader = this.DataSource(EnumHelper.Status.Draft.ToString("d"), false); this.BindingHoldingList(reader); }
/// <summary> /// Findings the order number. /// </summary> private void FindingOrderNumber() { this.errorProvider.SetError(this.txtOrderNumber, string.Empty); if (this.txtOrderNumber.Text.Trim().Length > 0) { using (var ctx = new EF6.RT2020Entities()) { var objHeader = ctx.PurchaseOrderHeader.Where(x => x.OrderNumber.Contains(this.txtOrderNumber.Text.Trim())).AsNoTracking().FirstOrDefault(); if (objHeader != null) { EnumHelper.Status objStatus = (EnumHelper.Status)Enum.Parse(typeof(EnumHelper.Status), objHeader.Status.ToString()); switch (objStatus) { case EnumHelper.Status.Draft: // Holding this.tabREJAuthorization.SelectedIndex = 1; break; case EnumHelper.Status.Active: // Posting this.tabREJAuthorization.SelectedIndex = 0; break; } this.BindingList(objStatus); } else { this.errorProvider.SetError(this.txtOrderNumber, "Cash Purchase Number field does not exist!"); } } } else { this.errorProvider.SetError(this.txtOrderNumber, "Cash Purchase Number field cannot be blank!"); } }
/// <summary> /// Bindings the list. /// </summary> /// <param name="status">The status.</param> private void BindingList(EnumHelper.Status status) { SqlDataReader reader; switch (status) { case EnumHelper.Status.Draft: //// Holding reader = this.DataSource(EnumHelper.Status.Draft.ToString("d"), false); this.BindingHoldingList(reader); break; case EnumHelper.Status.Active: //// Posting reader = this.DataSource(EnumHelper.Status.Active.ToString("d"), true); this.BindingPostingList(reader); break; default: break; } }
private void FindingTxNumber() { errorProvider.SetError(txtTxNumber, string.Empty); if (txtTxNumber.Text.Trim().Length > 0) { using (var ctx = new EF6.RT2020Entities()) { //string sql = "TxNumber LIKE '%" + txtTxNumber.Text.Trim() + "%'"; var oHeader = ctx.StockTakeHeader.Where(x => x.TxNumber.Contains(txtTxNumber.Text.Trim())).AsNoTracking().FirstOrDefault(); if (oHeader != null) { EnumHelper.Status oStatus = (EnumHelper.Status)Enum.Parse(typeof(EnumHelper.Status), oHeader.Status.ToString()); switch (oStatus) { case EnumHelper.Status.Draft: // Holding tabSTKAuthorization.SelectedIndex = 1; BindingHoldingList(); break; case EnumHelper.Status.Active: // Posting tabSTKAuthorization.SelectedIndex = 0; BindingPostingList(); break; } } else { errorProvider.SetError(txtTxNumber, "StockTake Number field does not exist!"); } } } else { errorProvider.SetError(txtTxNumber, "StockTake Number field cannot be blank!"); } }