public ActionResult Create(tblMemberSkills model)
{
ViewBag.Skills = new SelectList(memberSkills);
CheckSkillExists(model);
try
{
tblMemberSkills skil = new tblMemberSkills
{
MemberID = model.MemberID,
Name = model.Name,
SkillLevel = model.SkillLevel
};
db.tblMemberSkills.Add(skil);
db.SaveChanges();
return(RedirectToAction("Details", "Member", new { @id = model.MemberID }));
}
catch (Exception ex)
{
return(View());
}
}
public ActionResult Edit(int id)
{
ViewBag.Skills = new SelectList(memberSkills);
tblMemberSkills ms = GetSkillByID(id);
return(View(ms));
}
public ActionResult Create(int id)
{
ViewBag.Skills = new SelectList(memberSkills);
tblMemberSkills model = new tblMemberSkills();
model.MemberID = id;
ViewBag.MemberID = id;
return(View(model));
}
public ActionResult Delete(int id)
{
try
{
tblMemberSkills ms = GetSkillByID(id);
db.tblMemberSkills.Remove(ms);
db.SaveChanges();
return(RedirectToAction("Details", "Member", new { @id = ms.MemberID }));
}
catch
{
return(View());
}
}
public ActionResult Edit(tblMemberSkills skills)
{
ViewBag.Skills = new SelectList(memberSkills);
try
{
tblMemberSkills ms = GetSkillByID(skills.SkillID);
ms.Name = skills.Name;
ms.SkillLevel = skills.SkillLevel;
db.SaveChanges();
return(RedirectToAction("Details", "Member", new { @id = skills.MemberID }));
}
catch (Exception ex)
{
return(View());
}
}
public void CheckSkillExists(tblMemberSkills model)
{
int skillID;
List <tblMemberSkills> skills = db.tblMemberSkills.Where(m => m.MemberID == model.MemberID).ToList();
for (int i = 0; i < skills.Count(); i++)
{
if (skills[i].Name == model.Name)
{
skillID = skills[i].SkillID;
tblMemberSkills oldSkil = db.tblMemberSkills.Find(skillID);
db.tblMemberSkills.Remove(oldSkil);
db.SaveChanges();
}
}
}
private tblMemberSkills GetSkillByID(int?id)
{
tblMemberSkills skill = db.tblMemberSkills.SingleOrDefault(m => m.SkillID == id);
return(skill);
}
