public ActionResult DeleteContact(ContactsModels model) { // if deleting a contact then we need to remove it also from // TrialContactsModels // and ContactTrialGroupModels // Thus removing the contact from all trials but also from // the access table for all trials. var trialContactsModels = (from tc in db.TrialContactsModels where tc.ContactId == model.Id select tc).ToList(); foreach (var tcm in trialContactsModels) { db.TrialContactsModels.Remove(tcm); } var contactTrialGroupModels = (from c in db.ContactTrialGroupModels where c.ContactId == model.Id select c).ToList(); foreach (var ctg in contactTrialGroupModels) { db.ContactTrialGroupModels.Remove(ctg); } ContactsModels contactsModels = db.ContactsModels.Find(model.Id); db.ContactsModels.Remove(contactsModels); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(int id) { ContactsModels contactsModels = db.ContactsModels.Find(id); db.ContactsModels.Remove(contactsModels); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,ContactName,Organisation,Telephone,Email,ContactStatusId,ContactNotes")] ContactsModels contactsModels) { if (ModelState.IsValid) { db.Entry(contactsModels).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ContactStatusId = new SelectList(db.ContactStatusModels, "Id", "ContactStatusName", contactsModels.ContactStatusId); return(View(contactsModels)); }
// GET: Contacts/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ContactsModels contactsModels = db.ContactsModels.Find(id); if (contactsModels == null) { return(HttpNotFound()); } return(View(contactsModels)); }
// GET: Contacts/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ContactsModels contactsModels = db.ContactsModels.Find(id); if (contactsModels == null) { return(HttpNotFound()); } ViewBag.ContactStatusId = new SelectList(db.ContactStatusModels, "Id", "ContactStatusName", contactsModels.ContactStatusId); return(View(contactsModels)); }
public ActionResult Create([Bind(Include = "Id,ContactName,UserId,Organisation,Telephone,Email,ContactStatusId,ContactNotes")] ContactsModels contactsModels) { if (contactsModels.UserId == null) { //lets try to find the userId from the UserName string userName = contactsModels.ContactName; string email = contactsModels.Email.ToLower(); email = email.Replace("ncl", "newcastle"); using (PrincipalContext ctx = new PrincipalContext(ContextType.Domain, "campus.ncl.ac.uk")) { PrincipalSearcher search = new PrincipalSearcher(); UserPrincipal user = new UserPrincipal(ctx); user.Enabled = true; user.DisplayName = userName; user.EmailAddress = email; search.QueryFilter = user; PrincipalSearchResult <Principal> results = search.FindAll(); if (results.Count() == 1) { //have definitely found the user and can now save the users ID contactsModels.UserId = results.FirstOrDefault().SamAccountName; } } } if (ModelState.IsValid) { db.ContactsModels.Add(contactsModels); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ContactStatusId = new SelectList(db.ContactStatusModels.Where(s => s.Deleted == null), "Id", "ContactStatusName", contactsModels.ContactStatusId); return(View(contactsModels)); }