public IActionResult UpdateUsers([FromBody] UsersForUpdate users) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Response response; string decodedToken = JwTHelper.ValidateJwT(this.HttpContext.Request.Headers[Constants.JW_TOKEN_KEY]); dynamic tokenData = JObject.Parse(decodedToken); int userId = tokenData.UserId; if (string.IsNullOrEmpty(decodedToken) || userId != users.UserId) { HttpContext.Response.StatusCode = (int)HttpStatusCode.Forbidden; response = new Response("Invalid JwT", Constants.ERROR_MSG, null); return(new ObjectResult(response)); } int isUpdated = UsersHelper.UpdateUserDetails(users); if (isUpdated > 0) { this.HttpContext.Response.StatusCode = (int)HttpStatusCode.OK; response = new Response(Constants.SUCCESS_MSG, Constants.SUCCESS_MSG, 1); return(new ObjectResult(response)); } response = new Response(Constants.INTERNAL_SERVER_ERROR_MSG, Constants.ERROR_MSG, null); return(new ObjectResult(response)); }
/// <summary> /// Method to update the users. /// </summary> /// <param name="users"></param> /// <returns>1 if successfully update else -1.</returns> public static int UpdateUserDetails(UsersForUpdate users) { try { DbHelper dbHelper = new DbHelper(); MySqlConnection connection = dbHelper.GetMySqlConnection(); using (connection) { connection.Open(); MySqlCommand command = new MySqlCommand(Constants.SP_UPDATE_USER_DETAILS, connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("parUserId", users.UserId); command.Parameters.AddWithValue("parFirstName", users.FirstName); command.Parameters.AddWithValue("parLastName", users.LastName); command.Parameters.AddWithValue("parEmail", users.EmailAddress); command.Parameters.AddWithValue("parPhoneNumber", users.PhoneNumber); command.Parameters.AddWithValue("parPassword", users.Password); int id = Convert.ToInt32(command.ExecuteScalar()); return(id); } } catch (Exception e) { Logger.logError(typeof(UsersHelper).Name, e.ToString()); return(-1); } }