protected void cboCommodityGrade_SelectedIndexChanged(object sender, EventArgs e)
{
Guid CommodityGradeId = Guid.Empty;
CommodityGradeId = new Guid(this.cboCommodityGrade.SelectedValue.ToString());
if (CommodityGradeId == Guid.Empty)
{
this.btnSave.Enabled = false;
this.lblMsg.Text = "Please Select commodity Grade";
return;
}
CommodityGradeTotalValueBLL obj = new CommodityGradeTotalValueBLL();
obj = obj.GetByCommodityGradeId(CommodityGradeId);
if (obj == null)
{
this.lblMsg.Text = "No Data entered for this record.";
ViewState["old"] = null;
}
else
{
ViewState["old"] = obj;
this.txtMinimumValue.Text = obj.MinValue.ToString();
this.txtMaxValue.Text = obj.MaxValue.ToString();
this.cboStatus.SelectedValue = ((int)(obj.Status)).ToString();
}
}
public static bool Update(CommodityGradeTotalValueBLL obj, SqlTransaction tran)
{
string strSql = "spUpdateCommodityGradeTotalValue";
SqlParameter[] arPar = new SqlParameter[6];
arPar[0] = new SqlParameter("@Id", SqlDbType.UniqueIdentifier);
arPar[0].Value = obj.Id;
arPar[1] = new SqlParameter("@CommodityGradeId", SqlDbType.UniqueIdentifier);
arPar[1].Value = obj.CommodityGradeId;
arPar[2] = new SqlParameter("@MaxValue", SqlDbType.Float);
arPar[2].Value = obj.MaxValue;
arPar[3] = new SqlParameter("@MinValue", SqlDbType.Float);
arPar[3].Value = obj.MinValue;
arPar[4] = new SqlParameter("@Status", SqlDbType.TinyInt);
arPar[4].Value = (int)obj.Status;
arPar[5] = new SqlParameter("@UserId", SqlDbType.UniqueIdentifier);
arPar[5].Value = UserBLL.GetCurrentUser();
int AffectedRows = -1;
AffectedRows = SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, strSql, arPar);
return(AffectedRows == 1);
}
public static CommodityGradeTotalValueBLL GetByCommodityGradeId(Guid CGId)
{
string strSql = "GetCommodityGradeFactorValueByCGid";
CommodityGradeTotalValueBLL obj = null;
SqlDataReader reader;
SqlConnection conn = null;
SqlParameter[] arPar = new SqlParameter[1];
arPar[0] = new SqlParameter("@CommodityGradeId", SqlDbType.UniqueIdentifier);
arPar[0].Value = CGId;
conn = Connection.getConnection();
reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql, arPar);
if (reader.HasRows)
{
obj = new CommodityGradeTotalValueBLL();
if (reader.Read())
{
obj.Id = new Guid(reader["Id"].ToString());
obj.CommodityGradeId = new Guid(reader["CommodityGradeId"].ToString());
obj.MaxValue = float.Parse(reader["MaxValue"].ToString());
obj.MinValue = float.Parse(reader["MinValue"].ToString());
if (reader["Status"] != DBNull.Value)
{
obj.Status = (CGTotalValueStatus)int.Parse(reader["Status"].ToString());
}
if (reader["CreatedBy"] != DBNull.Value)
{
obj.CreatedBy = new Guid(reader["CreatedBy"].ToString());
}
if (reader["CreatedTimestamp"] != DBNull.Value)
{
obj.CreatedTimestamp = DateTime.Parse(reader["CreatedTimestamp"].ToString());
}
if (reader["LastModifiedBy"] != DBNull.Value)
{
obj.LastModifiedBy = new Guid(reader["LastModifiedBy"].ToString());
}
if (reader["LastModifiedTimestamp"] != DBNull.Value)
{
obj.LastModifiedTimestamp = DateTime.Parse(reader["LastModifiedTimestamp"].ToString());
}
return(obj);
}
else
{
return(null);
}
}
return(null);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (ViewState["old"] == null)// new entry
{
CommodityGradeTotalValueBLL obj = new CommodityGradeTotalValueBLL();
obj.Id = new Guid(this.cboCommodityGrade.SelectedValue.ToString());
obj.CommodityGradeId = new Guid(this.cboCommodityGrade.SelectedValue.ToString());
obj.MaxValue = float.Parse(this.txtMaxValue.Text);
obj.MinValue = float.Parse(this.txtMinimumValue.Text);
obj.Status = (CGTotalValueStatus)int.Parse(this.cboStatus.SelectedValue.ToString());
if (obj.Update(null))
{
ViewState["old"] = obj;
this.lblMsg.Text = "Data Updated Successfully";
this.btnSave.Enabled = false;
}
else
{
this.lblMsg.Text = "Unable to update data please try again.";
}
}
else
{
CommodityGradeTotalValueBLL obj = (CommodityGradeTotalValueBLL)ViewState["old"];
CommodityGradeTotalValueBLL objOld = (CommodityGradeTotalValueBLL)ViewState["old"];
obj.CommodityGradeId = new Guid(this.cboCommodityGrade.SelectedValue.ToString());
obj.MaxValue = float.Parse(this.txtMaxValue.Text);
obj.MinValue = float.Parse(this.txtMinimumValue.Text);
obj.Status = (CGTotalValueStatus)int.Parse(this.cboStatus.SelectedValue.ToString());
if (obj.Update(objOld) == true)
{
ViewState["old"] = null;
this.btnSave.Enabled = false;
this.lblMsg.Text = "Data updated Successfully";
}
else
{
this.lblMsg.Text = "Unable to update data please try again.";
}
}
}
