private void GetCompetences(FreelancerProfileVM fp)//Metod för att hämta kompetenser på inskickad freelancerVM och lagra dessa i dennes kompetens-lista { //Kan inte göra Linq här då tabellen competence_resume inte finns i doorinDBEntities.. competence c; string sql = "SELECT competence.competence_id, name from competence_resume INNER JOIN competence on competence_resume.competence_id = competence.competence_id WHERE resume_id = @resume_id"; try { using (SqlConnection conn = new SqlConnection(GetBuilder().ConnectionString)) { conn.Open(); using (SqlCommand command = new SqlCommand(sql, conn)) { command.Parameters.AddWithValue("resume_id", fp.Resume_id); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { c = new competence() { competence_id = (reader.GetInt32(0)), name = (reader.GetString(1)) }; fp.CompetencesList.Add(c); } } } } } catch (SqlException ex) { //TODO: Gör något med felmeddelandet throw; } }
private void GetCompetenceList(FullResume fullResume) //Metod för att hämta teknologier på inskickad freelancerVM och lagra dessa i en lista { string sql = "SELECT competence_id, name FROM competence"; competence c; 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()) { c = new competence() { competence_id = (reader.GetInt32(0)), name = (reader.GetString(1)) }; fullResume.Competences.Add(c); } } } } } catch (Exception) { // gör något med felmeddelandet throw; } }
public static void InsertNewSkill(String name, String description, int level, Guid userId) { bindedinEntities bie = SingletonEntities.Instance; var existing = from c in bie.competences where c.description.Equals(description) where c.name.Equals(name) select c; if (existing.Count() == 0) { competence comp = new competence { name = name, description = description }; bie.competences.AddObject(comp); bie.SaveChanges(); } var idComp = from c in bie.competences where c.name.Equals(name) where c.description.Equals(description) select c.id; user_competence uc = new user_competence { user = userId, competence = idComp.First(), level = level, }; bie.user_competence.AddObject(uc); bie.SaveChanges(); }
public ActionResult DeleteConfirmed(int id) { competence competence = db.competence.Find(id); db.competence.Remove(competence); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "competence_id,name,core")] competence competence) { if (ModelState.IsValid) { db.Entry(competence).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(competence)); }
protected void idEnseignant_click(object sender, EventArgs e) { try { competence c = new competence(); } catch (Exception ex) { } }
public ActionResult Create([Bind(Include = "competence_id,name,core")] competence competence) { if (ModelState.IsValid) { db.competence.Add(competence); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(competence)); }
public ActionResult Create([Bind(Include = "competence_Id,competences,scale, freelancer_Id, category_Id, type_of_competence")] competence competence, int?id) { if (ModelState.IsValid) { competence.freelancer_id = id; db.competence.Add(competence); db.SaveChanges(); return(RedirectToAction("Create")); } return(View(competence)); }
public ActionResult AddMyCompetences(competence competence) { FullResumeOperations resumeOperations = new FullResumeOperations(); var fullResume = resumeOperations.GetFullResumeById(competence.resume_id); fullResume.SelectedCompetenceId = competence.competence_id; if (fullResume.MyCompetences.Count == 0) { for (int i = 0; i < fullResume.Competences.Count; i++) { if (fullResume.Competences[i].competence_id == fullResume.SelectedCompetenceId) { fullResume.MyCompetences.Add(fullResume.Competences[i]); int lastComp = fullResume.MyCompetences.Count; lastComp--; resumeOperations.AddMyCompetences(fullResume.MyCompetences[lastComp].competence_id, fullResume.Resume_id); resumeOperations.GetTechnologyList(fullResume); int num = db.SaveChanges(); return(Json(num)); } } } else { foreach (var comp in fullResume.MyCompetences) { if (comp.competence_id == fullResume.SelectedCompetenceId) { // Visa meddelande "Du har redan lagt till den här kompetensen." } else { for (int i = 0; i < fullResume.Competences.Count; i++) { if (fullResume.Competences[i].competence_id == fullResume.SelectedCompetenceId) { fullResume.MyCompetences.Add(fullResume.Competences[i]); int lastComp = fullResume.MyCompetences.Count; lastComp--; resumeOperations.AddMyCompetences(fullResume.MyCompetences[lastComp].competence_id, fullResume.Resume_id); resumeOperations.GetTechnologyList(fullResume); int num = db.SaveChanges(); return(Json(num)); } } } } } return(View(fullResume)); }
public ActionResult RemoveMyCompetences(competence competence) { FullResumeOperations resumeOperations = new FullResumeOperations(); resumeOperations.RemoveMyCompetences(competence.competence_id, competence.resume_id); // CV:t hämtas för att listan med kompetenser ska uppdateras FullResume fullResume = resumeOperations.GetFullResumeById(competence.resume_id); int num = db.SaveChanges(); return(Json(num)); }
// GET: competences/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } competence competence = db.competence.Find(id); if (competence == null) { return(HttpNotFound()); } return(View(competence)); }
public List <competence> GetAllCompetences() { List <competence> CList = new List <competence>(); var competencelist = (from c in db.competence select new { c.name, c.competence_id }).ToList(); foreach (var c in competencelist) { competence item = new competence(); item.name = c.name; item.competence_id = c.competence_id; CList.Add(item); } return(CList); }
// GET: competences/Edit/5 public ActionResult Edit(int?id, int?id2) { // if (id == null) // { // return new HttpStatusCodeResult(HttpStatusCode.BadRequest); // } // var competenceVM = new competenceVM // { // competence = db.competence.Include(i => i.category).First(i => i.competence_Id == id) // }; // if (competenceVM.competence == null) // { // return HttpNotFound(); // } // var catList = db.category.ToList(); // competenceVM.Allcategories = catList.Select(o => new SelectListItem // { // Text = o.type_of_competence, // Value = o.category_Id.ToString() // }); // ViewBag.freelancer_Id = new SelectList(db.Freelancer, "freelancer_Id", "Firstname", competenceVM.competence.freelancer_id); // return View(competenceVM); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } competence competence = db.competence.Find(id); if (competence == null) { return(HttpNotFound()); } return(View(competence)); }
private void GetMyCompetences(FullResume fullResume)//Metod för att hämta kompetenser på inskickad freelancerVM och lagra dessa i en lista { fullResume.MyCompetences.Clear(); competence c; string sql = "SELECT competence.competence_id, resume_id, name from competence_resume " + "INNER JOIN competence on competence_resume.competence_id = competence.competence_id " + "WHERE resume_id = @resume_id"; 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()) { c = new competence() { competence_id = (reader.GetInt32(0)), resume_id = (reader.GetInt32(1)), name = (reader.GetString(2)) }; fullResume.MyCompetences.Add(c); } } } } } catch (Exception) { //gör något med felmeddelandet throw; } }