public void CreateBooking(string customerName, string startTime, DateTime bookingDate, string email, string telephone, List <string> packageNames, string licensePlate, string brand, string vat = "") { List <Package> packagesFromDB = dbc.Sp_GetAllPackages(); foreach (Package package in packagesFromDB) { pr.AddPackageToList(package); } List <Package> packages = new List <Package>(); foreach (string packageName in packageNames) { packages.Add(pr.FindPackage(packageName)); } Booking b = dbc.Sp_CreateBooking(customerName, startTime, bookingDate, email, telephone, packages, licensePlate, brand, vat); try { br.AddBookingToList(b); } catch (NullReferenceException e) { MessageBox.Show(e.Message); } }
public List <Booking> Sp_ShowBooking(DateTime bookingDate) { List <Booking> bookings = new List <Booking>(); List <Package> packages = new List <Package>(); List <Package> packagesFromDB = new List <Package>(); Booking b = null; string customerName = ""; string startTime = ""; string packageName = ""; string bookingId = ""; pr.AddPackageFromDBToList(Sp_GetAllPackages()); using (SqlConnection con = new SqlConnection(connectionString)) { try { con.Open(); SqlCommand cmd1 = new SqlCommand("Sp_ShowDailyBookings", con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.Add(new SqlParameter("@BookingDate", bookingDate)); SqlDataReader reader = cmd1.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { customerName = (reader["CustomerName"].ToString()); startTime = reader["StartTime"].ToString(); bookingId = reader["BookingID"].ToString(); using (SqlConnection con2 = new SqlConnection(connectionString2)) { try { con2.Open(); SqlCommand cmd2 = new SqlCommand("Sp_FindAllPackagesForBooking", con2); cmd2.CommandType = CommandType.StoredProcedure; cmd2.Parameters.Add(new SqlParameter("@BookingID", bookingId)); using (SqlDataReader reader2 = cmd2.ExecuteReader()) { if (reader2.HasRows) { while (reader2.Read()) { packageName = reader2["PackageName"].ToString(); packages.Add(pr.FindPackage(packageName)); } } } } catch (SqlException e) { Console.WriteLine("Ups" + e.Message); } } Customer customer = new Customer(customerName); b = new Booking(customer, startTime, bookingDate, packages); bookings.Add(b); } } } catch (SqlException e) { Console.WriteLine("Ups" + e.Message); } } return(bookings); }