public void insertdal(string[] items, string plist)
{
Data_Recruitment r = new Data_Recruitment();
SqlConnection con = new SqlConnection(c);
con.Open();
string queryStr = "insert into E_Data_Recruitment(Rec_PlacementConsultantID,Rec_RequesteddDate) values(@plist,getdate())";
SqlCommand com = new SqlCommand(queryStr, con);
com.Parameters.Add("@plist", SqlDbType.Int).Value = plist;
com.ExecuteNonQuery();
com.Dispose();
//con.Open();
string queryStr2 = "select max(Rec_RecruitmentRequestID) from E_Data_Recruitment where Rec_IsDeleted=0";
SqlCommand com2 = new SqlCommand(queryStr2, con);
int recid = (int)com2.ExecuteScalar();
com2.Dispose();
foreach (string s in items)
{
//con.Open();
string queryStr3 = "update E_Data_Vacancy set Vac_RecruitmentRequestID=@rid where Vac_VacancyID=@vacid";
SqlCommand com3 = new SqlCommand(queryStr3, con);
com3.Parameters.Add("@rid", SqlDbType.Int).Value = recid;
com3.Parameters.Add("@vacid", SqlDbType.Int).Value = s;
com3.ExecuteNonQuery();
com3.Dispose();
}
con.Close();
}
public List <int> reciddropdal()
{
SqlConnection con = new SqlConnection(c);
con.Open();
List <int> dum = new List <int>();
string queryStr = "Select distinct(Vac_RecruitmentRequestID) from E_Data_Vacancy where Vac_IsDeleted=0 and Vac_RecruitmentRequestID is not null order by Vac_RecruitmentRequestID";
SqlCommand com = new SqlCommand(queryStr, con);
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
Data_Recruitment d = new Data_Recruitment();
d.Rec_RecruitmentRequestID = dr.GetInt32(0);
dum.Add(d.Rec_RecruitmentRequestID);
}
con.Close();
return(dum);
}
