public ActionResult EditUser(EditUserBindingModel model) { if (ModelState.IsValid) { EditUserResultModel editedUser = new EditUserResultModel { UserId = model.UserId, Username = model.Username, Password = model.Password }; try { // using (HttpClient client = new HttpClient()) // { // var postTask = client.PostAsJsonAsync("http://localhost:52680/user/edituser/", editedUser); // postTask.Wait(); // // var result = postTask.Result; // } WebRequestManager.HttpPost("http://localhost:52680/user/edituser/", editedUser); } catch (Exception ex) { var error = ex; } } return(View("~/Views/Home/Index.cshtml")); }
public EditUserResultModel EditUser([FromBody] EditUserBindingModel model) { var editedUser = new EditUserResultModel(); if (ModelState.IsValid) { editedUser.Username = model.Username; editedUser.Password = model.Password; editedUser.UserId = model.UserId; try { using (SqlConnection connection = new SqlConnection(ConnectionStrings.connectionString)) { SqlCommand command = new SqlCommand(UserQueries.EditUser, connection); command.Parameters.AddWithValue("@inUserId", editedUser.UserId); command.Parameters.AddWithValue("@inUsername", editedUser.Username); command.Parameters.AddWithValue("@inPassword", editedUser.Password); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int code = (int)(reader["Code"] == DBNull.Value ? -1 : int.Parse(reader["Code"].ToString())); string message = (string)(reader["Msg"] == DBNull.Value ? "" : (reader["Msg"].ToString())); string username = (string)(reader["User"] == DBNull.Value ? "" : (reader["User"].ToString())); string pass = (string)(reader["Password"] == DBNull.Value ? "" : (reader["Password"].ToString())); int userId = (int)(reader["UserId"] == DBNull.Value ? -1 : int.Parse((reader["UserId"].ToString()))); editedUser = new EditUserResultModel { Username = username, Message = message, Code = code, UserId = userId, Password = pass }; } reader.Close(); } } catch (Exception ex) { var error = ex; } } return(editedUser); }