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"));
}