public static void SeedRentals() { // Read the contents of the file string s = File.ReadAllText("..\\..\\..\\MovieRentals\\App_Data\\rentals.json"); // Parse the contents using JSON.NET JArray data = (JArray)JsonConvert.DeserializeObject(s); RentalRepository repository = new RentalRepository(); int indexNumber = 1; // Process the data foreach (JToken token in data) { Rental r = new Rental(); r.Id = indexNumber; r.CheckoutDate = token["checkout_date"].Value<string>(); r.ReturnedDate = token["returned_date"].Value<string>(); r.RentalTime = token["rental_time"].Value<string>(); r.Cost = token["cost"].Value<string>(); r.Total = token["total"].Value<string>(); r.CustomerId = token["customer_id"].Value<int>(); r.MovieId = token["movie_id"].Value<int>(); repository.Add(r); indexNumber++; } }
public void Add(Rental rental) { db.Open(); try { SqlCommand command = new SqlCommand( "insert into rentals (id, CheckoutDate, ReturnedDate, Cost, Total, CustomerId, MovieId) values (@id, @checkout_date, @returned_date, @cost, @total, @customer_id, @movie_id)", this.db); command.Parameters.AddWithValue("@id", rental.Id); command.Parameters.AddWithValue("@checkout_date", rental.CheckoutDate); command.Parameters.AddWithValue("@returned_date", rental.ReturnedDate); command.Parameters.AddWithValue("@cost", rental.Cost); command.Parameters.AddWithValue("@total", rental.Total); command.Parameters.AddWithValue("@customer_id", rental.CustomerId); command.Parameters.AddWithValue("@movie_id", rental.MovieId); command.ExecuteNonQuery(); } finally { db.Close(); } }
public Rental Update(Rental rental) { throw new NotImplementedException(); }