static void Main(string[] args) { // Makes a variable object fleet that holds database information MySqlDb fleet = new MySqlDb("cs1", "cs371student", "whitworth", "cs371ado"); fleet.OpenConnection(); // FullyRolly is a variabe representing a list of type Full Roster List <FullRoster> FullyRolly = fleet.FullRosters(); fleet.OpenConnection(); // Pilot Qualifier holds the list of crew who can pilot List <FullRoster> PilotQualifier = fleet.PilotRosters(); // displays the roster Console.WriteLine("Full Roster:\n"); foreach (FullRoster s in FullyRolly) { Console.WriteLine("First Name: {0} Last Name: {1} \nAge: {2} Role: {3} \nShip Name: {4} Ship Registration: {5}", s.Fname, s.Lname, s.Age, s.role, s.shipName, s.shipRegs); Console.WriteLine("\n"); } // Displayes who can be a pilot Console.WriteLine("Pilot Qualified:\n"); foreach (FullRoster s in PilotQualifier) { Console.WriteLine("First Name: {0} Last Name: {1} \nAge: {2} Role: {3} \nShip Name: {4} Ship Registration: {5}", s.Fname, s.Lname, s.Age, s.role, s.shipName, s.shipRegs); Console.WriteLine("\n"); } }
static void Main(string[] args) { // Initialize the connection with Database MySqlDb chatdb = new MySqlDb("sql3.freesqldatabase.com", "sql3319340", "bFxgnIiN4x", "sql3319340"); chatdb.OpenConnection(); chatdb.displayAllMessages(); chatdb.OpenConnection(); chatdb.EnterMessage("Jerry", "Caird", "Hows it go?"); chatdb.displayAllMessages(); }
static void Main(string[] args) { MySqlDb fleet = new MySqlDb("db4free.net", "cs371student", "whitworth", "cs371ado"); fleet.OpenConnection(); List <Ship> ships = fleet.GetAllShips(); foreach (Ship s in ships) { Console.WriteLine("{0} has registration number {1}", s.Name, s.Registration); } }