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