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