// GET: Groups/Details/5 public ActionResult GroupsDetails(int? id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } Groups group = db.Groups.Find(id); GroupViewModel gvm = new GroupViewModel(); gvm.pKey = group.pKey; gvm.group = group; ContactPosition cp = db.ContactPosition.Where(x => x.DistKey == GlobalVariables.DistKey).Where(x => x.GroupID == group.pKey).Where(x => x.PositionID == 2).FirstOrDefault(); if (cp != null) { int GSRID = cp.ContactID; gvm.contact = db.Contacts.Where(x => x.pKey == GSRID).FirstOrDefault(); } return View(gvm); }
// GET: Groups public ActionResult GroupsIndex() { List<GroupViewModel> gvmList = new List<GroupViewModel>(); var groupList = db.Groups.Where(x => x.DistKey == GlobalVariables.DistKey).ToList(); foreach(Groups group in groupList) { GroupViewModel gvm = new GroupViewModel(); gvm.group = group; gvm.pKey = group.pKey; ContactPosition cp = db.ContactPosition.Where(x => x.DistKey == GlobalVariables.DistKey).Where(x => x.GroupID == group.pKey).Where(x => x.PositionID == 2).FirstOrDefault(); if (cp != null) { int GSRID = cp.ContactID; gvm.contact = db.Contacts.Where(x => x.pKey == GSRID).FirstOrDefault(); } gvmList.Add(gvm); } return View(gvmList); }