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