public ActionResult Create(HeistModel model) { try { tblHeist heist = new tblHeist(); { heist.Name = model?.Name ?? null; heist.Location = model?.Location ?? null; heist.StartDate = model.StartDate; heist.StartTime = model.StartTime; heist.EndDate = model.EndDate; heist.EndTime = model.EndTime; heist.Active = false; } db.tblHeist.Add(heist); db.SaveChanges(); List <tblHeist> heists = new List <tblHeist>(); heists = db.tblHeist.Where(m => m.Active == false).ToList(); return(View("Index", heists)); } catch { return(View("Create", model)); } }
public ActionResult AddHeistMember(int?heistID) { tblHeist heist = GetHeistByID(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(heistID); List <HeistMemberModel> _list = _allMembers.ToList(); hm.HeistMembers = _allMembers as List <HeistMemberModel>; ViewBag.MatchingMembers = new SelectList(_list); return(View()); }
public ActionResult Create() { HeistModel hm = new HeistModel(); hm.StartDate = DateTime.Now; hm.StartTime = DateTime.Now; hm.EndDate = DateTime.Now; hm.EndTime = DateTime.Now; hm.Active = true; return(View(hm)); }
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 Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ViewBag.HeistID = id; var totall = db.tblHeistSkills.Where(m => m.HeistID == id).ToArray(); int total = 0; foreach (tblHeistSkills item in totall) { total += (Int32)item.MembersNo; } ViewBag.MembersRequiredTotal = total; ViewBag.MembersAssignedTotal = db.tblHeistMembers.Where(m => m.HeistID == id).Count(); tblHeist heist = GetHeistByID(id); var _skillsList = heist.tblHeistSkills.OrderBy(m => m.HeistID).ToArray(); HeistModel hm = new HeistModel(); hm.HeistID = heist.HeistID; hm.Name = heist.Name; hm.Location = heist.Location; hm.StartDate = heist.StartDate; hm.StartTime = heist.StartTime; hm.EndDate = heist.EndDate; hm.EndTime = heist.EndTime; //Setting skills hm.HeistSkills = GetHeistSkills(id); //Setting members var _allMembers = db.tblHeistMembers.ToArray(); hm.HeistMembers = GetHeistMembers(id); return(View(hm)); }
public List <HeistMemberModel> GetMatchingMembers(int?heistID) { tblHeist heist = GetHeistByID(heistID); var _skillsList = heist.tblHeistSkills.OrderBy(m => m.HeistID).ToArray(); HeistModel hm = new HeistModel(); hm.HeistID = heist.HeistID; //Setting 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); } //Setting members List <HeistMemberModel> matchingMembers = new List <HeistMemberModel>(); var _allMembers = db.tblMember.Where(m => m.ActiveInHeist != true).ToArray(); hm.HeistMembers = new List <HeistMemberModel>(); for (int i = 0; i < hm.HeistSkills.Count(); i++) //iterating skills determined for heist { for (int j = 0; j < _allMembers.Count(); j++) //iterating predetermined members { var temp = _allMembers[j].MemberID; List <tblMemberSkills> memberSkills = db.tblMemberSkills.Where(m => m.MemberID == temp).ToList(); //getting each member's skills for (int m = 0; m < memberSkills.Count(); m++) { if (hm.HeistSkills[i].Name == memberSkills[m].Name && hm.HeistSkills[i].Level.Length <= memberSkills[m].SkillLevel.Length) //matching heist skills to member's skills { HeistMemberModel member = new HeistMemberModel(); member.HeistID = heist.HeistID; member.MemberID = _allMembers[j].MemberID; member.Name = _allMembers[j].Name; bool contains = false; for (int k = 0; k < matchingMembers.Count(); k++) { if (matchingMembers[k].Name == member.Name) { contains = true; } } if (contains != true) { matchingMembers.Add(member); } } } } } return(matchingMembers); }