public DataTable getBookings() { localhost.WebServiceDBReader dbReader = new localhost.WebServiceDBReader(); localhost.Booking[] bookingList = dbReader.GetBookings(); DataTable dtbl = new DataTable(); dtbl.Columns.Add("Customer No."); dtbl.Columns.Add("Destination No."); dtbl.Columns.Add("Date out"); dtbl.Columns.Add("Date home"); dtbl.Columns.Add("Booking No."); foreach (localhost.Booking b in bookingList) { var row = dtbl.NewRow(); row["Customer No."] = b.customerNbr; row["Destination No."] = b.destinationNbr; row["Date out"] = b.dateOut; row["Date home"] = b.dateHome; row["Booking No."] = b.bookingNbr; dtbl.Rows.Add(row); } return(dtbl); }
public DataTable getDestinations() { localhost.WebServiceDBReader dbReader = new localhost.WebServiceDBReader(); localhost.Destination[] destinationList = dbReader.GetDestinations(); DataTable dtbl = new DataTable(); dtbl.Columns.Add("Destination No."); dtbl.Columns.Add("City"); dtbl.Columns.Add("Country"); dtbl.Columns.Add("Hotel"); foreach (localhost.Destination d in destinationList) { var row = dtbl.NewRow(); row["Destination No."] = d.destinationNbr; row["City"] = d.city; row["Country"] = d.country; row["Hotel"] = d.hotel; dtbl.Rows.Add(row); } return(dtbl); }
public DataTable getCustomers() { localhost.WebServiceDBReader dbReader = new localhost.WebServiceDBReader(); localhost.Customer[] customerList = dbReader.GetCustomers(); DataTable dtbl = new DataTable(); dtbl.Columns.Add("Customer number"); dtbl.Columns.Add("Name"); dtbl.Columns.Add("Address"); dtbl.Columns.Add("Ssn"); foreach (localhost.Customer c in customerList) { var row = dtbl.NewRow(); row["Customer Number"] = c.idNbr; row["Name"] = c.name; row["Address"] = c.address; row["Ssn"] = c.ssn; dtbl.Rows.Add(row); } return(dtbl); }