public PartialViewResult skillsAddPop(int?qenSkillsID, int?qenid)
{
if (qenSkillsID != null && qenSkillsID > 0)
{
var emp = db.qenSkills.Include(e => e.skill).Where(ex => ex.qenSkillsID == qenSkillsID).FirstOrDefault();
qenSkillName oqenSkillName = new qenSkillName();
oqenSkillName.skillID = emp.skillsID;
oqenSkillName.qenID = Convert.ToInt32(emp.qenID);
oqenSkillName.qenSkillsID = Convert.ToInt32(emp.skillsID);
oqenSkillName.skillName = emp.skill.skillName;
oqenSkillName.yearOfExp = emp.yearOfExp;
return(PartialView("_partialAddSkills", oqenSkillName));
}
else
{
qenSkillName oqenSkillName = new qenSkillName();
return(PartialView("_partialAddSkills", oqenSkillName));
}
}
public ActionResult AddSkills(qenSkillName model)
{
try
{
qenSkill oqenSkill = null;
oqenSkill = db.qenSkills.Where(ex => ex.qenSkillsID == model.qenSkillsID).FirstOrDefault();
if (oqenSkill != null)
{
int skill_id = checkValuExist(model.skillName.ToString());
oqenSkill.skillsID = skill_id;
oqenSkill.yearOfExp = model.yearOfExp;
oqenSkill.qenID = model.qenID;
oqenSkill.qenSkillsID = model.qenSkillsID;
db.Entry(oqenSkill).State = EntityState.Modified;
db.SaveChanges();
}
else
{
oqenSkill = new qenSkill();
int skill_id = checkValuExist(model.skillName.ToString());
oqenSkill.skillsID = skill_id;
oqenSkill.yearOfExp = model.yearOfExp;
oqenSkill.qenID = model.qenID;
db.qenSkills.Add(oqenSkill);
db.SaveChanges();
}
return(RedirectToAction("skills", new { qenid = model.qenID }));
}
catch (Exception ex)
{
TempData["msg"] = ex.Message.ToString();
app_error_log oapp_error_log = new app_error_log();
oapp_error_log.user_id = Convert.ToInt32(model.qenID);
oapp_error_log.error_message = ex.Message.ToString();
oapp_error_log.ApplicationName = "NewsLetter";
oapp_error_log.created_date = DateTime.Now;
db.app_error_log.Add(oapp_error_log);
db.SaveChanges();
return(RedirectToAction("Error"));
}
}
