public void DeleteById(int id) // Delete function
{
EmpSkill emp = GetById(id);
dbconn.EmpSkills.Remove(emp);
dbconn.SaveChanges();
}
public ActionResult DeleteConfirmed(int id)
{
EmpSkill empSkill = db.EmpSkills.Find(id);
db.EmpSkills.Remove(empSkill);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public EmpSkill Add(EmpSkill emp) // Adding Function
{
EmpSkill addedEmp = dbconn.EmpSkills.Add(emp);
dbconn.SaveChanges();
return(addedEmp);
}
public ActionResult Edit([Bind(Include = "EmpSkillID,SkillTitle,Category,Usage,EmpProfileID")] EmpSkill empSkill)
{
if (ModelState.IsValid)
{
db.Entry(empSkill).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmpProfileID = new SelectList(db.EmpProfiles, "EmpProfileID", "FirstName", empSkill.EmpProfileID);
return(View(empSkill));
}
public ActionResult Edit([Bind(Include = "ID,EmpID,SkillD,SkillLevelID")] EmpSkill empSkill)
{
if (ModelState.IsValid)
{
db.Entry(empSkill).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmpID = new SelectList(db.Employees, "ID", "Name", empSkill.EmpID);
ViewBag.SkillD = new SelectList(db.Skills, "ID", "Name", empSkill.SkillD);
ViewBag.SkillLevelID = new SelectList(db.SkillLevels, "ID", "Name", empSkill.SkillLevelID);
return(View(empSkill));
}
// GET: Search/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EmpSkill empSkill = db.EmpSkills.Find(id);
if (empSkill == null)
{
return(HttpNotFound());
}
return(View(empSkill));
}
// GET: Skill/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EmpSkill empSkill = db.EmpSkills.Find(id);
if (empSkill == null)
{
return(HttpNotFound());
}
ViewBag.EmpProfileID = new SelectList(db.EmpProfiles, "EmpProfileID", "FirstName", empSkill.EmpProfileID);
return(View(empSkill));
}
// GET: Search/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EmpSkill empSkill = db.EmpSkills.Find(id);
if (empSkill == null)
{
return(HttpNotFound());
}
ViewBag.EmpID = new SelectList(db.Employees, "ID", "Name", empSkill.EmpID);
ViewBag.SkillD = new SelectList(db.Skills, "ID", "Name", empSkill.SkillD);
ViewBag.SkillLevelID = new SelectList(db.SkillLevels, "ID", "Name", empSkill.SkillLevelID);
return(View(empSkill));
}
// Add Skills
public ActionResult AddSkills(int skillId, int empId, int skillLevelId) // ID of skill
{
var empSkill = new EmpSkill();
empSkill.EmpID = empId;
List <Skill> skills = skillsbusinessManager.GetUnmappedSkillsByEmpId(empId);
if (skills.Where(s => s.ID == skillId).FirstOrDefault() != null)
{
empSkill.SkillD = skillId;
empSkill.SkillLevelID = skillLevelId;
empskilssbusinessManager.Add(empSkill);
}
var empSkills = empskilssbusinessManager.GetByEmployeeID(empId);
return(PartialView("_userSkills", empSkills));
}
// Adding a new skill not in the database
public ActionResult AddNewSkill(int empId, int skillLevelId, string skill)
{
var empSkill = new EmpSkill();
Skill NewSkill = new Skill();
NewSkill.Name = skill;
var added = skillsbusinessManager.Add(NewSkill);
empSkill.EmpID = empId;
List <Skill> skills = skillsbusinessManager.GetUnmappedSkillsByEmpId(empId);
if (skills.Where(j => j.ID == added.ID).FirstOrDefault() != null)
{
empSkill.SkillD = added.ID;
empSkill.SkillLevelID = skillLevelId;
empskilssbusinessManager.Add(empSkill);
}
var empSkills = empskilssbusinessManager.GetByEmployeeID(empId);
return(PartialView("_userSkills", empSkills));
}
public EmpSkill Update(EmpSkill emp)
{
return(empskilldatamanager.Update(emp));
}
public EmpSkill Add(EmpSkill emp)
{
return(empskilldatamanager.Add(emp));
}
public EmpSkill Update(EmpSkill emp) // Update Function
{
dbconn.Entry(emp).State = EntityState.Modified;
dbconn.SaveChanges();
return(emp);
}
public EmpSkill GetById(int id) // Get the ID Function
{
EmpSkill emp = dbconn.EmpSkills.Where(e => e.ID == id).FirstOrDefault();
return(emp);
}
