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