public Response() { Movie = new MovieInfo(); Movies = new List<MovieInfo>(); Actors = new List<Actor>(); Rental = new RentalInfo(); Rentals = new List<RentalInfo>(); }
private RentalInfo PopulateBorrowerFromDataReader(SqlDataReader dr) { // to save info to the right fields and populate class with borrower RentalInfo borrower = new RentalInfo(); borrower.Borrower.BorrowerID = (int)dr["BorrowerID"]; borrower.Borrower.FirstName = dr["FirstName"].ToString(); borrower.Borrower.LastName = dr["LastName"].ToString(); return borrower; }
private RentalInfo PopulateRentalInfoFromDataReader(SqlDataReader dr) { var rental = new RentalInfo(); rental.Borrower.BorrowerID = (int)dr["BorrowerID"]; rental.Borrower.FirstName = dr["bFirstName"].ToString(); rental.Borrower.LastName = dr["bLastName"].ToString(); rental.Movie = PopulateMovieInfoFromDataReader(dr); if (dr["UserNotes"] != DBNull.Value) rental.UserNotes = dr["UserNotes"].ToString(); if (dr["UserRating"] != DBNull.Value) rental.UserRating = (int)dr["UserRating"]; if (dr["DateBorrowed"] != DBNull.Value) rental.RentalDate = DateTime.Parse(dr["DateBorrowed"].ToString()); if (dr["DateReturned"] != DBNull.Value) rental.ReturnDate = DateTime.Parse(dr["DateReturned"].ToString()); return rental; }
//public List<RentalInfo> GetAllBorrowersInfo() //{ // using (SqlConnection cn = new SqlConnection(Settings.ConnectionString)) // { // SqlCommand cmd = new SqlCommand(); // cmd.CommandText = "select mb.DateBorrowed, mb.DateReturned, mb.UserNotes, mb.UserRating, b.FirstName as bFirstName, b.LastName as bLastName, m.MovieTitle , b.borrowerID, " + "m.movieID, mp.filmrating , d.directorID, d.FirstName as dFirstName, d.LastName as dLastName, m.studioID, s.studioname, m.releasedate " + // "from MovieBorrower mb " + // "inner join Borrowers b " + // "on b.BorrowerID = mb.BorrowerID " + // "join Movies m " + // "on m.MovieID = mb.MovieID " + // "join mpaaratings mp " + // "on m.mpaaratingid = mp.mpaaratingid " + // "join Directors d " + // "on m.directorid = d.directorid " + // "join studios s " + // "on m.studioid = s.studioid"; // cmd.Connection = cn; // cn.Open(); // using (SqlDataReader dr = cmd.ExecuteReader()) // { // while (dr.Read()) // { // Rentals.Add(PopulateRentalInfoFromDataReader(dr)); // } // } // } // return Rentals; //} public RentalInfo GetBorrowerByID(int borrowerID) { // processes and returns borrower with number to identify specific borrower RentalInfo borrower = new RentalInfo(); using (var cn = new SqlConnection(Settings.ConnectionString)) { var cmd = new SqlCommand(); cmd.CommandText = "select * " + " from Borrowers b " + "where b.BorrowerID = @BorrowerID"; cmd.Connection = cn; cmd.Parameters.AddWithValue("@BorrowerID", borrowerID); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { borrower = PopulateBorrowerFromDataReader(dr); } } } return borrower; }