private void GetDistrictDetails(string mode)
{
DataTable resultData = new DataTable();
BusinessLayer.BusinessLogic business = new BusinessLayer.BusinessLogic();
try
{
ddlDistrict.Items.Clear();
if (mode.Equals("change"))
{
string query = "select * from master_district_details where State_ID=" + ddlState.SelectedItem.Value;
resultData = business.GetQueryResult(query);
}
else
{
resultData = business.GetTableDetails(ConfigurationManager.AppSettings["District_Info"].ToString());
}
ddlDistrict.DataSource = resultData;
if (resultData.Rows.Count > 0)
{
ddlDistrict.DataTextField = "District_Name";
ddlDistrict.DataValueField = "Id";
ddlDistrict.DataBind();
}
ddlDistrict.Items.Insert(0, new ListItem("--Select District--", "0"));
}
catch (Exception ex)
{
}
}
/// <summary>
/// Method to Get Master User Type Details
/// </summary>
public void GetUserTypeDetails()
{
DataTable resultData = new DataTable();
BusinessLayer.BusinessLogic business = new BusinessLayer.BusinessLogic();
try
{
resultData = business.GetTableDetails(ConfigurationManager.AppSettings["User_Type"].ToString());
ddlUserType.DataSource = resultData;
if (resultData.Rows.Count > 0)
{
ddlUserType.DataTextField = "User_Type";
ddlUserType.DataValueField = "Id";
ddlUserType.DataBind();
}
}
catch (Exception ex)
{
}
}
private void GetUnitDetails()
{
DataTable resultData = new DataTable();
BusinessLayer.BusinessLogic business = new BusinessLayer.BusinessLogic();
try
{
resultData = business.GetTableDetails(ConfigurationManager.AppSettings["Unit_Info"].ToString());
ddlUnit.DataSource = resultData;
if (resultData.Rows.Count > 0)
{
ddlUnit.DataTextField = "Unit_Name";
ddlUnit.DataValueField = "Id";
ddlUnit.DataBind();
}
ddlUnit.Items.Insert(0, new ListItem("--Select Unit--", "0"));
}
catch (Exception ex)
{
}
}
