public List <Class> GetAllClasses(GetAllClassesRequest request) { List <Class> classes = null; if (request != null) { var dataAccess = new ClassDataAccess(request.Context); var classesQuery = dataAccess.GetAll(); classesQuery = classesQuery.Include(c => c.Academy); classes = classesQuery.ToList(); } return(classes); }
public void FixRoomDelete(Guid districtid) { District d; var mcs = "Data Source=yqdubo97gg.database.windows.net;Initial Catalog=ChalkableMaster;UID=chalkableadmin;Pwd=Hellowebapps1!"; using (var uow = new UnitOfWork(mcs, false)) { var da = new DistrictDataAccess(uow); d = da.GetById(districtid); } var cs = String.Format("Data Source={0};Initial Catalog={1};UID=chalkableadmin;Pwd=Hellowebapps1!", d.ServerUrl, d.Id); IList <SyncVersion> versions; using (var uow = new UnitOfWork(cs, true)) { versions = (new SyncVersionDataAccess(uow)).GetAll(); uow.Commit(); } var cl = ConnectorLocator.Create("Chalkable", d.SisPassword, d.SisUrl); var deletedRooms = (cl.SyncConnector.GetDiff(typeof(Room), versions.First(x => x.TableName == "Room").Version) as SyncResult <Room>).Deleted; using (var uow = new UnitOfWork(cs, true)) { var da = new ClassDataAccess(uow); var all = da.GetAll(); var classes = all.Where(x => deletedRooms.Any(y => x.RoomRef == y.RoomID)).ToList(); foreach (var @class in classes) { @class.RoomRef = null; } da.Update(classes.ToList()); uow.Commit(); } }