public List <int> pciddropdal(string loc)
{
SqlConnection con = new SqlConnection(c);
con.Open();
List <int> dum = new List <int>();
string queryStr = "Select * from E_Data_Placement_Consultant where PC_Location='" + loc + "'and PC_IsDeleted=0 order by PC_PlacementConsultantID";
SqlCommand com = new SqlCommand(queryStr, con);
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
Data_Placement_Consultant d = new Data_Placement_Consultant();
d.PC_PlacementConsultantID = dr.GetInt32(0);
dum.Add(d.PC_PlacementConsultantID);
}
con.Close();
return(dum);
}
public List <int> piddropdal()
{
SqlConnection con = new SqlConnection(c);
con.Open();
List <int> dum = new List <int>();
string queryStr = "Select distinct(Rec_PlacementConsultantID) from E_Data_Recruitment where Rec_IsDeleted=0 order by Rec_PlacementConsultantID";
SqlCommand com = new SqlCommand(queryStr, con);
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
Data_Placement_Consultant d = new Data_Placement_Consultant();
d.PC_PlacementConsultantID = dr.GetInt32(0);
dum.Add(d.PC_PlacementConsultantID);
}
con.Close();
return(dum);
}
