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