public void BaseDepartmentBind() { dl_RTI_Request objDL = new dl_RTI_Request(); //string dept = DDL_Department.SelectedItem.Value; ReturnClass.ReturnDataTable dt = objDL.Get_RTI_DDL_Data("SELECT dept_id, dept_name FROM basedepartment order by dept_name "); DDL_BaseDepartment.DataSource = dt.table; DDL_BaseDepartment.DataTextField = "dept_name"; DDL_BaseDepartment.DataValueField = "dept_id"; DDL_BaseDepartment.DataBind(); DDL_BaseDepartment.Items.Insert(0, new ListItem("--Select Department--", "0")); }
public void OfficeCategoryBind() { dl_RTI_Request objDL = new dl_RTI_Request(); //string dept = DDL_Department.SelectedItem.Value; ReturnClass.ReturnDataTable dt = objDL.Get_RTI_DDL_Data("SELECT OfficeCategoryCode, OfficeCategoryName FROM officeCategory order by OfficeCategoryName "); DDL_OfficeCategory.DataSource = dt.table; DDL_OfficeCategory.DataTextField = "OfficeCategoryName"; DDL_OfficeCategory.DataValueField = "OfficeCategoryCode"; DDL_OfficeCategory.DataBind(); DDL_OfficeCategory.Items.Insert(0, new ListItem("--Select Office Category--", "0")); }
public void DistrictBind() { dl_RTI_Request objDL = new dl_RTI_Request(); //string dept = DDL_Department.SelectedItem.Value; ReturnClass.ReturnDataTable dt = objDL.Get_RTI_DDL_Data("SELECT District_ID, District_Name FROM districts WHERE StateCode='22' order by District_Name "); RTI_DDL_District.DataSource = dt.table; RTI_DDL_District.DataTextField = "District_Name"; RTI_DDL_District.DataValueField = "District_ID"; RTI_DDL_District.DataBind(); RTI_DDL_District.Items.Insert(0, new ListItem("--Select District--", "0")); }
public void OfficeLevelBind() { dl_RTI_Request objDL = new dl_RTI_Request(); string dept = DDL_BaseDepartment.SelectedItem.Value; string strquery = "SELECT OfficeLevelCode, OfficeLevelName FROM officelevel WHERE " + " officelevel.BaseDeptCode='" + dept + "' order by OfficeLevelName "; ReturnClass.ReturnDataTable dt = objDL.Get_RTI_DDL_Data(strquery); DDL_OfficeLevel.DataSource = dt.table; DDL_OfficeLevel.DataTextField = "OfficeLevelName"; DDL_OfficeLevel.DataValueField = "OfficeLevelCode"; DDL_OfficeLevel.DataBind(); DDL_OfficeLevel.Items.Insert(0, new ListItem("--Select Office Level--", "0")); }
public void OfficeBind() { dl_RTI_Request objDL = new dl_RTI_Request(); string dept = DDL_BaseDepartment.SelectedItem.Value; string district = RTI_DDL_District.SelectedItem.Value; string officeCategory = DDL_OfficeCategory.SelectedItem.Value; string officeLevel = DDL_OfficeLevel.SelectedItem.Value; string strquery = "SELECT NewOfficeCode, OfficeName FROM office WHERE " + " office.BaseDeptCode='" + dept + "' AND office.DistrictCodeNew='" + district + "'" + " AND office.OfficeCategory='" + officeCategory + "' AND office.OfficeLevel='" + officeLevel + "' order by OfficeName "; ReturnClass.ReturnDataTable dt = objDL.Get_RTI_DDL_Data(strquery); DDL_Office.DataSource = dt.table; DDL_Office.DataTextField = "OfficeName"; DDL_Office.DataValueField = "NewOfficeCode"; DDL_Office.DataBind(); DDL_Office.Items.Insert(0, new ListItem("--Select Office--", "0")); }