public UserOrder SelectById(int id)
{
UserOrder userOrder = null;
var idParam = new SqlParameter
{
ParameterName = "@IdEntity",
Value = id
};
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
SqlCommand commandSelectUserOrder = new SqlCommand(SpSelectById, connection)
{
CommandType = System.Data.CommandType.StoredProcedure
};
commandSelectUserOrder.Parameters.Add(idParam);
SqlDataReader reader = commandSelectUserOrder.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
int readId = reader.GetInt32(0);
DateTime readDate = reader.GetDateTime(1);
string readAddress = reader.GetString(2);
string readStatus = reader.GetString(3);
int readIdUser = reader.GetInt32(4);
int readIdProduct = reader.GetInt32(5);
Product product = _productRepository.SelectById(readIdProduct);
UserSystem userSystem = _userSystemRepository.SelectById(readIdUser);
userOrder = new UserOrder(readId, readDate, readAddress, readStatus, userSystem, new List <Product>());
userOrder.Products.Add(product);
while (reader.Read())
{
readIdProduct = reader.GetInt32(5);
product = _productRepository.SelectById(readIdProduct);
userOrder.Products.Add(product);
}
}
}
return(userOrder);
}
private List <UserAuthorizationToken> ReadUserAuthorizations(string storedProcedureName, params SqlParameter[] sqlParameters)
{
var userAuthorizations = new List <UserAuthorizationToken>();
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);
DateTime readDateStart = reader.GetDateTime(1);
DateTime readDateFinish = reader.GetDateTime(2);
string readToken = reader.GetString(3);
string readStatus = reader.GetString(4);
int readUserId = reader.GetInt32(5);
UserSystem user = _repositorySystemRepository.SelectById(readUserId);
UserAuthorizationToken userAuthorization = new UserAuthorizationToken(readId, readDateStart,
readDateFinish, readToken, readStatus, user);
userAuthorizations.Add(userAuthorization);
}
}
}
return(userAuthorizations);
}
