//Edit studies
public JsonResult EditStudies(int?Id_candidate, int id_education, string school, string diploma, string from_date, string to_date, string section)
{
CandidateStudies studiesToUpdate = db.CandidateStudies.Single(x => x.id_candidate == Id_candidate && x.id_education == id_education);
bool result = false;
studiesToUpdate.school = school;
studiesToUpdate.diploma = diploma;
studiesToUpdate.from_date = from_date;
studiesToUpdate.to_date = to_date;
studiesToUpdate.section = section;
db.SaveChanges();
result = true;
return(Json(result, JsonRequestBehavior.AllowGet));
}
//remove studies row
public JsonResult DeleteStudies(int?Id_candidate, int?id_education)
{
NoBordersDB db = new NoBordersDB();
CandidateProfile candidateProfile = db.CandidateProfiles.Find(Id_candidate);
CandidateStudies candidateStudies = db.CandidateStudies.SingleOrDefault(x => x.id_candidate == Id_candidate && x.id_education == id_education);
bool result = false;
if (candidateStudies != null)
{
db.CandidateStudies.Remove(candidateStudies);
db.SaveChanges();
result = true;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
//add Studies
public JsonResult AddStudies(int?Id_candidate, string school, string diploma, string from_date, string to_date, string section)
{
CandidateStudies candidateStudies = new CandidateStudies();
bool result = false;
candidateStudies.id_candidate = (int)Id_candidate;
candidateStudies.school = school;
candidateStudies.diploma = diploma;
candidateStudies.from_date = from_date;
candidateStudies.to_date = to_date;
candidateStudies.section = section;
db.CandidateStudies.Add(candidateStudies);
db.SaveChanges();
result = true;
return(Json(result, JsonRequestBehavior.AllowGet));
}
