public async Task <ActionResult> ChangePhoto(UserProfilView view) { var pic = string.Empty; var folder = "~/Content/Files"; // Charger la photo if (view.NewPhoto != null) { pic = FilesHelper.UploadFile(view.NewPhoto, folder); pic = string.Format("{0}/{1}", folder, pic); } else { pic = "~/Content/Files/user_avatar.png"; } var user = new User { DateNaissance = view.DateNaissance, Prenom = view.Prenom, Nom = view.Nom, Photo = view.Photo, IdUser = view.IdUser, Email = view.Email, Telephone = view.Telephone, IsActivated = true }; user.Photo = pic; db.Entry(user).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction($"{nameof(MyProfile)}/{user.IdUser}")); }
public async Task <ActionResult> MyProfile(UserProfilView view) { if (ModelState.IsValid) { //var connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; //SqlConnection connection = new SqlConnection(connectionString); ////var sql = @"UPDATE Users SET Email = " + view.Email + ", Nom = " + view.Nom + ", Prenom = " + view.Prenom + ////", Telephone = " + view.Telephone + " WHERE Users.IdUser = "******"UPDATE Users SET Email = " + view.Email + ", Nom = " + view.Nom + ", Prenom = " + view.Prenom + // ", Telephone = " + view.Telephone + " WHERE Users.IdUser = "******"DefaultConnection"].ConnectionString; SqlConnection connection = new SqlConnection(connectionString); string sql = "UPDATE Users SET Email = " + view.Email + ", Nom = " + view.Nom + ", Prenom = " + view.Prenom + ", Telephone = " + view.Telephone + " WHERE Users.IdUser = " + view.IdUser; try { connection.Open(); var command = new SqlCommand(sql, connection); await command.ExecuteNonQueryAsync(); } catch (Exception ex) { ex.ToString(); } //var user = new User //{ // IdUser = view.IdUser, // Email = view.Email, // Nom = view.Nom, // Prenom = view.Prenom, // DateNaissance = view.DateNaissance, // IsActivated = true, // Photo = view.Photo, // Telephone = view.Telephone //}; ////user.Photo = pic; //db.Entry(user).State = EntityState.Modified; //await db.SaveChangesAsync(); } return(View(view)); }
public async Task <ActionResult> ChangePhoto() { // On trouve l'utilisateur connecté var user = await db.Users.Where(u => u.Email == this.User.Identity.Name).FirstOrDefaultAsync(); var view = new UserProfilView { DateNaissance = user.DateNaissance, Prenom = user.Prenom, Nom = user.Nom, Photo = user.Photo, IdUser = user.IdUser, Email = user.Email, Telephone = user.Telephone }; return(View(view)); }