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