public void UpdateProfileInfo(UpdateProfileInfoViewModel model)
{
if (ModelState.IsValid)
{
string uid = User.Identity.GetUserId();
SqlCommand command;
if (model.Name.Equals("nme"))
{
command = new SqlCommand(
"UPDATE AspNetUsers " +
"SET UserName = @username " +
"WHERE ID= @id");
}
else
{
command = new SqlCommand(
"UPDATE AspNetUsers " +
"SET ProfileBio = @profilebio " +
"WHERE ID= @id");
}
SqlParameter UID = new SqlParameter
{
ParameterName = "@id",
Value = uid
};
SqlParameter UNM = new SqlParameter
{
ParameterName = "@username",
Value = model.Info
};
SqlParameter BIO = new SqlParameter
{
ParameterName = "@profilebio",
Value = model.Info
};
command.Parameters.Add(UID);
command.Parameters.Add(UNM);
command.Parameters.Add(BIO);
Utility.Constants.CallDB(command);
}
}
public async Task <IActionResult> UpdateProfileInfo([FromForm] UpdateProfileInfoViewModel model)
{
var user = await _userService.CurrentUser();
var profile = await _context.Profiles.Where(u => u.AccountId.Equals(user.Id)).FirstOrDefaultAsync();
profile.FirstName = model.FirstName;
profile.LastName = model.LastName;
profile.FatherName = model.FatherName;
profile.CodeMeli = model.CodeMeli;
profile.Description = model.Description;
_context.Entry(profile).State = EntityState.Modified;
bool result = Convert.ToBoolean(await _context.SaveChangesAsync());
if (result)
{
return(Ok(profile));
}
return(BadRequest());
}
