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