public ReturnClass.ReturnDataTable get_role(bl_empMap bl)
{
ReturnClass.ReturnDataTable dt = null;
db_maria_connection db = new db_maria_connection();
string where = " where Role_id <> 2 ";
if (bl.Role_id == "4" || bl.Role_id == "5")
{
where += " and Role_id='3' "; // For dio and nodel select only employee
}
string str = @" select Role_id, RoleName from role_table " + where;
dt = db.executeSelectQuery(str);
return(dt);
}
public ReturnClass.ReturnDataTable select_roll_emp(bl_login bl)
{
string str = @" select distinct e.role_id as id, l.UserID, rt.WelcomePage as page, rt.RoleName as name from emp_office_mapping e
join login l on l.LoginID= e.emp_code
join role_table rt on rt.Role_id= e.role_id where l.UserID=@loginid and e.active=@active ";
MySqlParameter[] pm = new MySqlParameter[]
{
//new MySqlParameter("password",bl.Password),
new MySqlParameter("active", "Y"),
new MySqlParameter("loginid", bl.UserID)
};
rd = db.executeSelectQuery(str, pm);
return(rd);
}
public void bind_state()
{
bl_RTI_Request objblData = new bl_RTI_Request();
dl_RTI_Request objData = new dl_RTI_Request();
ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable();
DDL_State.Items.Clear();
objblData.Country = ddl_country.SelectedValue;
rd = objData.BindState(objblData);
DDL_State.DataSource = rd.table;
DDL_State.DataTextField = "state_name_e";
DDL_State.DataValueField = "state_id";
DDL_State.DataBind();
DDL_State.Items.Add(new ListItem(" Choose State", "0"));
}
public ReturnClass.ReturnDataTable officelevel(bl_employee_action bl)
{
ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable();
db_maria_connection db = new db_maria_connection();
string str = "select ol.OfficeLevelName as Office_level, ol.OfficeLevelCode as olc from officelevel ol ";
string where = " where 1 = 1 and ol.BaseDeptCode=@BaseDeptCode";
MySqlParameter[] fa = new MySqlParameter[]
{
new MySqlParameter("BaseDeptCode", bl.Base_department_id)
};
str = str + where + " order by Office_level asc";
rd = db.executeSelectQuery(str, fa);
return(rd);
}
public ReturnClass.ReturnDataTable Get_BaseDepartment(bl_user_login bl)
{
string str = @" SELECT distinct B.dept_id, B.dept_name FROM employee_table as A
inner join basedepartment as B on A.base_department_id = B.dept_id
where A.district_id = @district_id order by B.dept_name ";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("district_id", bl.District_id)
};
ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable();
db_maria_connection db = new db_maria_connection();
rd = db.executeSelectQuery(str, pm);
return(rd);
}
public ReturnClass.ReturnDataTable GetRtiStatus_detail(bl_RTI_Request bl)
{
ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
db_maria_connection db = new db_maria_connection();
string str = @"select rs.rti_id as rtiid, rs.IsValid as isvalid, rd.securitycode as seqcode from rti_status rs
inner join rti_detail rd on rd.rti_id = rs.rti_id
where rs.rti_id = @rti_id";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("rti_id", bl.RTI_Request_id)
};
dt = db.executeSelectQuery(str, pm);
return(dt);
}
public ReturnClass.ReturnDataTable Get_District(bl_user_login bl)
{
// string df = @"select B.District_ID, B.District_Name from employee_table as A
// inner join Districts as B on A.district_id = B.District_ID where StateCode = @state ORDER BY B.District_Name asc ";
string str = @" select d.District_ID , d.District_Name from districts d where d.StateCode='22' ORDER BY d.District_Name asc ";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("state", bl.State)
};
ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable();
db_maria_connection db = new db_maria_connection();
rd = db.executeSelectQuery(str, pm);
return(rd);
}
public ReturnClass.ReturnDataTable office(bl_emp bl)
{
ReturnClass.ReturnDataTable rt = new ReturnClass.ReturnDataTable();
db_maria_connection db = new db_maria_connection();
string st = " select os.NewOfficeCode, os.OfficeName from office os where os.DistrictCodeNew=@DistrictCodeNew and os.StateCode=@StateCode and os.BaseDeptCode=@BaseDeptCode ";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("DistrictCodeNew", bl.DistrictCodeNew),
new MySqlParameter("StateCode", bl.StateCode),
new MySqlParameter("BaseDeptCode", bl.Department)
};
rt = db.executeSelectQuery(st, pm);
return(rt);
}
public void bind_Count()
{
bl.Office_map_id = Session["EmpMapID"].ToString();
//bl.RequestStatus = "REG"; // It will give the Total RTI
//rt = dl.GetRequestCount(bl);
//
//bl.RequestStatus = "PEN";
//rt = dl.GetRequestCount(bl);
//
bl.RequestStatus = "CLT";
rt = dl.GetRequestCount(bl);
lbl_Request_Registered.Text = rt.table.Rows[0]["total"].ToString();
lbl_Request_DisposedOf.Text = rt.table.Rows[0]["complete"].ToString();
lbl_Request_Pending.Text = rt.table.Rows[0]["pending"].ToString();
}
public void bind_district() // user district
{
bl_RTI_Request bl = new bl_RTI_Request();
dl_RTI_Request dl = new dl_RTI_Request();
ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable();
ddl_district.Items.Clear();
bl.State = DDL_State.SelectedValue;
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.Add(new ListItem("Choose District", "0"));
}
public ReturnClass.ReturnDataTable countMappedEmp(bl_Dio bl)
{
string str = "", where = " where 1 = 1 ";
try
{
List<MySqlParameter> pm = new List<MySqlParameter>();
if (bl.District != "0" && bl.District != null && bl.District != "" && bl.District != "Select")
{
MySqlParameter ba = new MySqlParameter("district", bl.District);
pm.Add(ba);
where += " and district_id_ofc = @district ";
}
if (bl.Role == "4" )
{
MySqlParameter ba = new MySqlParameter("officeLevelType", bl.Officelevelcode);
pm.Add(ba);
where += " and ol.OfficeLevelType = @officeLevelType ";
}
if ( bl.Role == "5")
{
MySqlParameter ba = new MySqlParameter("office_id", bl.Officeid);
pm.Add(ba);
where += " and ofc.NewOfficeCode = @office_id ";
}
//str = @" select count(office_mapping_id) as office_map_count from emp_office_mapping " + where;
str = @"select count(office_mapping_id) as office_map_count from emp_office_mapping as emp_map
inner join office ofc on ofc.NewOfficeCode = emp_map.office_id
inner join districts dic on dic.StateCode=ofc.StateCode and dic.district_id = ofc.DistrictCodeNew
inner join basedepartment bd on bd.dept_id = ofc.BaseDeptCode
inner join officelevel ol on ol.OfficeLevelCode = ofc.OfficeLevel and
ol.StateCode= ofc.StateCode and ol.BaseDeptCode=ofc.BaseDeptCode " + where;
// emp_map.district_id_ofc='11' and ol.OfficeLevelType='00' "
rd = db.executeSelectQuery(str, pm.ToArray());
}
catch (Exception ex)
{
Gen_Error_Rpt.Write_Error("../dio/dl_Dio/Bind_Grid log.txt");
}
return rd;
//string str = "select count(office_mapping_id) as office_map_count from emp_office_mapping";
//rd = db.executeSelectQuery(str);
//return rd;
}
public ReturnClass.ReturnDataTable office(bl_employee_action bl)
{
string str = "", where = " where 1 = 1 ";
try
{
List <MySqlParameter> pm = new List <MySqlParameter>();
if (bl.District_id_ofc != "0" && bl.District_id_ofc != null && bl.District_id_ofc != "" && bl.District_id_ofc != "Select")
{
MySqlParameter ba = new MySqlParameter("dstrict", bl.District_id_ofc);
pm.Add(ba);
where += " and ofc.DistrictCodeNew = @dstrict ";
}
if (bl.Base_department_id != "" && bl.Base_department_id != null && bl.Base_department_id != "0" && bl.Base_department_id != "Select")
{
MySqlParameter ca = new MySqlParameter("bs_dept", bl.Base_department_id);
pm.Add(ca);
where += " and ofc.BaseDeptCode = @bs_dept ";
}
if (bl.Office_level_id != "0" && bl.Office_level_id != null && bl.Office_level_id != "" && bl.Office_level_id != "Select")
{
MySqlParameter da = new MySqlParameter("ofc_lvl", bl.Office_level_id);
pm.Add(da);
where += " and ofc.OfficeLevel = @ofc_lvl ";
}
if (bl.Office_category != "0" && bl.Office_category != null && bl.Office_category != "" && bl.Office_category != "Select")
{
MySqlParameter fa = new MySqlParameter("category", bl.Office_category);
pm.Add(fa);
where += " and ofc.OfficeCategory=@category ";
}
str = @" select ofc.NewOfficeCode , dic.District_Name_En as district, bd.dept_name as basedept, ol.OfficeLevelName as ofclvl,
ofc.OfficeName as ofice, ofc.OfficeAddress as address, ofc.ContactNo as mobile, ofc.Email as email, ofc.OfficeURL as ofc_url
from office ofc
inner join districts dic on dic.StateCode=ofc.StateCode and dic.district_id = ofc.DistrictCodeNew
inner join basedepartment bd on bd.dept_id = ofc.BaseDeptCode
inner join officelevel ol on ol.OfficeLevelCode = ofc.OfficeLevel and ol.StateCode= ofc.StateCode and ol.BaseDeptCode=ofc.BaseDeptCode" + where + " order by ofc.NewOfficeCode asc";
rd = db.executeSelectQuery(str, pm.ToArray());
}
catch (Exception ex)
{
Gen_Error_Rpt.Write_Error("../dio/dl_Dio/Bind_Grid log.txt");
}
return(rd);
}
public ReturnClass.ReturnDataTable GetTotalEmpMapInGrid(bl_report bl)
{
string str = "", where = " where 1 = 1 ";
try
{
List <MySqlParameter> pm = new List <MySqlParameter>();
if (bl.District != "0" && bl.District != null && bl.District != "")
{
MySqlParameter ba = new MySqlParameter("district", bl.District);
pm.Add(ba);
where += " and A.district_id_ofc = @district ";
}
if (bl.Role == "4")
{
MySqlParameter ba = new MySqlParameter("officeLevelType", bl.Officelevelcode);
pm.Add(ba);
where += " and E.OfficeLevelType = @officeLevelType ";
}
if (bl.Role == "5")
{
MySqlParameter ba = new MySqlParameter("office_id", bl.Officeid);
pm.Add(ba);
where += " and C.NewOfficeCode = @office_id ";
}
str = @"select distinct A.office_mapping_id as mapping_id, A.emp_code as EmployeeCode, B.Name_en as EmpName, C.OfficeName as officeName,
D.dept_name as DeptName , E.OfficeLevelName as OfficeLevelName , F.District_Name_En as DistName_En ,
G.OfficeCategoryName as OfficeCategoryName, A.user_id as UserID , H.DisplayName_en as ChangeTypeName, IF(A.active = 'Y', 'YES', 'No') as activeStatus
from emp_office_mapping as A
inner join employee_table as B on A.emp_code = B.emp_id
inner join office as C on A.office_id = C.NewOfficeCode
inner join basedepartment as D on A.base_department_id = D.dept_id
inner join officelevel as E on A.office_level_id = E.OfficeLevelCode and A.base_department_id=E.BaseDeptCode
inner join districts as F on A.district_id_ofc = F.District_ID
inner join officecategory as G on A.office_category = G.OfficeCategoryCode
inner join ddl_list as H on A.charge_type = H.DDL_Name_Value " + where + " order by A.office_mapping_id ";
rd = db.executeSelectQuery(str, pm.ToArray());
}
catch (Exception ex)
{
Gen_Error_Rpt.Write_Error("../dio/dl_Dio/Bind_Grid log.txt");
}
return(rd);
}
public void bind_grid()
{
ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
Notice_Entry ne = new Notice_Entry();
try
{
ne.pending = "P";
//ne.district_id = Session["Dist_Code"].ToString();
dt = dl.pending_for_approval(ne);
//if (dt.table.Rows.Count > 0)
//{
// GridView1.DataSource = dt.table;
// GridView1.DataBind();
//}
//else
//{
// btnapprove.Visible = false;
// }
if (dt.table.Rows.Count > 0)
{
GridView1.DataSource = dt.table;
GridView1.DataBind();
double c = Convert.ToInt32(dt.table.Rows.Count.ToString());
double cal = Math.Ceiling(c / 30);
if (cal == 0)
{
cal = 1;
}
lblTotalBoilers.Text = "Total Records : " + dt.table.Rows.Count.ToString() + " (Page : 1 to " + cal + ")";
}
else
{
btnapprove.Visible = false;
GridView1.DataSource = dt.table;
GridView1.DataBind();
lblTotalBoilers.Text = "Total Records : " + dt.table.Rows.Count.ToString();
}
}
catch (Exception ex)
{
Gen_Error_Rpt.Write_Error("admin_NewsEdit_List_bind_grid()", ex);
Utilities.MessageBoxShow(ex.Message);
}
}
public ReturnClass.ReturnDataTable countOffice(bl_report bl)
{
string str = "", where = " where 1 = 1 ";
try
{
List <MySqlParameter> pm = new List <MySqlParameter>();
if (bl.State_id != "" && bl.State_id != null && bl.State_id != "0" && bl.State_id != "Select")
{
MySqlParameter da = new MySqlParameter("state", bl.State_id);
pm.Add(da);
where += " and ofc.StateCode= @state ";
}
if (bl.District != "0" && bl.District != null && bl.District != "" && bl.District != "Select")
{
MySqlParameter ba = new MySqlParameter("district", bl.District);
pm.Add(ba);
where += " and ofc.DistrictCodeNew = @district ";
}
if (bl.Role == "4")
{
MySqlParameter ba = new MySqlParameter("officeLevelType", bl.Officelevelcode);
pm.Add(ba);
where += " and ol.OfficeLevelType = @officeLevelType ";
}
if (bl.Role == "5")
{
MySqlParameter ba = new MySqlParameter("officeid", bl.Officeid);
pm.Add(ba);
where += " and ofc.NewOfficeCode = @officeid ";
}
str = @" select count(*) as office_count from office ofc
inner join districts dic on dic.StateCode=ofc.StateCode and dic.district_id = ofc.DistrictCodeNew
inner join basedepartment bd on bd.dept_id = ofc.BaseDeptCode
inner join officelevel ol on ol.OfficeLevelCode = ofc.OfficeLevel and ol.StateCode= ofc.StateCode and ol.BaseDeptCode=ofc.BaseDeptCode "
+ where;
rd = db.executeSelectQuery(str, pm.ToArray());
}
catch (Exception ex)
{
Gen_Error_Rpt.Write_Error("../dio/dl_Dio/Bind_Grid log.txt");
}
return(rd);
}
public void bind_GridView()
{
ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
bl.NoticeID = txt_notice_id.Text;
bl.Header = txt_Subject.Text;
bl.Validity_From = getDate(txt_FromDate.Text);
bl.Validity_To = getDate(txt_ToDate.Text);
if (bl.Validity_From != "" && bl.Validity_To == "")
{
DateTime dtt = Convert.ToDateTime(bl.Validity_From);
DateTime dt1 = dtt.AddDays(1);
bl.Next_date = dt1.ToString("yyyy-MM-dd");
}
bl.KeywordSearch = txt_search.Text;
bl.District_id = ddl_district.SelectedValue;
bl.Base_dept_id = ddl_department.SelectedValue;
bl.Office_id = ddl_office.SelectedValue;
//bl.Todaydate = DateTime.Now;
dt = dl.Get_NoticeRecords(bl);
int row = dt.table.Rows.Count;
int page;
if (row % 15 == 0)
{
page = row / 15;
}
else
{
page = row / 15;
page = page + 1;
}
if (Session["language"].ToString() == "en-GB")
{
lbl_count.Text = "Total Notice = " + row.ToString() + " and Total page = " + page.ToString() + "";
}
else
{
lbl_count.Text = "कुल सूचना = " + row.ToString() + " और कुल पेज = " + page.ToString() + "";
}
// lbl_count.Text = "Total Records = " + row.ToString() + " and Total page = " + page.ToString() + "";
GridView1.DataSource = dt.table;
GridView1.DataBind();
}
public ReturnClass.ReturnDataTable select_officedtl(bl_report bl)
{
string str = @"select oc.OfficeCategoryName as ofc_cat,oc.OfficeCategoryCode as ofc_cat_code,
ol.OfficeLevelCode as code, ol.OfficeLevelName as ol_name,
ofc.OfficeName as nameofc, ofc.NewOfficeCode as OfficeCode
from office ofc
inner join officecategory oc on oc.OfficeCategoryCode=ofc.OfficeCategory
inner join officelevel ol on ol.BaseDeptCode= ofc.BaseDeptCode and ol.OfficeLevelCode = ofc.OfficeLevel
where ofc.NewOfficeCode=@ofclvl ";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("ofclvl", bl.Officeid)
};
rd = db.executeSelectQuery(str, pm);
return(rd);
}
public ReturnClass.ReturnDataTable showEmployee(bl_report bl)
{
ReturnClass.ReturnDataTable rt = new ReturnClass.ReturnDataTable();
db_maria_connection db = new db_maria_connection();
string st = @"SELECT et.emp_id,et.Name_en,et.mobile_no,et.email_id,(select s.state_name_e from state s where s.state_id = et.state_id)state_name_e,
(select d.district_nm_e from district d where d.district_id = et.district_id)district_nm_e,
(select bd.dept_name from basedepartment bd where bd.dept_id = et.base_department_id)dept_name,
(select o.OfficeName from office o where o.NewOfficeCode=et.NewOfficecode)OfficeName,
et.state_id,et.district_id,et.base_department_id,et.NewOfficeCode
FROM employee_table et";
rt = db.executeSelectQuery(st);
return(rt);
}
public void Bind_Employee()
{
bl1.District_id = DDL_District.SelectedItem.Value;
bl1.Department_id = DDL_Department.SelectedItem.Value;
bl1.Office_id = DDL_Office.SelectedItem.Value;
dt = dl1.Get_Employee(bl1);
ddl_employee.DataSource = dt.table;
ddl_employee.DataValueField = "emp_id";
ddl_employee.DataTextField = "Name_en";
ddl_employee.DataBind();
ddl_employee.Items.Insert(0, new ListItem("--- Select employee ---", "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"));
}
//Detail of unique RTI
public ReturnClass.ReturnDataTable GetRTIDetails(bl_employee_action bl1)
{
ReturnClass.ReturnDataTable rt = new ReturnClass.ReturnDataTable();
db_maria_connection db = new db_maria_connection();
string st = @"select result_description, FileName, FileDescription, IsMeetingFix, IsAdditionalFees, FeesAmount
from rti_data_for_applicant as rd
where rd.rti_id=@Rti_id";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("Rti_id", bl1.Rti_id)
};
rt = db.executeSelectQuery(st, pm);
return(rt);
}
public ReturnClass.ReturnDataTable select_admin_info(bl_Dio bl)
{
// string str = @"select lo.UserID, emp.Name_en, emp.state_id,emp.base_department_id, emp.NewOfficeCode, emp.district_id,lo.RollID from login lo
//inner join employee_table emp on emp.emp_id=lo.LoginID
// where lo.UserID=@user"; // Commented by Naveen on 28-Aug_2017 and added below
string str = @"select lo.UserID, emp.Name_en, emp.state_id,emp.base_department_id, emp.NewOfficeCode, emp.district_id,emp_map.role_id RollID from login lo
inner join employee_table emp on emp.emp_id=lo.LoginID
inner join emp_office_mapping emp_map on emp_map.emp_code=lo.LoginID
where lo.UserID=@user";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("user", bl.Userid)
};
rd = db.executeSelectQuery(str, pm);
return(rd);
}
public ReturnClass.ReturnDataTable GetEmployeeData(bl_empMap bl)
{
//string str = @"select emp_id, Name_en from employee_table A where A.base_department_id= @base_department_id and A.district_id=@district_id_ofc and Active='Y' order by Name_en asc";
string str = @"select emp_id, Name_en from employee_table A where Active='Y' order by Name_en asc";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("base_department_id", bl.Base_department_id),
new MySqlParameter("district_id_ofc", bl.District_id_ofc)
};
ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable();
db_maria_connection db = new db_maria_connection();
// rd = db.executeSelectQuery(str, pm);
rd = db.executeSelectQuery(str);
return(rd);
}
protected void ddl_employee1_SelectedIndexChanged(object sender, EventArgs e)
{
bl1.Office_mapping_id = ddl_employee1.SelectedValue;
rd = dl1.permission_employee(bl1);
if (rd.table.Rows.Count > 0)
{
div_permission.Visible = true;
//approve , pm.review as review, pm.dispose as dispose, pm.forward as forward , pm.reject as reject
rdb_approve.SelectedValue = rd.table.Rows[0]["approve"].ToString();
rdb_review.SelectedValue = rd.table.Rows[0]["review"].ToString();
rdb_dispose.SelectedValue = rd.table.Rows[0]["dispose"].ToString();
rdb_forward.SelectedValue = rd.table.Rows[0]["forward"].ToString();
rdb_reject.SelectedValue = rd.table.Rows[0]["reject"].ToString();
}
// bind_employee();
}
public void bind_grd_Action()
{
string key = System.Configuration.ConfigurationManager.AppSettings["EncKey"].ToString();
// string key = "mk";
Utilities ut = new Utilities();
string sas = Server.UrlDecode(Request.QueryString["rtiid"].ToString());
sas = sas.Replace(" ", "+");
string decrypt_query_string = ut.Decrypt_AES(sas, key);
bl1.Rti_id = decrypt_query_string;
// bl1.Rti_id = Request.QueryString["rtiid"];
rd = dl1.bind_action_grid(bl1);
grd_Action.DataSource = rd.table;
grd_Action.DataBind();
}
public ReturnClass.ReturnDataTable Get_Office_For_Notice(Notice_Entry bl)
{
string strquery = @"SELECT NewOfficeCode, OfficeName FROM office WHERE
office.BaseDeptCode=@dept AND office.DistrictCodeNew=@district
order by OfficeName ";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("dept", bl.Base_dept_id),
new MySqlParameter("district", bl.District_id)
};
ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable();
db_maria_connection db = new db_maria_connection();
rd = db.executeSelectQuery(strquery, pm);
return(rd);
}
public void bind_district()
{
ddl_district.Items.Clear();
bl.Statecode = ddl_state.SelectedValue;
rd = dl.BindDistrict(bl);
ddl_district.DataSource = rd.table;
ddl_district.DataTextField = "District_Name_En";
ddl_district.DataValueField = "district_id";
ddl_district.Items.Add(new ListItem("Choose District", "0"));
ddl_district.Items.Add(new ListItem("OTHER", "00"));
ddl_district.DataBind();
if (ddl_state.SelectedValue == "22")
{
ddl_district.SelectedValue = "11";
}
}
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 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 OfficeLevelBind1()
{
bl_empMap bl = new bl_empMap();
dl_empMap dl = new dl_empMap();
bl.Role_id = Session["role"].ToString();
bl.Base_department_id = ddl_department1.SelectedValue;
ReturnClass.ReturnDataTable dt = dl.Get_OfficeLevel(bl);
ddl_office_level1.DataSource = dt.table;
ddl_office_level1.DataTextField = "Office_level";
ddl_office_level1.DataValueField = "olc";
ddl_office_level1.DataBind();
ddl_office_level1.Items.Insert(0, new ListItem("--Select Office Level--", "0"));
}
