public void OfficeCategoryBind()
{
bl_empMap bl = new bl_empMap();
dl_empMap dl = new dl_empMap();
ReturnClass.ReturnDataTable dt = dl.Get_OfficeCategory(bl);// ("SELECT OfficeCategoryCode, OfficeCategoryName FROM officeCategory order by OfficeCategoryName ");
ddl_office_category.DataSource = dt.table;
ddl_office_category.DataTextField = "OfficeCategoryName";
ddl_office_category.DataValueField = "OfficeCategoryCode";
ddl_office_category.DataBind();
ddl_office_category.Items.Insert(0, new ListItem("--Select Office Category--", "0"));
}
public void BaseDepartmentBind()
{
bl_empMap bl = new bl_empMap();
dl_empMap dl = new dl_empMap();
ReturnClass.ReturnDataTable dt = dl.Get_BaseDepartment(bl);// ("SELECT dept_id, dept_name FROM basedepartment order by dept_name ");
ddl_department.DataSource = dt.table;
ddl_department.DataTextField = "dept_name";
ddl_department.DataValueField = "dept_id";
ddl_department.DataBind();
ddl_department.Items.Insert(0, new ListItem("--Select Department--", "0"));
}
} // End of Page Load
public void ChargeTypeBind()
{
bl_empMap bl = new bl_empMap();
dl_empMap dl = new dl_empMap();
bl.Charge_type = "ChargeType";
ReturnClass.ReturnDataTable dt = dl.GetCharge(bl);
ddl_charge.DataSource = dt.table;
ddl_charge.DataTextField = "DisplayName_en";
ddl_charge.DataValueField = "DDL_Name_Value";
ddl_charge.DataBind();
ddl_charge.Items.Insert(0, new ListItem("--Select Charge--", "0"));
}
public void OfficeLevelBind()
{
bl_empMap bl = new bl_empMap();
dl_empMap dl = new dl_empMap();
bl.Base_department_id = ddl_department.SelectedItem.Value;
bl.Role_id = h_roll_id.Value;
ReturnClass.ReturnDataTable dt = dl.Get_OfficeLevel(bl);
ddl_office_level.DataSource = dt.table;
ddl_office_level.DataTextField = "Office_level";
ddl_office_level.DataValueField = "olc";
ddl_office_level.DataBind();
ddl_office_level.Items.Insert(0, new ListItem("--Select Office Level--", "0"));
}
public void BindDesignation()
{
bl_empMap bl = new bl_empMap();
dl_empMap dl = new dl_empMap();
ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable();
ddl_designation.Items.Clear();
rd = dl.GetDesignation(bl);
ddl_designation.DataSource = rd.table;
ddl_designation.DataTextField = "Designation_Name";
ddl_designation.DataValueField = "Designation_ID";
ddl_designation.DataBind();
ddl_designation.Items.Insert(0, new ListItem("--Select Designation--", "0"));
}
public void BindDesignation() // user district
{
bl_empMap bl = new bl_empMap();
dl_empMap dl = new dl_empMap();
ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable();
ddl_designation.Items.Clear();
//bl.State = "22";//DDL_State.SelectedValue; //22 for Chhattisgarh
rd = dl.GetDesignation(bl);
ddl_designation.DataSource = rd.table;
ddl_designation.DataTextField = "Designation_Name";
ddl_designation.DataValueField = "Designation_ID";
ddl_designation.DataBind();
ddl_designation.Items.Insert(0, new ListItem("--Select Designation--", "0"));
}
public void bind_district() // user district
{
bl_empMap bl = new bl_empMap();
dl_empMap dl = new dl_empMap();
ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable();
ddl_district.Items.Clear();
bl.State = "22";//DDL_State.SelectedValue; //22 for Chhattisgarh
rd = dl.BindDistrict(bl);
ddl_district.DataSource = rd.table;
ddl_district.DataTextField = "District_Name";
ddl_district.DataValueField = "District_ID";
ddl_district.DataBind();
ddl_district.Items.Insert(0, new ListItem("--Select District--", "0"));
}
public void BindOfficer1()
{
ddl_employee1.Items.Clear();
bl_empMap bl = new bl_empMap();
dl_empMap dl = new dl_empMap();
ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable();
bl.Base_department_id = ddl_department1.SelectedValue;
bl.District_id_ofc = ddl_district1.SelectedValue;
rd = dl.GetEmployeeData1(bl);
ddl_employee1.DataSource = rd.table;
ddl_employee1.DataBind();
ddl_employee1.DataValueField = "id";
ddl_employee1.DataTextField = "label";
ddl_employee1.DataBind();
ddl_employee1.Items.Insert(0, new ListItem("--Select Officer--", "0"));
}
public void OfficeBind()
{
bl_empMap bl = new bl_empMap();
dl_empMap dl = new dl_empMap();
bl.Base_department_id = ddl_department.SelectedItem.Value;
bl.District_id_ofc = ddl_district.SelectedItem.Value;
bl.Office_category = ddl_office_category.SelectedItem.Value;
bl.Office_level_id = ddl_office_level.SelectedItem.Value;
ReturnClass.ReturnDataTable dt = dl.Get_Office_Data(bl);
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"));
}
public void BindOfficer1()
{
bl_empMap bl = new bl_empMap();
dl_empMap dl = new dl_empMap();
ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable();
bl.Base_department_id = ddl_department1.SelectedValue;
bl.District_id_ofc = ddl_district1.SelectedValue;
rd = dl.GetEmployeeDataAllocated(bl);
ddl_employee1.DataSource = rd.table;
ddl_employee1.DataTextField = "Name_en";
ddl_employee1.DataValueField = "emp_code";
ddl_employee1.DataBind();
// DDL_RTI_Officer.Items.Add(new ListItem(" select officer", "0"));
ddl_employee1.Items.Insert(0, new ListItem("--Select Officer--", "0"));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null)
{
Response.Redirect("~/Login.aspx");
}
else
{
string userID = Session["username"].ToString();
bl_empMap bl = new bl_empMap();
dl_empMap dl = new dl_empMap();
bl.User_id = userID;
string rollid = null;
rd = dl.select_admin_info(bl);
if (rd.table.Rows.Count > 0)
{
rollid = rd.table.Rows[0]["RollID"].ToString();
h_roll_id.Value = rollid;
if (rollid == "4" || rollid == "5") // DIO ROll ID
{
ddl_dist_view.Visible = false;
rfv_district1.Enabled = false;
txt_dist_view.Visible = true;
txt_district1.Visible = true;
ddl_district1.SelectedValue = rd.table.Rows[0]["district_id"].ToString();
txt_district1.Text = rd.table.Rows[0]["District_Name_En"].ToString();
bind_district();
ddl_district.SelectedValue = rd.table.Rows[0]["district_id"].ToString();
ddl_district.Enabled = false;
rfv_district.Enabled = false;
if (rollid == "5")
{
BaseDepartmentBind1();
ddl_department1.SelectedValue = rd.table.Rows[0]["base_department_id"].ToString();
ddl_department1.Enabled = false;
rfv_department1.Enabled = false;
BaseDepartmentBind();
ddl_department.SelectedValue = rd.table.Rows[0]["base_department_id"].ToString();
ddl_department.Enabled = false;
RFV_department.Enabled = false;
}
}
else
{
ddl_dist_view.Visible = true;
rfv_district1.Enabled = true;
txt_dist_view.Visible = false;
txt_district1.Visible = false;
}
}
// captchaStatus = false;
if (!Page.IsPostBack)
{
bind_GridView();
bind_district();
BaseDepartmentBind();
OfficeCategoryBind();
OfficeLevelBind();
OfficeBind();
BindDesignation();
ChargeTypeBind();
// Below is for selecting employee in first part
bind_district1();
BaseDepartmentBind1();
OfficeCategoryBind1();
OfficeLevelBind1();
OfficeBind1();
BindOfficer1();
BindDesignation1();
// first part end
ddl_Active.SelectedValue = "Y";
bindpermission();
bindrole();
}
}
} // End of Page Load
