public ReturnClass.ReturnDataTable Get_Office(bl_user_login bl) { string str; string where = ""; if (bl.Role == "4") { where += " and C.OfficeLevelType = '00' "; } str = @" SELECT distinct B.NewOfficeCode, B.OfficeName FROM employee_table as A inner join office as B on A.NewOfficeCode = B.NewOfficeCode and A.base_department_id=B.BaseDeptCode inner join officelevel as C on B.OfficeLevel = C.OfficeLevelCode and B.BaseDeptCode=C.BaseDeptCode where A.district_id=@district_id and A.base_department_id=@department_id " + where + " order by B.OfficeName"; MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("district_id", bl.District_id), new MySqlParameter("department_id", bl.Department_id) }; ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable(); db_maria_connection db = new db_maria_connection(); if ( bl.Role == "5") { str = "select NewOfficeCode,OfficeName from office o where o.NewOfficeCode=@newoffice"; pm = new MySqlParameter[] { new MySqlParameter("newoffice", bl.Office_id) }; } rd = db.executeSelectQuery(str, pm); return(rd); }
public ReturnClass.ReturnDataTable get_role(bl_user_login bl) { string where = ""; if (bl.Role == "4" || bl.Role == "5") { where += " where Role_id='3' "; // For dip and nodel select only employee } string str = @" select Role_id, RoleName from role_table " + where; rd = db.executeSelectQuery(str); 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 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 Get_Employee(bl_user_login bl) { string str = @"select e.emp_id , e.Name_en from employee_table e where e.emp_id not in (select l.LoginID from login l) and e.district_id=@district_id and e.base_department_id=@department_id and e.NewOfficeCode=@office_id order by e.Name_en "; MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("district_id", bl.District_id), new MySqlParameter("department_id", bl.Department_id), new MySqlParameter("office_id", bl.Office_id) }; ReturnClass.ReturnDataTable rd = new ReturnClass.ReturnDataTable(); db_maria_connection db = new db_maria_connection(); rd = db.executeSelectQuery(str, pm); return(rd); }