public static List<QualificationModel> GetQualificationDetails()
{
SqlConnection con = DBUtils.getDBConnection();
con.Open();
SqlCommand command = new SqlCommand("select qualification_id, qualification, type from dbo.Qualification;", con);
SqlDataReader reader = command.ExecuteReader();
List<QualificationModel> qualificationList = new List<QualificationModel>();
while (reader.Read())
{
QualificationModel qual = new QualificationModel();
qual.qualification_id = Convert.ToInt32(reader[0]);
qual.qualification = Convert.ToString(reader[1]);
qual.type = Convert.ToString(reader[2]);
qualificationList.Add(qual);
}
con.Close();
return qualificationList;
}
public static List<QualificationModel> GetCandidateEducationDetails(int user_id)
{
SqlConnection con = DBUtils.getDBConnection();
con.Open();
SqlCommand command = new SqlCommand(" select graduation, post_graduation from dbo.Applicant where candidate_id=" + user_id + ";", con);
command.ExecuteNonQuery();
Dictionary<string, string> idToName = GetQualificationsIdToName();
List<QualificationModel> qualifications = new List<QualificationModel>();
SqlDataReader reader = command.ExecuteReader();
if(reader.Read())
{
string ug = reader.GetString(0);
string pg = reader.GetString(1);
foreach (var item in ug.Split(','))
{
if (item.Length == 0)
continue;
QualificationModel model = new QualificationModel();
model.qualification_id = Convert.ToInt32(item);
model.qualification = idToName[item];
model.type = "UG";
qualifications.Add(model);
}
foreach (var item in pg.Split(','))
{
if(item.Length == 0)
continue;
QualificationModel model = new QualificationModel();
model.qualification_id = Convert.ToInt32(item);
model.qualification = idToName[item];
model.type = "PG";
qualifications.Add(model);
}
}
reader.Close();
con.Close();
return qualifications;
}
