public void DeleteMembre()
{
MembreRepository Mr = new MembreRepository(@"Data Source=MIKEW10\TFTIC2014;Initial Catalog=XmasDb;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
bool rep = Mr.Delete(6);
Assert.IsTrue(rep);
}
public void GetAllMembre()
{
MembreRepository Mr = new MembreRepository(@"Data Source=MIKEW10\TFTIC2014;Initial Catalog=XmasDb;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
IEnumerable <Membre> m = Mr.GetAll();
Assert.IsNotNull(m);
Assert.IsTrue(m.ToList().Count() >= 2);
}
public void GetOneMembre()
{
MembreRepository Mr = new MembreRepository(@"Data Source=MIKEW10\TFTIC2014;Initial Catalog=XmasDb;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
Membre m = Mr.GetOne(1);
Assert.IsNotNull(m);
Assert.AreEqual("Person", m.Nom);
}
// GET: Membre/Bien
public ActionResult DisplayProperties()
{
MembreRepository mr = new MembreRepository(ConfigurationManager.ConnectionStrings["CnstrDev"].ConnectionString);
int id = SessionUtils.ConnectedUser.Id;
//select comme for
//ici je retraduit le mapper de maptoDBModel a la requeque que j'ai fait
List <BienModel> ListeBien = mr.LoadBien(id).Select(c => MapToDBModel.BienToBienModel(c)).ToList();
return(View(ListeBien));
}
public void InsertMembre()
{
MembreRepository Mr = new MembreRepository(@"Data Source=MIKEW10\TFTIC2014;Initial Catalog=XmasDb;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
Membre m = new Membre();
m.Nom = "Gillis";
m.Prenom = "Cédric";
m.Surnom = "Mr Cheese";
m.Courriel = "*****@*****.**";
m.MotDePasse = "Test1234=";
m = Mr.Insert(m);
Assert.IsTrue(m.Id != 0);
}
public ActionResult Login(LoginModel lm)
{
// I intanciate a MembreRepository with the connectionstring.
// The connectionstring is stored into web.config and i get it with the ConfigurationManager
MembreRepository Cr = new MembreRepository(ConfigurationManager.ConnectionStrings["CnstrDev"].ConnectionString);
//I use the function VerifLogin from the MembreRepository
//For use this function, I have to convert The LoginModel to the
ProfileModel Mmodel = MapToDBModel.MemberToProfile(Cr.VerifLogin(MapToDBModel.LoginToMember(lm)));
if (Mmodel != null)
{
SessionUtils.ConnectedUser = Mmodel;
SessionUtils.IsConnected = true;
return(RedirectToAction("Index", new { controller = "Home", area = "Membre" }));
}
else
{
ViewBag.ErrorLoginMessage = "Error Login or Password";
return(RedirectToAction("Index", new { controller = "Home", area = "" }));
}
}
public ActionResult Login(LoginModel m)
{
//I intanciate a MembreRepository with the connectionstring.
// The connectionstring is stored into web.config and i get it with the ConfigurationManager
// If you want more information about ConfigurationManager don't forget to use F12.
MembreRepository Mr = new MembreRepository(ConfigurationManager.ConnectionStrings["CnstrDev"].ConnectionString);
//I use the function VerifLogin from the MembreRepository
//For use this function, I have to convert The LoginModel to the
ProfileModel Mmodel = MapToDBModel.MemberToProfile(Mr.VerifLogin(MapToDBModel.LoginToMembre(m)));
if (Mmodel != null)
{
SessionUtils.ConnectedUser = Mmodel;
SessionUtils.IsConnected = true;
return(RedirectToAction("Index", new { controller = "Home", area = "Membre" }));
}
else
{
ViewBag.ErrorLoginMessage = "Erreur Login/Mot de passe";
return(View());
}
}
public ViewResult Register(RegisterModel Rm, HttpPostedFileBase ProfilePicture)
{
//HttpPostedFileBase - Use to retrieve picture uploaded from form
//We have to verify the mime type and the image size
List <string> matchContentType = new List <string>()
{
"image/jpeg", "image/png", "image/gif"
};
if (!matchContentType.Contains(ProfilePicture.ContentType) || ProfilePicture.ContentLength > 80000)
{
ViewBag.ErrorMessage = "Le fichier ne possède pas une extension autorisée (png, jpg,gif)";
return(View("Login"));
}
//We can't save the file before to save the member in the database
//Check if data annotations are respected ==> See the RegisterModel Class
if (!ModelState.IsValid)
{
//I want to get all error on the model like wrong email format, wrong password repetiton,....
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
//add the error message into a viewbag to display on the view
ViewBag.ErrorMessage += error.ErrorMessage + "<br>";
}
}
}
else
{
MembreRepository Mr = new MembreRepository(ConfigurationManager.ConnectionStrings["CnstrDev"].ConnectionString);
//I have to call the Insert function from MembreRepository
//If the insert succeed, we get a complete Member with id value (calculated by the database)
//If the insert failed, we receive a null value
//We have to convert the registerModel(viewmodel) to a MembreModel(Dal) before to call the function
// this is why we call the static function RegisterToMembre from the Static lass MapToDBModel
Membre M = Mr.Insert(MapToDBModel.RegisterToMembre(Rm));
if (M != null)
{
//Now I can save the picture
//1 - Get the filename and extract the extension
string[] splitFileName = ProfilePicture.FileName.Split(new char[] { '.' }, StringSplitOptions.RemoveEmptyEntries);
string ext = splitFileName[splitFileName.Length - 1]; //Get the last collumn of the array which contains the extension of the picture
//2- Generate the new file name
string newFileName = M.Id + "." + ext;
//3- Save the picture
//3.1 - Get the physic path of the photos folder
string folderpath = Server.MapPath("~/photos/");
//3.2 - Combine folder path and new filename
string FileNameToSave = folderpath + "/" + newFileName;
//3.3 - Save
try
{
//SaveAs is a procedure and not a function thus we have to surround with try catch to
// get error if the SaveAs failed
ProfilePicture.SaveAs(FileNameToSave);
}
catch (Exception)
{
ViewBag.ErrorMessage = "L'image n'a pas pu être sauvée";
throw;
}
//I want to pre-fill the login html input if the register succeed.
//Thus , I use ViewBag to store the Email and a success message to communicate with the guest
ViewBag.Login = Rm.Email;
ViewBag.SuccessMessage = "Vous pouvez vous connecter";
}
else
{
//If there is an issuer, I want to dispay a message on the view.
//Thus I use Viewbag to send the message to the view
ViewBag.ErrorMessage = "Erreur lors de l'insertion";
}
}
return(View("Login"));
}