public void UpdateGridData(JobSkillModel model)
{
var jobSkillToUpdate = this.jobSkillsRepo.FindOne(new ByIdSpecify <JobSkill>(model.Id));
jobSkillToUpdate.Estimate = model.Estimate;
this.jobSkillsRepo.SaveOrUpdate(jobSkillToUpdate);
}
public JobSkillModel Get(string skillId)
{
var skill = new JobSkillModel();
try
{
using (GetaJobContext db = new GetaJobContext())
{
var dbSkill = db.JobSkills.Where(s => s.Id == skillId).FirstOrDefault();
if (dbSkill != null)
{
skill.Name = dbSkill.SkillName;
skill.Category = dbSkill.SkillType;
skill.Proficiency = dbSkill.Proficiency;
if (dbSkill.Proficiency != null)
{
skill.ProficiencyDescription = db.JobRefs.Where(r => r.RefCode == dbSkill.Proficiency).FirstOrDefault().RefDescription;
}
skill.FontSize = dbSkill.SortOrder;
skill.Narrative = dbSkill.Narrative;
}
}
}
catch (Exception ex) { skill.Name = Helpers.ErrorDetails(ex); }
return(skill);
}
public string Put(JobSkillModel editedSkill)
{
string success = "";
try
{
using (GetaJobContext db = new GetaJobContext())
{
var dbSkill = db.JobSkills.Where(j => j.Id == editedSkill.Id).FirstOrDefault();
dbSkill.SkillName = editedSkill.Name;
dbSkill.SkillType = editedSkill.Category;
dbSkill.Narrative = editedSkill.Narrative;
dbSkill.Proficiency = editedSkill.Proficiency;
dbSkill.SortOrder = editedSkill.FontSize;
db.SaveChanges();
success = "ok";
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
public string Post(JobSkillModel newSkill)
{
string success = "";
try
{
var dbSkill = new JobSkill();
dbSkill.Id = Guid.NewGuid().ToString();
dbSkill.Narrative = newSkill.Narrative;
dbSkill.SkillName = newSkill.Name;
dbSkill.Proficiency = newSkill.Proficiency;
dbSkill.SortOrder = newSkill.FontSize;
dbSkill.SkillType = newSkill.Category;
using (GetaJobContext db = new GetaJobContext())
{
db.JobSkills.Add(dbSkill);
db.SaveChanges();
success = dbSkill.Id;
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
