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