Beispiel #1
0
        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"));
        }
Beispiel #2
0
        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);
        }