void BindState()
{
oblState = new Store.State.BusinessLogic.State();
try
{
objStatelist = oblState.GetAllStateList(0, 0, "");
if (objStatelist != null)
{
dgvState.DataSource = objStatelist;
dgvState.DataBind();
}
else
{
dgvState.DataSource = null;
dgvState.DataBind();
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(State).FullName, 1);
}
finally
{
oblState = null;
objStatelist = null;
}
}
void BindState(int id)
{
oblState = new Store.State.BusinessLogic.State();
try
{
objStatelist = oblState.GetAllStateList(id, 0, "");
if (objStatelist != null)
{
ListItem al = new ListItem("<-Select State->", "0", true);
ddlState.DataSource = objStatelist;
ddlState.DataTextField = "StateName";
ddlState.DataValueField = "StateID";
ddlState.DataBind();
ddlState.Items.Insert(0, al);
}
else
{
ddlState.DataSource = null;
ddlState.DataBind();
}
}
catch (Exception ex)
{
throw;
}
finally
{
oblState = null;
objStatelist = null;
}
}
void bindState(int id)
{
oblState = new Store.State.BusinessLogic.State();
try
{
objStatelist = oblState.GetAllStateList(id, 0, "");
if (objStatelist != null)
{
ListItem al = new ListItem("<-Select State->", "0", true);
ddlStateID.DataSource = objStatelist;
ddlStateID.DataTextField = "StateName";
ddlStateID.DataValueField = "StateID";
ddlStateID.DataBind();
ddlStateID.Items.Insert(0, al);
}
else
{
ddlStateID.DataSource = null;
ddlStateID.DataBind();
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(UserInfo).FullName, 1);
}
finally
{
oblState = null;
objStatelist = null;
}
}
public Store.State.BusinessObject.StateList GetAllStateList(int StateID, int Flag, string FlagValue)
{
Store.State.BusinessObject.State objState = null;
Store.State.BusinessObject.StateList objStateList = null;
string SQL = string.Empty;
ParameterList paramList = new ParameterList();
DataTableReader dr;
try
{
SQL = "proc_State";
objStateList = new BusinessObject.StateList();
paramList.Add(new SQLParameter("@StateID", StateID));
paramList.Add(new SQLParameter("@Flag", Flag));
paramList.Add(new SQLParameter("@FlagValue", FlagValue));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
while (dr.Read())
{
objState = new BusinessObject.State();
if (dr.IsDBNull(dr.GetOrdinal("StateID")) == false)
{
objState.StateID = dr.GetInt32(dr.GetOrdinal("StateID"));
}
if (dr.IsDBNull(dr.GetOrdinal("StateName")) == false)
{
objState.StateName = dr.GetString(dr.GetOrdinal("StateName"));
}
if (dr.IsDBNull(dr.GetOrdinal("CountryID")) == false)
{
objState.CountryID = dr.GetInt32(dr.GetOrdinal("CountryID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CountryName")) == false)
{
objState.CountryName = dr.GetString(dr.GetOrdinal("CountryName"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)
{
objState.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)
{
objState.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)
{
objState.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)
{
objState.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)
{
objState.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID"));
}
objStateList.Add(objState);
}
dr.Close();
return(objStateList);
}
catch (Exception ex)
{
throw;
}
}