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