public int?Insert(UserAdmittance item)
{
var loginParam = new SqlParameter
{
ParameterName = "@Login",
Value = item.Login
};
var passwordHashParam = new SqlParameter
{
ParameterName = "@PasswordHash",
Value = item.PasswordHash
};
var statusParam = new SqlParameter
{
ParameterName = "@Status",
Value = item.UserStatus.GetStatusName()
};
var roleParam = new SqlParameter
{
ParameterName = "@Role",
Value = item.UserRole.GetRoleName()
};
var resultCommand = ExecuteCommand(SpInsert, loginParam, passwordHashParam, statusParam, roleParam);
int?result = null;
if (resultCommand != null)
{
decimal lastId = (decimal)resultCommand;
result = Decimal.ToInt32(lastId);
}
return(result);
}
public UserSystem(string firsName, string lastName, string email, string phone, int userAdmittanceId)
{
FirsName = firsName;
LastName = lastName;
Email = email;
Phone = phone;
UserAdmittanceId = userAdmittanceId;
UserAdmittance = null;
}
public UserSystem(string firsName, string lastName, string email, string phone, UserAdmittance userAdmittance)
{
FirsName = firsName;
LastName = lastName;
Email = email;
Phone = phone;
if (userAdmittance?.IdEntity != null)
{
UserAdmittanceId = userAdmittance.IdEntity.Value;
}
UserAdmittance = userAdmittance;
}
private List <UserSystem> ReadUsers(string storedProcedureName, params SqlParameter[] sqlParameters)
{
List <UserSystem> users = new List <UserSystem>();
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(storedProcedureName, connection)
{
CommandType = System.Data.CommandType.StoredProcedure
};
foreach (SqlParameter sqlParameter in sqlParameters)
{
command.Parameters.Add(sqlParameter);
}
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
int readId = reader.GetInt32(0);
string readFirstName = reader.GetString(1);
string readLastName = reader.GetString(2);
string readEmail = reader.GetString(3);
string readPhone = reader.GetString(4);
int readAccessId = reader.GetInt32(5);
UserAdmittance userAdmittance = _userAdmittanceRepository.SelectById(readAccessId);
UserSystem userSystem = new UserSystem(readId, readFirstName, readLastName, readEmail, readPhone, userAdmittance);
users.Add(userSystem);
}
}
}
return(users);
}
private List <UserAdmittance> ReadUserAccesses(string storedProcedureName, params SqlParameter[] sqlParameters)
{
List <UserAdmittance> list = new List <UserAdmittance>();
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(storedProcedureName, connection)
{
CommandType = System.Data.CommandType.StoredProcedure
};
foreach (SqlParameter sqlParameter in sqlParameters)
{
command.Parameters.Add(sqlParameter);
}
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
int readId = reader.GetInt32(0);
string readLogin = reader.GetString(1);
string readPassword = reader.GetString(2);
string readStatus = reader.GetString(3);
string readRole = reader.GetString(4);
UserAdmittance userAdmittance = new UserAdmittance(readId, readLogin, readPassword, readStatus, readRole);
list.Add(userAdmittance);
}
}
}
return(list);
}
public bool Update(UserAdmittance item)
{
if (!item.IdEntity.HasValue)
{
throw new ArgumentException($"Parameter{nameof(item.IdEntity)} must be not empty", nameof(item.IdEntity));
}
var idParam = new SqlParameter
{
ParameterName = "@IdEntity",
Value = item.IdEntity.Value
};
var loginParam = new SqlParameter
{
ParameterName = "@Login",
Value = item.Login
};
var passwordHashParam = new SqlParameter
{
ParameterName = "@PasswordHash",
Value = item.PasswordHash
};
var statusParam = new SqlParameter
{
ParameterName = "@Status",
Value = item.UserStatus.GetStatusName()
};
var roleParam = new SqlParameter
{
ParameterName = "@Role",
Value = item.UserRole.GetRoleName()
};
var resultCommand = ExecuteCommand(SpUpdate, idParam, loginParam, passwordHashParam, statusParam, roleParam);
return(resultCommand != null && (int)resultCommand == 1);
}
public bool Update(UserAdmittance item)
{
return(_userAdmittanceRepository.Update(item));
}
public int?Insert(UserAdmittance item)
{
return(_userAdmittanceRepository.Insert(item));
}
public ServiceResult CreatByRegistration(SystemUserData userData)
{
#region Check uniq login
bool loginIsUnique = _dbContext.UserAdmittances.LoginUserIsUnique(userData.Login);
if (!loginIsUnique)
{
var typeError = ServiceResult.ResultConnectionEnum.InvalidRequestData;
var resultError = new ServiceResult(typeError, "User with the same name already exists!");
return(resultError);
}
#endregion
string passwordHash;
passwordHash = _passwordHash.GeneratePasswordHash(userData.Login, userData.NewPassword);
var userStatus = new UserStatus(userData.Status);
var userRole = new UserRole(userData.Role);
var userAdmittance = new UserAdmittance(userData.Login, passwordHash, userStatus, userRole);
var systemUser = new UserSystem
{
FirsName = userData.FirstName,
LastName = userData.LastName,
Phone = userData.Phone,
Email = userData.Email,
UserAdmittance = userAdmittance
};
bool userIsSave;
#region Save new user
int?idUserAdmittance = _dbContext.UserAdmittances.Insert(systemUser.UserAdmittance);
if (idUserAdmittance.HasValue && idUserAdmittance.Value > 0)
{
systemUser.UserAdmittanceId = idUserAdmittance.Value;
int?idUser = _dbContext.UsersSystem.Insert(systemUser);
if (idUser.HasValue && idUser > 0)
{
userIsSave = true;
}
else
{
_dbContext.UserAdmittances.Delete(idUserAdmittance.Value);
userIsSave = false;
}
}
else
{
userIsSave = false;
}
#endregion
if (!userIsSave)
{
var typeError = ServiceResult.ResultConnectionEnum.SystemError;
var resultError = new ServiceResult(typeError, "Save new user failed, please try again");
return(resultError);
}
var typeResult = ServiceResult.ResultConnectionEnum.Correct;
var result = new ServiceResult(typeResult, "Save new user completed");
return(result);
}
