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