public void UpdateUser(User m1) { var session = NHibernateContext.SesionFactory; using (var transaction = session.BeginTransaction()) { session.SaveOrUpdate(m1); transaction.Commit(); } }
public List<Contact> GetSearchedUserContacts(User user, string searchQuery) { var result = new List<Contact>(); var session = NHibernateContext.SesionFactory; using (var transaction = session.BeginTransaction()) { result = (List<Contact>)session.QueryOver<Contact>().Where(x => x.Name.IsLike(@"%" + searchQuery + "%") || x.Address.IsLike(@"%" + searchQuery + "%")).And(x=>x.User.UId==user.UId).List(); transaction.Commit(); } return result; }
public bool CreateUser(User newUser) { User storingUser = GetUserByName(newUser.UserName); bool isExist = false; if (storingUser == null) { var session = NHibernateContext.SesionFactory; using (var transaction = session.BeginTransaction()) { session.SaveOrUpdate(newUser); transaction.Commit(); isExist = true; } } return isExist; }
public Contact GetUserContactById(User use,int id) { IList<Contact> Contact = new List<Contact>(); // create our NHibernate session factory var session = NHibernateContext.Session; // populate the database using (var transaction = session.BeginTransaction()) { Contact = session.Get<User>(use.UId).ContactsList; transaction.Commit(); } return Contact.First(x=>x.Id==id); }
public ActionResult Create(Contact newContact) { aCookie = Request.Cookies["loginCookie"]; if (aCookie != null) { if (ModelState.IsValid) { UserName = Server.HtmlEncode(aCookie.Value); user = userRepo.GetUserByName(UserName); user.ContactsList.Add(newContact); userRepo.UpdateUser(user); return RedirectToAction("Index"); } return View(newContact); } return RedirectToAction("Index", "Home"); }
public void UpdateUser(User m1) { var session = NHibernateContext.Session; // populate the database using (var transaction = session.BeginTransaction()) { session.Update(m1); transaction.Commit(); } //replace existing record with this in DB table }
public ActionResult Delete(int id, Contact newContact) { aCookie = Request.Cookies["loginCookie"]; if (aCookie != null) { UserName = Server.HtmlEncode(aCookie.Value); user = userRepo.GetUserByName(UserName); var contactList = user.ContactsList; contactList.Remove(contactList.SingleOrDefault(x => x.Id == newContact.Id)); userRepo.UpdateUser(user); return RedirectToAction("Index"); } return RedirectToAction("Index", "Home"); }
public ActionResult Search(ContactSearch newContact) { aCookie = Request.Cookies["loginCookie"]; if (aCookie != null) { var searchList = new List<Contact>(); if (ModelState.IsValid) { UserName = Server.HtmlEncode(aCookie.Value); user = userRepo.GetUserByName(UserName); searchList = userRepo.GetSearchedUserContacts(user,newContact.SearchQuery); newContact.UserList = searchList; return View(newContact); } else { newContact.UserList = searchList; return View(newContact); } } return RedirectToAction("Index", "Home"); }
// // GET: /Contact/ public ActionResult Index() { aCookie = Request.Cookies["loginCookie"]; if (aCookie != null) { UserName = Server.HtmlEncode(aCookie.Value); user = userRepo.GetUserByName(UserName); var model = user.ContactsList; return View(model); } return RedirectToAction("Index", "Home"); }
public ActionResult Edit(int id, Contact newContact) { aCookie = Request.Cookies["loginCookie"]; if (aCookie != null) { if (ModelState.IsValid) { UserName = Server.HtmlEncode(aCookie.Value); user = userRepo.GetUserByName(UserName); newContact.User = user; var cr = new ContactRepo(); cr.UpdateContact(id,newContact); return RedirectToAction("Index"); } else { return View(userRepo.GetUserContactById(id)); } } return RedirectToAction("Index", "Home"); }
// // GET: /Contact/DeleteAll public ActionResult DeleteAll() { aCookie = Request.Cookies["loginCookie"]; if (aCookie != null) { UserName = Server.HtmlEncode(aCookie.Value); user = userRepo.GetUserByName(UserName); user.ContactsList=new List<Contact>(); userRepo.UpdateUser(user); return RedirectToAction("Index"); } return RedirectToAction("Index", "Home"); }
public ActionResult Register(User model) { if (ModelState.IsValid) { bool stat = repo.CreateUser(model); if (stat) { FormsAuthentication.SetAuthCookie(model.UserName, false); HttpCookie myCookie = new HttpCookie("loginCookie"); // Set the cookie value. myCookie.Value = model.UserName; Response.Cookies.Add(myCookie); return RedirectToAction("Index", "Home"); } ModelState.AddModelError("", "User name already exists. Please enter a different user name."); } return View(model); }