private void LoadTickets()
{
DataTable dt = DataAccess.GetData("SELECT TicketID, DepartureAirport + ' - ' + ArrivalAirport + ' (' + CONVERT(VARCHAR(MAX), DepartureTime) + ')'AS TicketInfo FROM Ticket");
UIUtilities.FillListControl(cmbTickets, "TicketInfo", "TicketID", dt, true, "--- Choose a ticket ---");
}
private void LoadCustomers()
{
DataTable dtCustomers = DataAccess.GetData("SELECT CustomerID,FirstName + ' ' + LastName AS CustomerName FROM Customer");
UIUtilities.FillListControl(cmbCustomers, "CustomerName", "CustomerID", dtCustomers, true, "");
}
