public void DeleteUser() { using (EFUserMapper mapper = new EFUserMapper(CONNECTION_STRING)) { Expression <Func <User, bool> > expression = u => u.Login == userClassic3.Login; mapper.Delete(mapper.FindBy(expression).First().ID); Assert.AreEqual(0, mapper.FindBy(expression).Count); } }
public void UpdateUserAddAddress() { using (EFUserMapper mapper = new EFUserMapper(CONNECTION_STRING)) { Expression <Func <User, bool> > expression = u => u.Login == userWithoutAddress.Login; User us = mapper.FindBy(expression).First(); us.Address = AddressClassic3; mapper.AddorUpdate(us); Assert.AreEqual(AddressClassic3, mapper.FindBy(us.ID).Address); } }
public void GetOneUserBysearch() { using (EFUserMapper mapper = new EFUserMapper(CONNECTION_STRING)) { Expression <Func <User, bool> > expression = u => u.Email == userClassic2.Email && u.Phone == userClassic2.Phone; Assert.AreEqual(userClassic2.Login, mapper.FindBy(expression).First().Login); } }
public void GetOneUserByID() { using (EFUserMapper mapper = new EFUserMapper(CONNECTION_STRING)) { userClassic4 = mapper.AddorUpdate(userClassic4); Assert.AreEqual(userClassic4.Login, mapper.FindBy(userClassic4.ID).Login); } }
public ActionResult AddressEditor() { User user; using (EFUserMapper mapper = new EFUserMapper("WebProject2017-DBb")) { user = mapper.FindBy(((User)Session["User"]).ID); } return(View(user.Address)); }
public void UpdateUser() { userClassic1.Phone = "0478956321"; userClassic1.ID = 2; using (EFUserMapper mapper = new EFUserMapper(CONNECTION_STRING)) { userClassic5 = mapper.AddorUpdate(userClassic5); userClassic5.Phone = "0478956321"; userClassic5 = mapper.AddorUpdate(userClassic5); Assert.AreEqual("0478956321", mapper.FindBy(userClassic5.ID).Phone); } }
// GET public ActionResult Profil() { if (((User)Session["User"]) != null) { ProfilViewModel vm; using (EFUserMapper mapper = new EFUserMapper("WebProject2017-DBb")) { vm = new ProfilViewModel() { User = mapper.FindBy(((User)Session["User"]).ID), Journeys = new List <Journey>() }; } return(View(vm)); } else { return(RedirectToAction("Sign_In_Out")); } }
public ActionResult Sign_In_Out(SignInModelView user) { if (ModelState.IsValid) { using (EFUserMapper mapper = new EFUserMapper("WebProject2017-DBb")) { Expression <Func <User, bool> > expression = u => u.Login == user.Login && u.Password == user.Password; List <User> uss = mapper.FindBy(expression).ToList <User>(); if (uss.Count > 0) { User us = uss.First(); Session.Add("User", us); return(RedirectToAction("Profil")); } else { ViewBag.MessageErreur = "idenfiant incorrect"; } } } return(View()); }