public bool CreateUser(UserInfo userInfo) { var salt = _helper.GenerateSalt(); var pas = _helper.EncodePassword(userInfo.Password, salt); using (var connection = new SqlConnection(_configurationService.DatabaseConnectionString)) { using (var command = connection.CreateCommand()) { command.CommandType = CommandType.StoredProcedure; command.CommandText = "sp_CreateUser"; command.Parameters.AddWithValue("@Login", userInfo.Login).SqlDbType = SqlDbType.NVarChar; command.Parameters.AddWithValue("@Password", pas).SqlDbType = SqlDbType.NVarChar; command.Parameters.AddWithValue("@PasswordSalt", salt).SqlDbType = SqlDbType.NVarChar; command.Parameters.AddWithValue("@Email", userInfo.Email).SqlDbType = SqlDbType.NVarChar; command.Parameters.AddWithValue("@Fio", userInfo.Fio).SqlDbType = SqlDbType.NVarChar; command.Parameters.AddWithValue("@Address", userInfo.Address).SqlDbType = SqlDbType.NVarChar; command.Parameters.AddWithValue("@Phone", userInfo.Phone).SqlDbType = SqlDbType.NVarChar; command.Parameters.AddWithValue("@Mobile", userInfo.Mobile).SqlDbType = SqlDbType.NVarChar; command.Parameters.AddWithValue("@Country", userInfo.Country).SqlDbType = SqlDbType.Char; command.Parameters.AddWithValue("@Zip", userInfo.Zip).SqlDbType = SqlDbType.NVarChar; var retParam = command.Parameters.AddWithValue("@Return", SqlDbType.Int); retParam.Direction = ParameterDirection.ReturnValue; connection.Open(); command.ExecuteNonQuery(); return (int)retParam.Value == 1; } } }
public ResponseResult UpdateUserInfo(UserInfo userInfo) { return _administratorService.UpdateUserInfo(userInfo); }
public bool UpdateUserInfo(UserInfo userInfo) { using (var connection = new SqlConnection(_configurationService.DatabaseConnectionString)) { using (var command = connection.CreateCommand()) { command.CommandType = CommandType.StoredProcedure; command.CommandText = "sp_UpdateUserInfo"; command.Parameters.AddWithValue("@UserId", userInfo.UserId).SqlDbType = SqlDbType.UniqueIdentifier; command.Parameters.AddWithValue("@Login", userInfo.Login).SqlDbType = SqlDbType.NVarChar; command.Parameters.AddWithValue("@Email", userInfo.Email).SqlDbType = SqlDbType.NVarChar; command.Parameters.AddWithValue("@Fio", userInfo.Fio).SqlDbType = SqlDbType.NVarChar; command.Parameters.AddWithValue("@Phone", userInfo.Phone).SqlDbType = SqlDbType.NVarChar; command.Parameters.AddWithValue("@Address", userInfo.Address).SqlDbType = SqlDbType.NVarChar; command.Parameters.AddWithValue("@Mobile", userInfo.Mobile).SqlDbType = SqlDbType.NVarChar; command.Parameters.AddWithValue("@Country", userInfo.Country).SqlDbType = SqlDbType.NVarChar; command.Parameters.AddWithValue("@Zip", userInfo.Zip).SqlDbType = SqlDbType.NVarChar; var returnValue = command.Parameters.Add("@Return", SqlDbType.Int); returnValue.Direction = ParameterDirection.ReturnValue; connection.Open(); command.ExecuteNonQuery(); return (int)returnValue.Value == 1; } } }
public ResponseResult CreateUser(UserInfo userInfo) { return this._administratorService.CreateUser(userInfo); }