public override AttractionTicket Translate(SqlCommand command, IDataRowReader reader)
        {
            if (!reader.Read())
            {
                throw new RecordNotFoundException(reservationID.ToString());
            }

            return(new AttractionTicket(reader.GetInt32("ReservationID"),
                                        reader.GetInt32("AttractionID"),
                                        reader.GetDateTime("TicketDate"),
                                        reader.GetFloat("Price")));
        }
Example #2
0
        public override IReadOnlyList <Employees> Translate(SqlCommand command, IDataRowReader reader)
        {
            var count = new List <Employees>();

            while (reader.Read())
            {
                count.Add(new Employees(
                              reader.GetInt32("employeeID"),
                              reader.GetString("Email"),
                              reader.GetString("Name"),
                              reader.GetString("Role"),
                              reader.GetFloat("Salary")));
            }

            return(count);
        }