private void GetTechnology(FreelancerProfileVM fp) //Metod för att hämta teknologier på inskickad freelancerVM och lagra dessa i en dennes teknologi-lista { try { var list = (from tr in db.technology_resume join te in db.technology on tr.technology_id equals te.technology_id where tr.resume_id == fp.Resume_id select new { te.technology_id, te.name, tr.rank, tr.core_technology, te.competence_id }).OrderByDescending(o => o.rank).OrderByDescending(o => o.core_technology).ToList(); foreach (var item in list) { FullTechnology ft = new FullTechnology(); ft.technology_id = item.technology_id; ft.name = item.name; ft.rank = item.rank; ft.core_technology = item.core_technology; ft.competence_id = item.competence_id; fp.TechnologysList.Add(ft); } } catch (SqlException ex) { //TODO: gör något med felmeddelandet throw; } }
public void GetMyTechnologies(FullResume fullResume) //Metod för att hämta teknologier på inskickad freelancerVM och lagra dessa i en lista { fullResume.MyTechnologies.Clear(); string sql = "SELECT technology.technology_id, technology.name, technology_resume.rank, " + "technology_resume.core_technology, technology.competence_id from technology_resume " + "INNER JOIN technology on technology_resume.technology_id = technology.technology_id " + "WHERE resume_id = @resume_id"; FullTechnology t; try { using (SqlConnection conn = new SqlConnection(GetBuilder().ConnectionString)) { conn.Open(); using (SqlCommand command = new SqlCommand(sql, conn)) { command.Parameters.AddWithValue("resume_id", fullResume.Resume_id); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { t = new FullTechnology() { technology_id = (reader.GetInt32(0)), name = (reader.GetString(1)), rank = (reader.GetInt32(2)), core_technology = (reader.GetBoolean(3)), competence_id = (reader.GetInt32(4)), }; fullResume.MyTechnologies.Add(t); } } } } } catch (Exception) { // gör något med felmeddelandet throw; } }