public List <ApproveVacancyBO> returnRecord(int id) { List <ApproveVacancyBO> vbolist = new List <ApproveVacancyBO>(); SqlConnection conn = d.logindal(); SqlCommand cmd = new SqlCommand("select * from E_Data_Vacancy where Vac_VacancyID=" + id, conn); SqlDataReader dr; dr = cmd.ExecuteReader(); while (dr.Read()) { ApproveVacancyBO vbo = new ApproveVacancyBO(); vbo.Vac_VacancyID = (int)dr[0]; vbo.Vac_NoOfPosition = (int)dr[1]; vbo.Vac_skill = dr[2].ToString(); vbo.Vac_Experience = (int)dr[3]; vbo.Vac_location = dr[4].ToString(); vbo.Vac_BusinessDomain = dr[5].ToString(); vbo.Vac_RequiredByDate = dr[6].ToString();; vbo.Vac_Status = dr[7].ToString(); vbolist.Add(vbo); } conn.Close(); return(vbolist); }
public List <ApproveVacancyBO> approve(int emp_id) { SqlConnection conn = d.logindal(); SqlCommand cmd = new SqlCommand("select Emp_EmployeeID from E_Data_Employee where Emp_UnitHeadID=" + emp_id, conn); SqlDataReader dr = cmd.ExecuteReader(); List <int> empidlist = new List <int>(); while (dr.Read()) { int temp = (int)dr[0]; empidlist.Add(temp); } cmd.Dispose(); dr.Close(); string empidstring = ""; if (empidlist.Count > 0) { empidstring = empidlist[0] + ""; for (int i = 1; i < empidlist.Count; i++) { empidstring = empidstring + "," + empidlist[i]; } string qry = "select VR_VacancyRequestID from E_Link_Vacancy_request where VR_EmployeeID IN (" + empidstring + ")"; cmd = new SqlCommand(qry, conn); dr = cmd.ExecuteReader(); List <int> vacancy_list = new List <int>(); while (dr.Read()) { int temp = (int)dr[0]; vacancy_list.Add(temp); } cmd.Dispose(); dr.Close(); string vacid_string = ""; if (vacancy_list.Count > 0) { vacid_string = vacancy_list[0] + ""; for (int i = 1; i < vacancy_list.Count; i++) { vacid_string = vacid_string + "," + vacancy_list[i]; } string query = "select * from E_Data_Vacancy where Vac_IsDeleted <> 1 and Vac_ApprovalStatus = 'Pending' and Vac_VacancyID IN (" + vacid_string + ")"; cmd = new SqlCommand(query, conn); dr = cmd.ExecuteReader(); List <ApproveVacancyBO> vbolist = new List <ApproveVacancyBO>(); while (dr.Read()) { ApproveVacancyBO vbo = new ApproveVacancyBO(); vbo.Vac_VacancyID = (int)dr[0]; vbo.Vac_NoOfPosition = (int)dr[1]; vbo.Vac_skill = dr[2].ToString(); vbo.Vac_Experience = (int)dr[3]; vbo.Vac_location = dr[4].ToString(); vbo.Vac_BusinessDomain = dr[5].ToString(); vbo.Vac_RequiredByDate = dr[6].ToString();; vbo.Vac_Status = dr[7].ToString(); vbolist.Add(vbo); } conn.Close(); return(vbolist); } else { conn.Close(); } return(null); } conn.Close(); return(null); }