public ActionResult DeleteConfirmed(int id)
{
CVViewModel cVViewModel = db.CVViewModels.Find(id);
db.CVViewModels.Remove(cVViewModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void TestMappintDomainModelToViewModel()
{
CVMapper mapper = new CVMapper();
Utilisateur utilisateur = new UtilisateurGraphRepository("Graph_CV", "CVs").GetOne("7b495fbb-6346-47e8-84dc-84fd3d2fc354");
CVViewModel cVViewModel = mapper.Map(utilisateur);
Assert.IsNotNull(cVViewModel);
Assert.AreEqual(utilisateur.Conseiller.Fonction.Description, cVViewModel.Fonction);
}
// GET: CVs
public ActionResult Index()
{
CVViewModel cvvm = new CVViewModel();
List <CV> ListOfCv = new List <CV>();
var freelancercv = db.CV.Include(c => c.Freelancer);
//var listOfProfessions = ();
return(View(freelancercv.ToList()));
}
public ActionResult Edit([Bind(Include = "Id")] CVViewModel cVViewModel)
{
if (ModelState.IsValid)
{
db.Entry(cVViewModel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(cVViewModel));
}
// GET: Candidats
public ActionResult Index()
{
var viewModel = new CVViewModel()
{
Candidats = db.Candidats.ToList(),
Poste_Souhaites = db.Poste_Souhaite.ToList(),
Formations = db.Formations.ToList(),
};
return(View(viewModel));
}
public ActionResult Create([Bind(Include = "Id")] CVViewModel cVViewModel)
{
if (ModelState.IsValid)
{
db.CVViewModels.Add(cVViewModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(cVViewModel));
}
public ActionResult <CVViewModel> Get([FromRoute] int id)
{
CVViewModel cv = _db.Users.AsNoTracking().Include(u => u.cv)
.Where(u => u.id == id && u.cv_id.HasValue)
.Select(u => (CVViewModel)u.cv)
.SingleOrDefault();
if (cv == null)
{
return(NotFound());
}
return(Ok(cv));
}
// GET: CV/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CVViewModel cVViewModel = db.CVViewModels.Find(id);
if (cVViewModel == null)
{
return(HttpNotFound());
}
return(View(cVViewModel));
}
//Skapa en lista med vymodellobjekt från våra viewmodel
// Listan som innehåller en massa objekt
public List <CVViewModel> CvVmList()
{
GruppAKonsult_dbEntities2 vmdb = new GruppAKonsult_dbEntities2(); //db Context class
List <CVViewModel> cvVMList = new List <CVViewModel>(); //lista med detaljer från både CV och Freelancer modellerna
var cvlist = (from cvitem in vmdb.CV
join freelanceritem in vmdb.Freelancer on cvitem.CV_Id equals
freelanceritem.Candidate_Id
select new
{
cvitem.Drivinglicense,
cvitem.Education, //Det som hör till CV-tabellen
cvitem.Workexperience,
cvitem.Description,
freelanceritem.Firstname,
freelanceritem.Lastname,
freelanceritem.Email,
freelanceritem.Phonenumber, //Det som hör till Freelancer-tabellen
freelanceritem.Nationality,
freelanceritem.Birthdate,
freelanceritem.Cityofbirth,
freelanceritem.Address,
freelanceritem.Postalnumber,
freelanceritem.City,
//Här får vi lägga till language, skills, profession
}).ToList();
////Query för att hämta data från databasen genom att använda JOIN för att joina de två tabellerna och lagra data i studentlist
foreach (var item in cvlist) //foreach loop för att fylla data från
//cvlist till List < CVViewModel >
{
CVViewModel objcvvm = new CVViewModel(); //ViewModel
objcvvm.Drivinglicense = item.Drivinglicense;
objcvvm.Education = item.Education;
objcvvm.Workexperience = item.Workexperience;
objcvvm.Description = item.Description;
objcvvm.Firstname = item.Firstname;
objcvvm.Lastname = item.Lastname;
objcvvm.Phonenumber = item.Phonenumber;
objcvvm.Nationality = item.Nationality;
cvVMList.Add(objcvvm); //en lista av cvVmList objekt (ViewModel)
}
return(cvVMList);
}
public ActionResult ProfileFreelancer(CVViewModel model)
{
if (ModelState.IsValid)
{
var candidate = db.Freelancer.Add(model.Freelancer);
db.SaveChanges();
model.CV.Candidate_Id = candidate.Candidate_Id;
//CV_ID får 0 värde och det är därför vi summerar 1 till vår query
model.CV.CV_Id = db.CV.Max(x => x.CV_Id) + 1;
var cv = db.CV.Add(model.CV);
db.SaveChanges();
var languages = model.SelectedLanguages;
var l = new Language
{
CV_Id = cv.CV_Id,
Candidate_Id = candidate.Candidate_Id,
Swedish = languages.Contains("2") ? "True" : "False",
English = languages.Contains("3") ? "True" : "False",
French = languages.Contains("4") ? "True" : "False",
Spanish = languages.Contains("5") ? "True" : "False",
German = languages.Contains("6") ? "True" : "False",
Norwegian = languages.Contains("7") ? "True" : "False",
Danish = languages.Contains("8") ? "True" : "False",
Finnish = languages.Contains("9") ? "True" : "False",
};
db.Language.Add(l);
var professions = model.SelectedProfessions;
var p = new Profession
{
CV_Id = cv.CV_Id,
Candidate_Id = candidate.Candidate_Id,
Webbdeveloper = professions.Contains("2") ? "True" : "False",
Systemdeveloper = professions.Contains("3") ? "True" : "False",
Programmer = professions.Contains("4") ? "True" : "False",
Softwareengineer = professions.Contains("5") ? "True" : "False",
Frontenddeveloper = professions.Contains("6") ? "True" : "False",
Backenddeveloper = professions.Contains("7") ? "True" : "False",
Javadeveloper = professions.Contains("8") ? "True" : "False",
Scrummaster = professions.Contains("9") ? "True" : "False",
};
db.Profession.Add(p);
var skills = model.SelectedSkills;
var s = new Skills
{
CV_Id = cv.CV_Id,
Candidate_Id = candidate.Candidate_Id,
C_ = skills.Contains("1") ? "True" : "False",
JavaScript = skills.Contains("2") ? "True" : "False",
Java = skills.Contains("3") ? "True" : "False",
C__ = skills.Contains("4") ? "True" : "False",
JQuery = skills.Contains("5") ? "True" : "False",
HTML = skills.Contains("6") ? "True" : "False",
CSS = skills.Contains("7") ? "True" : "False",
SQL = skills.Contains("7") ? "True" : "False"
};
db.Skills.Add(s);
db.SaveChanges();
//return RedirectToAction("Index");
}
return(View());
}
public IActionResult MyCV(CVViewModel model)
{
return(View(model));
}
public ActionResult Index()
{
var model = new CVViewModel()
{
ProgrammingLanguages = new SkillsSetViewModel()
{
Head = "Języki programowania",
Icon = FontAwesome.keyboard_o,
Skills = new List <SkillViewModel>()
{
new SkillViewModel()
{
Name = "C#", Range = 4.5
},
new SkillViewModel()
{
Name = "SQL", Range = 4.0
},
new SkillViewModel()
{
Name = "C++", Range = 3.5
},
new SkillViewModel()
{
Name = "JavaScript", Range = 3.5
},
new SkillViewModel()
{
Name = "HTML", Range = 3.0
},
new SkillViewModel()
{
Name = "CSS", Range = 3.0
},
new SkillViewModel()
{
Name = "PHP", Range = 2.0
}
}
},
NETTechnologies = new SkillsSetViewModel()
{
Head = "Technologie .NET",
Icon = FontAwesome.microchip,
Skills = new List <SkillViewModel>()
{
new SkillViewModel()
{
Name = "ASP.NET MVC 5", Range = 4.5
},
new SkillViewModel()
{
Name = "Windows Forms", Range = 3.5
},
new SkillViewModel()
{
Name = "Web API", Range = 3.0
},
}
},
BackEnd = new SkillsSetViewModel()
{
Head = "Narzędzia BACK-END",
Icon = FontAwesome.cogs,
Skills = new List <SkillViewModel>()
{
new SkillViewModel()
{
Name = "LINQ", Range = 4.5
},
new SkillViewModel()
{
Name = "Entity Framework", Range = 4.0
},
new SkillViewModel()
{
Name = "Microsoft Identity", Range = 3.5
},
}
},
FrontEnd = new SkillsSetViewModel()
{
Head = "Narzędzia FRONT-END",
Icon = FontAwesome.paint_brush,
Skills = new List <SkillViewModel>()
{
new SkillViewModel()
{
Name = "Bootstrap CSS", Range = 4.0
},
new SkillViewModel()
{
Name = "JQuery", Range = 3.5
},
new SkillViewModel()
{
Name = "Telerik Kendo UI", Range = 3.0
},
}
},
ForeignLanguages = new SkillsSetViewModel()
{
Head = "Języki obce",
Icon = FontAwesome.language,
Skills = new List <SkillViewModel>()
{
new SkillViewModel()
{
Name = "Język angielski", Range = 4.0
},
new SkillViewModel()
{
Name = "Język niemiecki", Range = 2.0
},
}
},
Personal = new SkillsSetViewModel()
{
Head = "Cechy osobowe",
Icon = FontAwesome.user,
Skills = new List <SkillViewModel>()
{
new SkillViewModel()
{
Name = "Kreatywność", Range = 5.0
},
new SkillViewModel()
{
Name = "Organizacja pracy", Range = 4.5
},
new SkillViewModel()
{
Name = "Komunikatywność", Range = 4.5
},
new SkillViewModel()
{
Name = "Odporność na stres", Range = 4.0
},
new SkillViewModel()
{
Name = "Punktualność", Range = 4.0
},
}
},
};
return(View(model));
}
public Utilisateur Map(CVViewModel cVViewModel)
{
Utilisateur utilisateur = new Utilisateur();
utilisateur.GraphKey = cVViewModel.GraphIdUtilisateur;
utilisateur.Prenom = cVViewModel.Prenom;
utilisateur.Nom = cVViewModel.Nom;
utilisateur.Conseiller = new Conseiller {
GraphKey = cVViewModel.GraphIdConseiller
};
utilisateur.Conseiller.Fonction = new Fonction();
utilisateur.Conseiller.Fonction.GraphKey = cVViewModel.GraphIdFonction;
utilisateur.Conseiller.Fonction.Description = cVViewModel.Fonction;
utilisateur.Conseiller.CVs.Add(new CV());
utilisateur.Conseiller.CVs.First().GraphKey = cVViewModel.GraphIdCV;
utilisateur.Conseiller.CVs.First().ResumeExperience = cVViewModel.Biographie;
foreach (DomaineDInterventionViewModel domaineDIntervention in cVViewModel.DomainesDIntervention)
{
utilisateur.Conseiller.DomaineDInterventions.Add(new DomaineDIntervention {
GraphKey = domaineDIntervention.GraphId, Description = domaineDIntervention.Description
});
}
foreach (FormationAcademiqueViewModel formationAcademique in cVViewModel.FormationsAcademique)
{
FormationScolaire formationScolaire = new FormationScolaire();
formationScolaire.GraphKey = formationAcademique.GraphId;
formationScolaire.Diplome = formationAcademique.Diplome;
formationScolaire.DateConclusion = formationAcademique.Annee;
formationScolaire.Ecole = new Instituition();
formationScolaire.Ecole.GraphKey = formationAcademique.GraphIdEtablissement;
formationScolaire.Ecole.Nom = formationAcademique.Etablissement;
utilisateur.Conseiller.FormationsScolaires.Add(formationScolaire);
}
foreach (CertificationViewModel certification in cVViewModel.Certifications)
{
utilisateur.Conseiller.Formations.Add(new Formation {
GraphKey = certification.GraphId, Description = certification.Description, AnAcquisition = certification.Annee, Type = new Genre {
GraphKey = certification.GraphIdGenre, Descriminator = "Formation", Description = "Certification"
}
});
}
foreach (MandatViewModel mandatViewModel in cVViewModel.Mandats)
{
Mandat mandat = new Mandat();
mandat.GraphKey = mandatViewModel.GraphId;
mandat.Projet = new Projet {
GraphKey = mandatViewModel.GraphIdProjet
};
mandat.Projet.Client = new Client {
GraphKey = mandatViewModel.GraphIdClient
};
mandat.Projet.Client.Nom = mandatViewModel.NomClient;
mandat.Numero = mandatViewModel.NumeroMandat.ToString();
mandat.Projet.SocieteDeConseil = new Employeur {
GraphKey = mandatViewModel.GraphIdSocieteDeConseil
};
mandat.Projet.SocieteDeConseil.Nom = mandatViewModel.NomEntreprise;
mandat.Projet.Nom = mandatViewModel.TitreProjet;
mandat.Titre = mandatViewModel.TitreMandat;
mandat.Projet.Envergure = mandatViewModel.Envergure;
mandat.Efforts = mandatViewModel.Efforts;
mandat.Fonction = new Fonction {
GraphKey = mandatViewModel.GraphIdFonction
};
mandat.Fonction.Description = mandatViewModel.Fonction;
mandat.Projet.Description = mandatViewModel.ContexteProjet;
mandat.Description = mandatViewModel.PorteeDesTravaux;
mandat.Projet.DateDebut = mandatViewModel.DebutProjet;
mandat.Projet.DateFin = mandatViewModel.FinProjet;
mandat.DateDebut = mandatViewModel.DebutMandat;
mandat.DateFin = mandatViewModel.FinMandat;
mandat.Projet.NomReference = mandatViewModel.NomReference;
mandat.Projet.TelephoneReference = mandatViewModel.TelephoneReference;
mandat.Projet.CellulaireReference = mandatViewModel.CellulaireReference;
mandat.Projet.CourrielReference = mandatViewModel.CourrielReference;
mandat.Projet.FonctionReference = mandatViewModel.FonctionReference;
foreach (TechnologieViewModel technologie in mandatViewModel.Technologies)
{
mandat.Projet.Technologies.Add(new Technologie {
GraphKey = technologie.GraphId, Nom = technologie.Description
});
}
foreach (TacheViewModel tache in mandatViewModel.Taches)
{
mandat.Taches.Add(new Tache {
GraphKey = tache.GraphId, Description = tache.Description
});
}
utilisateur.Conseiller.Mandats.Add(mandat);
}
foreach (TechnologieViewModel technologie in cVViewModel.Technologies)
{
utilisateur.Conseiller.Technologies.Add(new Technologie {
GraphKey = technologie.GraphId, Nom = technologie.Description, MoisDExperience = technologie.Mois
});
}
foreach (PerfectionnementViewModel perfeccionnement in cVViewModel.Perfectionnements)
{
utilisateur.Conseiller.Formations.Add(new Formation {
GraphKey = perfeccionnement.GraphId, Description = perfeccionnement.Description, AnAcquisition = perfeccionnement.Annee, Type = new Genre {
GraphKey = perfeccionnement.GraphIdGenre, Descriminator = "Formation", Description = "Perfectionnement"
}
});
}
foreach (LangueViewModel langueViewModel in cVViewModel.Langues)
{
Langue langue = new Langue();
langue.GraphKey = langueViewModel.GraphId;
langue.Nom = langueViewModel.Nom;
if (langueViewModel.NiveauParle == null)
{
langue.Parle = Niveau.Avancé;
}
else
{
langue.Parle = (Niveau)System.Enum.Parse(typeof(Niveau), langueViewModel.NiveauParle);
}
if (langueViewModel.NiveauEcrit == null)
{
langue.Ecrit = Niveau.Avancé;
}
else
{
langue.Ecrit = (Niveau)System.Enum.Parse(typeof(Niveau), langueViewModel.NiveauEcrit);
}
if (langueViewModel.NiveauLu == null)
{
langue.Lu = Niveau.Avancé;
}
else
{
langue.Lu = (Niveau)System.Enum.Parse(typeof(Niveau), langueViewModel.NiveauLu);
}
utilisateur.Conseiller.Langues.Add(langue);
}
return(utilisateur);
}
public CVViewModel Map(Utilisateur utilisateur)
{
int intForParse = 0;
CVViewModel cVViewModel = new CVViewModel();
cVViewModel.GraphIdConseiller = utilisateur.Conseiller.GraphKey;
cVViewModel.GraphIdUtilisateur = utilisateur.GraphKey;
cVViewModel.GraphIdFonction = utilisateur.Conseiller.Fonction.GraphKey;
cVViewModel.GraphIdCV = utilisateur.Conseiller.CVs.First().GraphKey;
cVViewModel.Prenom = utilisateur.Prenom;
cVViewModel.Nom = utilisateur.Nom;
cVViewModel.Fonction = utilisateur.Conseiller.Fonction.Description;
cVViewModel.Biographie = utilisateur.Conseiller.CVs.First().ResumeExperience;
foreach (DomaineDIntervention domaineDIntervention in utilisateur.Conseiller.DomaineDInterventions)
{
cVViewModel.DomainesDIntervention.Add(new DomaineDInterventionViewModel {
GraphId = domaineDIntervention.GraphKey, Description = domaineDIntervention.Description
});
}
foreach (FormationScolaire formationScolaire in utilisateur.Conseiller.FormationsScolaires)
{
FormationAcademiqueViewModel formationAcademique = new FormationAcademiqueViewModel();
formationAcademique.GraphId = formationScolaire.GraphKey;
formationAcademique.GraphIdEtablissement = formationScolaire.Ecole?.GraphKey;
formationAcademique.Diplome = formationScolaire.Diplome;
formationAcademique.Annee = formationScolaire.DateConclusion;
formationAcademique.Etablissement = formationScolaire.Ecole?.Nom;
cVViewModel.FormationsAcademique.Add(formationAcademique);
}
foreach (Formation certification in utilisateur.Conseiller.Formations.Where(form => form.Type.Descriminator == "Formation" && form.Type.Description == "Certification"))
{
cVViewModel.Certifications.Add(new CertificationViewModel {
GraphId = certification.GraphKey, Description = certification.Description, Annee = certification.AnAcquisition, GraphIdGenre = certification.Type.GraphKey
});
}
foreach (Mandat mandat in utilisateur.Conseiller.Mandats)
{
MandatViewModel mandatViewModel = new MandatViewModel();
mandatViewModel.GraphId = mandat.GraphKey;
mandatViewModel.GraphIdProjet = mandat.Projet.GraphKey;
mandatViewModel.GraphIdClient = mandat.Projet.Client.GraphKey;
mandatViewModel.GraphIdSocieteDeConseil = mandat.Projet.SocieteDeConseil.GraphKey;
mandatViewModel.GraphIdFonction = mandat.Fonction.GraphKey;
mandatViewModel.NomClient = mandat.Projet.Client.Nom;
int.TryParse(mandat.Numero, out intForParse);
if (intForParse > 0)
{
mandatViewModel.NumeroMandat = intForParse;
}
mandatViewModel.NomEntreprise = mandat.Projet.SocieteDeConseil.Nom;
mandatViewModel.TitreProjet = mandat.Projet.Nom;
mandatViewModel.TitreMandat = mandat.Titre;
mandatViewModel.Envergure = mandat.Projet.Envergure;
mandatViewModel.Efforts = mandat.Efforts;
mandatViewModel.Fonction = mandat.Fonction.Description;
mandatViewModel.ContexteProjet = mandat.Projet.Description;
mandatViewModel.PorteeDesTravaux = mandat.Description;
mandatViewModel.DebutProjet = mandat.Projet.DateDebut;
mandatViewModel.FinProjet = mandat.Projet.DateFin;
mandatViewModel.DebutMandat = mandat.DateDebut;
mandatViewModel.FinMandat = mandat.DateFin;
mandatViewModel.NomReference = mandat.Projet.NomReference;
mandatViewModel.TelephoneReference = mandat.Projet.TelephoneReference;
mandatViewModel.CellulaireReference = mandat.Projet.CellulaireReference;
mandatViewModel.CourrielReference = mandat.Projet.CourrielReference;
mandatViewModel.FonctionReference = mandat.Projet.FonctionReference;
foreach (Technologie technologie in mandat.Projet.Technologies)
{
mandatViewModel.Technologies.Add(new TechnologieViewModel {
GraphId = technologie.GraphKey, Description = technologie.Nom
});
}
foreach (Tache tache in mandat.Taches)
{
mandatViewModel.Taches.Add(new TacheViewModel {
GraphId = tache.GraphKey, Description = tache.Description
});
}
cVViewModel.Mandats.Add(mandatViewModel);
}
foreach (Technologie technologie in utilisateur.Conseiller.Technologies)
{
cVViewModel.Technologies.Add(new TechnologieViewModel {
GraphId = technologie.GraphKey, Description = technologie.Nom, Mois = technologie.MoisDExperience
});
}
foreach (Formation certification in utilisateur.Conseiller.Formations.Where(form => form.Type.Descriminator == "Formation" && form.Type.Description == "Perfectionnement"))
{
cVViewModel.Perfectionnements.Add(new PerfectionnementViewModel {
GraphId = certification.GraphKey, Description = certification.Description, Annee = certification.AnAcquisition, GraphIdGenre = certification.Type.GraphKey
});
}
foreach (Langue langue in utilisateur.Conseiller.Langues)
{
LangueViewModel langueViewModel = new LangueViewModel();
langueViewModel.GraphId = langue.GraphKey;
langueViewModel.Nom = langue.Nom;
langueViewModel.NiveauParle = langue.Parle.ToString();
langueViewModel.NiveauLu = langue.Lu.ToString();
langueViewModel.NiveauEcrit = langue.Ecrit.ToString();
cVViewModel.Langues.Add(langueViewModel);
}
return(cVViewModel);
}
