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