public List <OwnedItemDAL> GetOwnedItemsRelatedToUser(int UserID, int skip, int take) { List <OwnedItemDAL> proposedReturnValue = new List <OwnedItemDAL>(); try { EnsureConnected(); using (SqlCommand command = new SqlCommand("GetOwnedItemsRelatedToUser", _connection)) { command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@Skip", skip); command.Parameters.AddWithValue("@Take", take); command.Parameters.AddWithValue("@userID", UserID); using (SqlDataReader reader = command.ExecuteReader()) { OwnedItemMapper m = new OwnedItemMapper(reader); while (reader.Read()) { OwnedItemDAL r = m.OwnedItemFromReader(reader); proposedReturnValue.Add(r); } } } } catch (Exception ex) when(Log(ex)) { } return(proposedReturnValue); }
public OwnedItemDAL OwnedItemFromReader(SqlDataReader reader) { OwnedItemDAL proposedReturnValue = new OwnedItemDAL(); proposedReturnValue.OwnedItemID = reader.GetInt32(OffsetToItemID); proposedReturnValue.OwnerID = GetInt32OrDefault(reader, OffsetToUserID); proposedReturnValue.ItemDescription = GetStringOrDefault(reader, OffsetToDescription); proposedReturnValue.ItemPrice = GetDecimalOrDefault(reader, OffsetToItemPrice); proposedReturnValue.EMail = GetStringOrDefault(reader, OffsetToEMail); return(proposedReturnValue); }
public OwnedItemDAL FindOwnedItemByID(int ItemID) { OwnedItemDAL ProposedReturnValue = null; try { EnsureConnected(); using (SqlCommand command = new SqlCommand("FindOwnedItemByID", _connection)) { command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@ItemID", ItemID); // need to configure the Text, Type and Parameters // text was configured in the ctor (Line 58) // type in line 60 // parameters in line 61 using (SqlDataReader reader = command.ExecuteReader()) { OwnedItemMapper m = new OwnedItemMapper(reader); int count = 0; while (reader.Read()) { ProposedReturnValue = m.OwnedItemFromReader(reader); count++; } if (count > 1) { throw new Exception($"Found more than 1 User with key {ItemID}"); } } } } catch (Exception ex) when(Log(ex)) { } return(ProposedReturnValue); }