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")); }