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