public override Flight Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { return(null); } return(new Flight(reader.GetInt32("FlightID"), reader.GetString("AirlineName"), reader.GetDateTime("DepartureTime"), reader.GetDateTime("ArrivalTime"), reader.GetInt32("CityDepartureID"), reader.GetInt32("CityArrivalID"))); }
public override BindingList <Subject> Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { throw new RecordNotFoundException(subjectIds.ToString()); } BindingList <Subject> result = new BindingList <Subject>(); do { DOBSource source; if (reader.GetNullableString("DOBSource") == null) { source = DOBSource.none; } else { source = (DOBSource)Enum.Parse(typeof(DOBSource), reader.GetString("DOBSource")); } Subject next = new Subject( reader.GetInt32("SubjectID"), (EthnicGroup)Enum.Parse(typeof(EthnicGroup), reader.GetString("EthnicGroup")), reader.GetString("OAHeLPID"), reader.GetString("Sex")[0], //there is a GetChar function to use instead of this reader.GetNullableDateTime("DOB"), source, reader.GetNullableString("ICNumber"), reader.GetNullableInt32("MotherID"), reader.GetNullableInt32("FatherID"), reader.GetNullableString("PhotoFileName") ); Name name = new Name( reader.GetString("FirstName"), reader.GetString("MiddleNames"), reader.GetString("LastName")); Residence residence = null; if (!reader.IsNull("ResidenceDate") || !reader.IsNull("Villagename")) { residence = new Residence(reader.GetDateTime("ResidenceDate"), reader.GetString("VillageName")); } if (result.Contains(next)) { result[result.IndexOf(next)].AddName(name); result[result.IndexOf(next)].AddResidence(residence); } else { next.AddName(name); next.AddResidence(residence); result.Add(next); } }while (reader.Read()); return(result); }
public override HotelReservation Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { throw new RecordNotFoundException(reservationId.ToString()); } return(new HotelReservation(reservationId, reader.GetInt32("HotelID"), reader.GetDateTime("CheckInDate"), reader.GetDouble("Price"))); }
/// <summary> /// Method to create the objects with the information /// returned from the sql procedure. /// </summary> /// <param name="command">The Sql command</param> /// <param name="reader">The data row reader</param> /// <returns>A dictionary with the Movie as the key and the theater sales as the value</returns> public override Dictionary <Movie, double> Translate(SqlCommand command, IDataRowReader reader) { var movies = new Dictionary <Movie, double>(); while (reader.Read()) { movies.Add(new Movie(reader.GetInt32("MovieId"), reader.GetString("MovieTitle"), reader.GetString("Rating"), reader.GetInt32("RuntimeMinutes"), reader.GetDateTime("ReleaseDate")), reader.GetDouble("TheaterSales")); } return(movies); }
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 RestaurantReservation Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { return(null); } ; return(new RestaurantReservation(reader.GetInt32("ReservationID"), reader.GetDateTime("ReservationDate"), reservationID)); }
/// <summary> /// Method to create the objects with the information /// returned from the sql procedure. /// </summary> /// <param name="command">The Sql command</param> /// <param name="reader">The data row reader</param> /// <returns>The list of movies in the specified genre</returns> public override IReadOnlyList <Movie> Translate(SqlCommand command, IDataRowReader reader) { var movies = new List <Movie>(); while (reader.Read()) { movies.Add(new Movie(reader.GetInt32("MovieId"), reader.GetString("MovieTitle"), reader.GetString("Rating"), reader.GetInt32("RuntimeMinutes"), reader.GetDateTime("ReleaseDate"))); } return(movies); }
public override User Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { throw new RecordNotFoundException(userID.ToString()); } return(new User(userID, reader.GetString("FirstName"), reader.GetString("LastName"), reader.GetString("PhoneNumber"), reader.GetDateTime("LastCheckOutDate"))); }
public override CarRentalReservation Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { throw new RecordNotFoundException(reservationID.ToString()); } return(new CarRentalReservation(reader.GetInt32("ReservationID"), reader.GetInt32("CarRentalID"), reader.GetDateTime("RentalDate"), reader.GetString("Model"), reader.GetDouble("Price") )); }
public override User Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { return(null); } return(new User( reader.GetInt32("PersonId"), reader.GetString("FirstName"), reader.GetString("LastName"), phonenumber, reader.GetDateTime("LastCheckOutDate"))); }
public override Asset Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { throw new RecordNotFoundException(assetID.ToString()); } return(new Asset(assetID, reader.GetString("Name"), reader.GetInt32("AssetTypeID"), reader.GetInt32("CreatorID"), reader.GetDateTime("ReleaseDate"), reader.GetInt32("Stock"))); }
public override IReadOnlyList <HourReport> Translate(SqlCommand command, IDataRowReader reader) { var temp = new List <HourReport>(); while (reader.Read()) { temp.Add(new HourReport( reader.GetString("EmployeeName"), reader.GetDateTime("Hours"), reader.GetString("StreetAddress") ) ); } return(temp); }
public override IReadOnlyList <User> Translate(SqlCommand command, IDataRowReader reader) { var users = new List <User>(); while (reader.Read()) { users.Add(new User( reader.GetInt32("UserID"), reader.GetString("FirstName"), reader.GetString("LastName"), reader.GetString("PhoneNumber"), reader.GetDateTime("LastCheckOutDate"))); } return(users); }
public override IReadOnlyList <Asset> Translate(SqlCommand command, IDataRowReader reader) { var users = new List <Asset>(); while (reader.Read()) { users.Add(new Asset( reader.GetInt32("AssetID"), reader.GetString("Name"), reader.GetInt32("AssetTypeID"), reader.GetInt32("CreatorID"), reader.GetDateTime("ReleaseDate"), reader.GetInt32("Stock"))); } return(users); }
public override IReadOnlyList <Appointment> Translate(SqlCommand command, IDataRowReader reader) { var temp = new List <Appointment>(); while (reader.Read()) { temp.Add( new Appointment( reader.GetInt32("AppointmentID"), reader.GetInt32("LocationID"), reader.GetInt32("RepairID"), reader.GetInt32("CustomerID"), reader.GetDateTime("AppointmentTime") ) ); } return(temp); }
/// <summary> /// Method to create the objects with the information /// returned from the sql procedure. /// </summary> /// <param name="command">The Sql command</param> /// <param name="reader">The data row reader</param> /// <returns>The movie being searched for</returns> public override Movie Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { return(null); } return(new Movie(reader.GetInt32("MovieId"), MovieName, reader.GetString("Rating"), reader.GetInt32("RuntimeMinutes"), reader.GetDateTime("ReleaseDate"))); }
/// <summary> /// Method to create the objects with the information /// returned from the sql procedure. /// </summary> /// <param name="command">The Sql command</param> /// <param name="reader">The data row reader</param> /// <returns>The movie being searched for</returns> public override Movie Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { throw new RecordNotFoundException(MovieId.ToString()); } return(new Movie(MovieId, reader.GetString("MovieTitle"), reader.GetString("Rating"), reader.GetInt32("RuntimeMinutes"), reader.GetDateTime("ReleaseDate"))); }