public void AddEmptyUser()
{
using (EFUserMapper mapper = new EFUserMapper(CONNECTION_STRING))
{
mapper.AddorUpdate(userEmpty);
}
}
public void GetAllUser()
{
using (EFUserMapper mapper = new EFUserMapper(CONNECTION_STRING))
{
Assert.AreNotEqual(0, mapper.GetAll().Count);
}
}
public void AddUserWithoutPhone()
{
using (EFUserMapper mapper = new EFUserMapper(CONNECTION_STRING))
{
mapper.AddorUpdate(userWithoutPhone);
}
}
public void AddUserClassic()
{
using (EFUserMapper mapper = new EFUserMapper(CONNECTION_STRING))
{
Assert.AreNotEqual(0, mapper.AddorUpdate(userClassic3).ID);
}
}
public void AddUserWithoutUserRank()
{
using (EFUserMapper mapper = new EFUserMapper(CONNECTION_STRING))
{
Assert.AreEqual(userWithoutUserRank.Login, mapper.AddorUpdate(userWithoutUserRank).Login);
}
}
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 AddUsers()
{
List <User> users = new List <User> {
userClassic1, userClassic2
};
using (EFUserMapper mapper = new EFUserMapper(CONNECTION_STRING))
{
Assert.AreNotEqual(0, mapper.AddorUpdate(users).Count);
}
}
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 ActionResult ProfilEditor(User user)
{
if (ModelState.IsValid)
{
using (EFUserMapper mapper = new EFUserMapper("WebProject2017-DBb"))
{
user.ID = (int)Session["UserId"];
mapper.AddorUpdate(user);
return(RedirectToAction("Profil"));
}
}
return(View(user));
}
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_Up(User user)
{
if (ModelState.IsValid)
{
using (EFUserMapper mapper = new EFUserMapper("WebProject2017-DBb"))
{
try
{
user = mapper.AddorUpdate(user);
Session.Add("User", user);
return(RedirectToAction("Profil"));
}
catch (Exception ex)
{
ViewBag.MessageErreur = ex.Message;
}
}
}
return(View(user));
}
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());
}
public void Setup()
{
addresses = new List <Address> {
new Address()
{
Country = "Belgique", Locality = "Ouffet", Number = "7", PostalCode = "4590", Road = "Sauveniere"
},
new Address()
{
Country = "Belgique", Locality = "Liege", Number = "82", PostalCode = "4000", Road = "Leman"
},
new Address()
{
Country = "France", Locality = "Paris", Number = "100", PostalCode = "10000", Road = "efle"
},
new Address()
{
Country = "Italie", Locality = "Rome", Number = "97", PostalCode = "8520", Road = "pize"
}
};
using (EFAddressMapper mapper = new EFAddressMapper(CONNECTION_STRING))
{
addresses = mapper.AddorUpdate(addresses);
}
users = new List <User> {
new User()
{
Login = "******", Password = "******", Name = "bologne", LastName = "sauce", Email = "*****@*****.**", Phone = "0475859565", Rank = UserRank.Member, Address = addresses[0]
}
, new User()
{
Login = "******", Password = "******", Name = "coucou", LastName = "carle", Email = "*****@*****.**", Phone = "0465958565", Rank = UserRank.Member, Address = addresses[1]
}
, new User()
{
Login = "******", Password = "******", Name = "polo", LastName = "lolo", Email = "*****@*****.**", Phone = "0456958565", Rank = UserRank.Member, Address = addresses[2]
}
};
using (EFUserMapper mapper = new EFUserMapper(CONNECTION_STRING))
{
users = mapper.AddorUpdate(users);
}
journeyClassic1 = new Journey()
{
Description = "trajet 1", Driver = users[0], FreeSeat = 4, StartingAddress = addresses[0], DriverUpAddress = addresses[1], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>()
};
journeyClassic2 = new Journey()
{
Description = "trajet 2", Driver = users[1], FreeSeat = 4, StartingAddress = addresses[2], DriverUpAddress = addresses[1], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>()
};
journeyClassic3 = new Journey()
{
Description = "trajet 3", Driver = users[0], FreeSeat = 4, StartingAddress = addresses[3], DriverUpAddress = addresses[2], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>()
};
journeyClassic4 = new Journey()
{
Description = "trajet 4", Driver = users[0], FreeSeat = 4, StartingAddress = addresses[3], DriverUpAddress = addresses[2], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>()
};
journeyWithoutDescription = new Journey()
{
Driver = users[0], FreeSeat = 4, StartingAddress = addresses[0], DriverUpAddress = addresses[1], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>()
};
journeyWithoutFreeSeat = new Journey()
{
Description = "trajet 1", Driver = users[0], StartingAddress = addresses[0], DriverUpAddress = addresses[1], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>()
};
journeyWithoutDriver = new Journey()
{
Description = "trajet 1", FreeSeat = 4, StartingAddress = addresses[0], DriverUpAddress = addresses[1], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>()
};
journeyWithoutStartingAddress = new Journey()
{
Description = "trajet 1", Driver = users[0], FreeSeat = 4, DriverUpAddress = addresses[1], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>()
};
journeyWithoutDriverUpAddress = new Journey()
{
Description = "trajet 1", Driver = users[0], FreeSeat = 4, StartingAddress = addresses[0], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>()
};
journeyWithoutStartingDateTime = new Journey()
{
Description = "trajet 1", Driver = users[0], FreeSeat = 4, StartingAddress = addresses[0], DriverUpAddress = addresses[1], DriverUpDatetime = new DateTime(2017, 06, 12, 18, 40, 0), Passengers = new List <User>()
};
journeyWithoutDriverUpDateTime = new Journey()
{
Description = "trajet 1", Driver = users[0], FreeSeat = 4, StartingAddress = addresses[0], DriverUpAddress = addresses[1], StartingDateTime = new DateTime(2017, 06, 12, 14, 30, 0), Passengers = new List <User>()
};
journeyEmpty = new Journey();
}
