public string GetStateId(string StateCode)
{
string StateId = string.Empty;
DataTable dt = new DataTable();
DataSet ds = new DataSet();
DataView dv = new DataView();
try
{
if (StateCode != "")
{
if (Cache["DsDropDown"] == null)
{
dsDropDown = objdropdownBL.Usp_Get_DropDown();
Cache["DsDropDown"] = dsDropDown;
}
else
{
dsDropDown = (DataSet)Cache["DsDropDown"];
}
dv = dsDropDown.Tables[1].DefaultView;
//State_Code
dv.RowFilter = "State_Code ='" + StateCode + "'";
dt = dv.ToTable();
if (dt.Rows.Count > 0)
{
StateId = dt.Rows[0]["State_Id"].ToString();
}
if (StateId == "")
{
StateId = "0";
}
}
}
catch (Exception ex)
{
throw ex;
//Redirecting to error message page
}
return(StateId);
}
private void FillStates()
{
DropdownBL objdropdownBL = new DropdownBL();
DataSet dsDropDown = new DataSet();
try
{
if (Session["DsDropDown"] == null)
{
dsDropDown = objdropdownBL.Usp_Get_DropDown();
Session["DsDropDown"] = dsDropDown;
}
else
{
dsDropDown = (DataSet)Session["DsDropDown"];
}
grdAssign.DataSource = dsDropDown.Tables[1];
grdAssign.DataBind();
}
catch (Exception ex)
{
}
}
