public void SetUp()
{
transaction = new TransactionScope();
DALFactory factory = DALFactory.GetInstance();
db = factory.CreateDatabase();
dao = factory.CreateAreaDAO(db);
area1 = new Area {
Id = 1,
Name = "Hauptplatz"
};
area2 = new Area {
Id = 2,
Name = "Rathausplatz"
};
var sqls = new List<string> {
"SET FOREIGN_KEY_CHECKS=0",
"DELETE FROM `area`",
"INSERT INTO `area` VALUES (1, 'Hauptplatz')",
"INSERT INTO `area` VALUES (2, 'Rathausplatz')"
};
runDbCommands(db, sqls);
}
public ScheduleAreaViewModel(Area area,
ObservableCollection<TimeSlotViewModel> timeslots,
ObservableCollection<ScheduleVenueViewModel> venues,
IBusinessLogicAsync bl)
{
this.area = area;
TimeSlots = timeslots;
Venues = venues;
this.bl = bl;
}
private static void TestArea(IDatabase db, DALFactory dalFactory)
{
Console.WriteLine("*************************************");
Console.WriteLine("AREA TEST");
IAreaDAO areaDAO = dalFactory.CreateAreaDAO(db);
Console.WriteLine("\nAll areas:");
foreach (var area in areaDAO.GetAll()) {
Console.WriteLine(area);
}
Console.WriteLine("\nArea with ID=1:");
Area area1 = areaDAO.GetById(1);
Console.WriteLine(area1);
Area area2 = new Area() {
Name = "Rathausplatz"
};
}
public Task<IEnumerable<Venue>> GetVenuesForAreaAsync(Area area)
{
return Task.Run(() => GetVenuesForArea(area));
}
public abstract IEnumerable<Venue> GetVenuesForArea(Area area);
public void SetUp()
{
area = new Area();
}
public List<Venue> GetVenuesForArea(Area area)
{
return bl.GetVenuesForArea(area).ToList();
}
public AreaViewModel(Area area, IBusinessLogicAsync bl) {
this.area = area;
this.bl = bl;
Venues = new ObservableCollection<VenueViewModel>();
}
public IEnumerable<Venue> GetForArea(Area area)
{
var result = new List<Venue>();
var cmd = this.CreateSelectForAreaCommand(area);
using (IDataReader reader = this.db.ExecuteReader(cmd)) {
while (reader.Read()) {
result.Add(this.CreateVenueFromReader(reader));
}
}
return result;
}
private DbCommand CreateSelectForAreaCommand(Area area)
{
DbCommand cmd = this.db.CreateCommand(SQL_SELECT_FOR_AREA);
this.db.DefineParameter(cmd, "@AreaId", DbType.Int32, area.Id);
return cmd;
}
public override IEnumerable<Venue> GetVenuesForArea(Area area)
{
return dalFactory.CreateVenueDAO(db).GetForArea(area);
}
public static bool IsEqualTo(this Area a1, Area a2)
{
return a1.Id == a2.Id
&& a1.Name == a2.Name;
}
