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