// 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;
}
