// Constructor for any and all objects of type UserInterface public UserInterface(string connectionString, IVenueDAO venueDAO, ISpaceDAO spaceDAO, IReserveDAO reserveDAO) { this.connectionString = connectionString; this.venueDAO = venueDAO; this.spaceDAO = spaceDAO; this.reserveDAO = reserveDAO; }
public UserInterface(string connectionString) { this.connectionString = connectionString; venueDAO = new VenueSqlDAO(connectionString); cityDAO = new CitySqlDAO(connectionString); spaceDAO = new SpaceSqlDAO(connectionString); reservationDAO = new ReservationSqlDAO(connectionString); }
public void Run() { Conn.Open(); reservationDAO = new ReservationSqlDAO(Conn); spaceDAO = new SpaceSqlDAO(Conn); venueDAO = new VenueSqlDao(Conn); string menuSelection = ""; while (menuSelection != "Q") { DisplayMainMenu(); menuSelection = Console.ReadLine().ToUpper(); switch (menuSelection) { case "1": string venueListSelection = ""; while (venueListSelection != "R") { DisplayVenueList(); venueListSelection = Console.ReadLine().ToUpper(); if (venueListSelection != "R") { try { int menuID = int.Parse(venueListSelection); PrintVenueDetails(menuID); } catch (System.FormatException) { Console.WriteLine("Please enter a valid selection."); } } } break; case "Q": return; default: Console.WriteLine("Please enter a valid selection."); break; } } Conn.Close(); }
public void SetUp() { transaction = new TransactionScope(); DALFactory factory = DALFactory.GetInstance(); db = factory.CreateDatabase(); dao = factory.CreateVenueDAO(db); venue1 = new Venue { Id = 1, AreaId = 1, Description = "venue1", ShortDescription = "v1", Latitude = 18.00023020, Longitude = 34.0000023 }; venue2 = new Venue { Id = 2, AreaId = 2, Description = "venue2", ShortDescription = "v2", Latitude = 23.3020, Longitude = 4.0046573 }; IList<string> sqls = new List<string> { "SET FOREIGN_KEY_CHECKS=0", "DELETE FROM `venue`", "INSERT INTO `venue` (`id`, `area_id`, `desc`, `short_desc`, `latitude`, `longitude`) " + "VALUES (1, 1, 'venue1', 'v1', 18.00023020, 34.0000023)", "INSERT INTO `venue` (`id`, `area_id`, `desc`, `short_desc`, `latitude`, `longitude`) " + "VALUES (2, 2, 'venue2', 'v2', 23.3020, 4.0046573)" }; runDbCommands(db, sqls); }
public VenueBLO(IVenueDAO venueDAO) { this.venueDAO = venueDAO; }