public ActionResult AddHeistMember(HeistMemberModel model) { tblHeist heist = GetHeistByID(model.HeistID); var _skillsList = heist.tblHeistSkills.OrderBy(m => m.HeistID).ToArray(); HeistModel hm = new HeistModel(); //Getting skills hm.HeistSkills = new List <HeistSkillModel>(); for (int i = 0; i < _skillsList.Count(); i++) { HeistSkillModel mod = new HeistSkillModel { HeistID = _skillsList[i].HeistID, SkillID = _skillsList[i].SkillsID, Name = _skillsList[i].Name, Level = _skillsList[i].SkillLevel, MembersNo = (Int16)_skillsList[i].MembersNo }; hm.HeistSkills.Add(mod); } //getting members var _allMembers = GetMatchingMembers(model.HeistID); List <HeistMemberModel> _list = _allMembers.ToList(); hm.HeistMembers = _allMembers as List <HeistMemberModel>; ViewBag.MatchingMembers = new SelectList(_list); tblHeistMembers member = new tblHeistMembers(); member.HeistID = model.HeistID; member.MemberID = Convert.ToInt32(model.Name); member.ActiveInHeist = true; db.tblHeistMembers.Add(member); tblMember mem = new tblMember(); mem = db.tblMember.SingleOrDefault(m => m.MemberID == member.MemberID); mem.ActiveInHeist = true; db.SaveChanges(); return(RedirectToAction("Details", "Heist", new { @id = model.HeistID })); }
public ActionResult DeleteMember(int id) { tblHeistMembers member = db.tblHeistMembers.SingleOrDefault(m => m.MemberID == id); int?heistID = member.HeistID; db.tblHeistMembers.Remove(member); tblMember mem = db.tblMember.SingleOrDefault(m => m.MemberID == id); mem.ActiveInHeist = false; db.SaveChanges(); return(RedirectToAction("Details", "Heist", new { @id = heistID })); }