protected void cboShed_SelectedIndexChanged(object sender, EventArgs e) { //TODO :Remove the ff ////populate Stack from the list. this.cboStackNo.Items.Add(new ListItem("Please select Stack", "")); this.cboStackNo.AppendDataBoundItems = true; List <StackBLL> list = new List <StackBLL>(); StackBLL obj = new StackBLL(); list = obj.GetActiveStackbyShedId(new Guid(this.cboShed.SelectedValue.ToString())); if (list.Count < 1) { this.lblMsg2.Text = "Ther are no stacks in this shed."; this.btnSave.Enabled = false; } else { this.cboStackNo.DataSource = list; this.cboStackNo.DataTextField = "StackNumber"; this.cboStackNo.DataValueField = "Id"; this.cboStackNo.DataBind(); } }
protected void btnSave_Click(object sender, EventArgs e) { Nullable <Guid> ShedId = null; Nullable <Guid> CommodityGradeId = null; String StackNumber = ""; try { ShedId = new Guid(this.cboShed.SelectedValue.ToString()); } catch { ShedId = null; } try { CommodityGradeId = new Guid(this.cboCommodityGrade.SelectedValue.ToString()); } catch { CommodityGradeId = null; } StackNumber = this.txtStackNumber.Text; StackBLL objstack = new StackBLL(); List <StackBLL> list = new List <StackBLL>(); Session["StackSearch"] = list; list = objstack.Search(ShedId, CommodityGradeId, StackNumber); this.gvStack.DataSource = list; this.gvStack.DataBind(); }
public static bool InsertStack(StackBLL obj, SqlTransaction tran) { int Affectedrow = 0; string strSql = "spInsertStack"; SqlParameter[] arPar = new SqlParameter[11]; try { arPar[0] = new SqlParameter("@ShedId", SqlDbType.UniqueIdentifier); arPar[0].Value = obj.ShedId; arPar[1] = new SqlParameter("@CommodityGradeId", SqlDbType.UniqueIdentifier); arPar[1].Value = obj.CommodityGradeid; arPar[2] = new SqlParameter("@StackNumber", SqlDbType.NVarChar, 50); arPar[2].Value = obj.StackNumber; arPar[3] = new SqlParameter("@Status", SqlDbType.Int); arPar[3].Value = (int)obj.Status; arPar[4] = new SqlParameter("@DateStarted", SqlDbType.DateTime); arPar[4].Value = obj.DateStarted; arPar[5] = new SqlParameter("@CreatedBy", SqlDbType.UniqueIdentifier); arPar[5].Value = UserBLL.GetCurrentUser(); arPar[6] = new SqlParameter("@Id", SqlDbType.UniqueIdentifier); arPar[6].Value = obj.Id; arPar[7] = new SqlParameter("@PhysicalAddress", SqlDbType.Int); arPar[7].Value = obj.PhysicalAddress; arPar[8] = new SqlParameter("@BeginingBalance", SqlDbType.Int); arPar[8].Value = obj.BeginingNoBags; arPar[9] = new SqlParameter("@warehouseId", SqlDbType.UniqueIdentifier); arPar[9].Value = obj.WarehouseId; //productionyearstack arPar[10] = new SqlParameter("@productionYear", SqlDbType.Int); arPar[10].Value = obj.ProductionYear; Affectedrow = SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, strSql, arPar); if (Affectedrow == 1) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } }
protected void cboShed_SelectedIndexChanged(object sender, EventArgs e) { //TODO :Remove the ff if (this.cboShed.SelectedValue.ToString() == "") { this.lblmsg.Text = "Please Selected Shed"; return; } ////populate Stack from the list. this.cboStackNo.Items.Add(new ListItem("Please select Stack", "")); this.cboStackNo.AppendDataBoundItems = true; List <StackBLL> list = new List <StackBLL>(); StackBLL obj = new StackBLL(); Guid CG = Guid.Empty; if (ViewState["UnloadingCommGradeId"] != null) { CG = new Guid(ViewState["UnloadingCommGradeId"].ToString()); } int productionYear = -1; if (ViewState["productionYear"] != null) { productionYear = int.Parse(ViewState["productionYear"].ToString()); } list = obj.GetActiveStackbyShedId(new Guid(this.cboShed.SelectedValue.ToString()), CG, productionYear); if (list.Count < 1) { this.lblMsg2.Text = "Ther are no stacks in this shed."; this.btnSave.Enabled = false; } else { foreach (StackBLL s in list) { this.cboStackNo.Items.Add(new ListItem(s.StackNumber, s.Id.ToString())); } } }
protected void btnSave_Click(object sender, EventArgs e) { bool isSaved = false; Nullable <Guid> CommodityGradeId = null; Nullable <Guid> ShedId = null; StackStatus Status; Nullable <DateTime> DateStarted = null; string StackNumer; try { CommodityGradeId = new Guid(this.cboCommodityGrade.SelectedValue.ToString()); } catch { this.lblmsg.Text = "Please select Commodity Grade"; return; } try { ShedId = new Guid(this.cboShed.SelectedValue.ToString()); } catch { this.lblmsg.Text = "Please select shed"; return; } StackNumer = this.txtStackNumber.Text; try { Status = (StackStatus)int.Parse(this.cboStatus.SelectedValue.ToString()); } catch { this.lblmsg.Text = "Please select Status"; return; } try { DateStarted = DateTime.Parse(this.txtDateStarted.Text); } catch { this.lblmsg.Text = "Please select Date Started."; return; } CommodityGradeBLL objCG = new CommodityGradeBLL(); objCG = CommodityGradeBLL.GetCommodityGrade((Guid)CommodityGradeId); if (objCG == null) { this.lblmsg.Text = "Unable to get commodity Grade.Please try again"; return; } if (string.IsNullOrEmpty(objCG.Symbol) == true) { this.lblmsg.Text = "Unable to get commodity Grade Symbol.Please try again"; return; } int NoBags, PhysicalAddress; StackBLL objStack = new StackBLL(); objStack.CommodityGradeid = (Guid)CommodityGradeId; objStack.CommodityGradeid = (Guid)CommodityGradeId; objStack.ShedId = (Guid)ShedId; if (int.TryParse(this.txtBeginingNoBags.Text, out NoBags) == false) { this.lblmsg.Text = "Please correct Begining No. Bags. "; return; } if (int.TryParse(this.cboStackNumber.SelectedValue.ToString(), out PhysicalAddress) == false) { this.lblmsg.Text = "Please Select Physical Stack Number. "; return; } string stackName = this.cboStackNumber.SelectedValue + "-" + objCG.Symbol + "-" + this.txtDateStarted.Text; //productionyearstack int productionYear = int.Parse(this.cboProductionYear.SelectedValue.ToString()); objStack.BeginingNoBags = NoBags; objStack.PhysicalAddress = PhysicalAddress; objStack.StackNumber = stackName; objStack.DateStarted = (DateTime)DateStarted; objStack.Status = Status; objStack.WarehouseId = new Guid(this.cboWarehouse.SelectedValue.ToString()); objStack.ProductionYear = productionYear; if (objStack.ValidateForSave() == true) { isSaved = objStack.Add(); if (isSaved == true) { this.lblmsg.Text = "Data updated Successfully"; this.txtStackNumber.Text = stackName; //Clear(); this.btnSave.Enabled = false; } else { this.lblmsg.Text = "Unable to add this record."; } } }
public static List <StackBLL> GetActiveStackByShed(Guid Id) { string strSql = "spGetActiveStackByShedId"; SqlDataReader reader; SqlParameter[] arPar = new SqlParameter[1]; List <StackBLL> list = null; arPar[0] = new SqlParameter("@ShedId", SqlDbType.UniqueIdentifier); arPar[0].Value = Id; SqlConnection conn = null; try { conn = Connection.getConnection(); reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql, arPar); if (reader.HasRows) { list = new List <StackBLL>(); while (reader.Read()) { StackBLL obj = new StackBLL(); if (reader["Id"] != DBNull.Value) { obj.Id = new Guid(reader["Id"].ToString()); } else { throw new Exception("Invalid Id"); } if (reader["ShedId"] != DBNull.Value) { obj.ShedId = new Guid(reader["ShedId"].ToString()); } else { throw new Exception("Invalid Shed"); } if (reader["CommodityGradeId"] != DBNull.Value) { obj.CommodityGradeid = new Guid(reader["CommodityGradeId"].ToString()); } else { throw new Exception("Invalid Commodity Grade"); } obj.StackNumber = reader["StackNumber"].ToString(); if (reader["Status"] != DBNull.Value) { obj.Status = (StackStatus)Convert.ToInt32(reader["Status"].ToString()); } else { throw new Exception("Invalid Status"); } if (reader["DateStarted"] != DBNull.Value) { obj.DateStarted = Convert.ToDateTime(reader["DateStarted"].ToString()); } else { throw new Exception("Invalid Date Statrted"); } if (reader["PhysicalAddress"] != DBNull.Value) { obj.PhysicalAddress = int.Parse(reader["PhysicalAddress"].ToString()); } if (reader["productionYear"] != DBNull.Value) { obj.ProductionYear = int.Parse(reader["productionYear"].ToString()); } list.Add(obj); } return(list); } } catch (Exception ex) { throw ex; } finally { if (conn != null) { if (conn.State == ConnectionState.Open) { conn.Close(); } } } return(null); }
public static List <StackBLL> Search(Nullable <Guid> ShedId, Nullable <Guid> CommodityGradeId, String StackNumber) { string strSql = SearchHelper(ShedId, CommodityGradeId, StackNumber); List <StackBLL> list; SqlDataReader reader; SqlConnection conn = Connection.getConnection(); if (conn == null || conn.State != ConnectionState.Open) { throw new Exception("Invalid database connection."); } reader = SqlHelper.ExecuteReader(conn, CommandType.Text, strSql); if (reader.HasRows) { list = new List <StackBLL>(); while (reader.Read()) { StackBLL obj = new StackBLL(); if (reader["Id"] != null) { obj.Id = new Guid(reader["Id"].ToString()); } if (reader["ShedId"] != DBNull.Value) { obj.ShedId = new Guid(reader["ShedId"].ToString()); } if (reader["CommodityGradeId"] != DBNull.Value) { obj.CommodityGradeid = new Guid(reader["CommodityGradeId"].ToString()); } if (reader["StackNumber"] != DBNull.Value) { obj.StackNumber = reader["StackNumber"].ToString(); } if (reader["Status"] != DBNull.Value) { obj.Status = (StackStatus)int.Parse(reader["Status"].ToString()); } if (reader["DateStarted"] != DBNull.Value) { obj.DateStarted = DateTime.Parse(reader["DateStarted"].ToString()); } if (reader["PhysicalAddress"] != DBNull.Value) { obj.PhysicalAddress = int.Parse(reader["PhysicalAddress"].ToString()); } list.Add(obj); } if (conn != null) { if (conn.State == ConnectionState.Open) { conn.Close(); } } return(list); } else { if (conn != null) { if (conn.State == ConnectionState.Open) { conn.Close(); } } return(null); } }