public static List<Room> GetAllActiveRooms() { var mongoRepository = new MongoRepository<Room>(ConnectionString); var oldestDate = DateTime.Now.Subtract(Constants.ActiveRoomTimeSpan); var x = mongoRepository.All(); var y = x.Where(r => r.DateLastPost >= oldestDate).ToList(); return mongoRepository.All().Where(r => r.DateLastPost >= oldestDate).ToList(); }
public static async Task <List <UsuarioModel> > ListaDeUsuariosAsync() { try { return(await Task.Run(() => _repo.All <UsuarioModel>().ToList())); } catch (Exception ex) { throw ex; } }
public override async Task ExecuteAsync(CancellationToken cancellationToken) { var mongoRepository = new MongoRepository <Translation>(new BaseDbBuilder()); var translations = mongoRepository.All() .Where(x => string.IsNullOrEmpty(x.Branch) && x.HasMissingTranslation()).ToList(); Log.Debug($"Running missing translations task. Missing translations: {translations.Count()}"); await new MissingTranslationsTask(translations).ExecuteAsync(); }
public void TestFilter() { var cardRepo = new MongoRepository<Card>(); var queryable = cardRepo.All(); var dateTime = DateTime.UtcNow.Date.AddDays(4); var f1 = queryable.ToList().Where(card => card.NextDate < dateTime).ToList(); var f2 = queryable.Where(card => card.NextDate < dateTime).ToList(); Console.WriteLine("f1 count = {0}", f1.Count); Console.WriteLine("f2 count = {0}", f2.Count); }
public ActionResult PartialTable() { ViewBag.StartYear = 2005; ViewBag.EndYear = 2012; if (CacheViewModel == null) { IRepository repository = new MongoRepository("mongodb://tserakhau.cloudapp.net", "Projects"); var regions = repository.All <Region>().ToList(); CacheViewModel = GenerateViewModel(regions); } return(PartialView(CacheViewModel)); }
public ActionResult PartialTableRegion(string id) { ViewBag.StartYear = 2005; ViewBag.EndYear = 2012; if (CacheViewModel == null) { IRepository repository = new MongoRepository("mongodb://tserakhau.cloudapp.net", "Projects"); var regions = repository.All <Region>().ToList(); CacheViewModel = GenerateViewModel(regions); } ViewBag.AveragesTotal = CacheViewModel.AveragesTotal; return(PartialView(CacheViewModel.Regions.FirstOrDefault(t => t.RegionName == id))); }
public void AddSprint() { var repo = new MongoRepository <Concert>(); var newSprint = new Concert { Artist = new Artist { Name = "Eddie Meduza" } }; repo.Add(newSprint); var sprint = repo.All(c => c.Artist.Name == "Eddie Meduza"); Assert.That(sprint, Is.EqualTo(newSprint)); }
public void AddSprint() { var repo = new MongoRepository<Concert>(); var newSprint = new Concert { Artist = new Artist { Name = "Eddie Meduza" } }; repo.Add(newSprint); var sprint = repo.All(c => c.Artist.Name == "Eddie Meduza"); Assert.That(sprint, Is.EqualTo(newSprint)); }
public async Task Notify() { /* * // Translate all: * var mongoRepository = new MongoRepository<Translation>(new BaseDbBuilder()); * var result = mongoRepository.All() * .Where(x => string.IsNullOrEmpty(x.Branch) && * (string.IsNullOrEmpty(x.Sv) || * string.IsNullOrEmpty(x.En) || * string.IsNullOrEmpty(x.Nb)) && * x.Da.Split(' ', StringSplitOptions.RemoveEmptyEntries).Count() <= 3); * * return result.Select(x => new GoogleTranslate(x).Execute()); */ var mongoRepository = new MongoRepository <Translation> (new BaseDbBuilder()); var translations = mongoRepository.All() .Where(x => string.IsNullOrEmpty(x.Branch) && x.HasMissingTranslation()).ToList(); Log.Debug($"Running missing translations task. Missing translations: {translations.Count()}"); await new MissingTranslationsTask(translations).ExecuteAsync(); }
public static async Task <List <EmpresaModel> > ListaDeEmpresasAsync() { return(await Task.Run(() => repo.All <EmpresaModel>().ToList())); }
public IQueryable <Objects.Account> GetAllAccounts(string AccountSid) { return(accountRepo.All(a => a.ParentSid == AccountSid)); }
public IEnumerable <Call> GetAllCalls(string AccountSid) { return(callRepo.All(a => a.AccountSid == AccountSid)); }
static void Main(string[] args) { var errorCount = 0; var client = new FacebookClient(FacebookAccessToken); var endpoint = string.Format("{0}/members?limit={1}", FacebookGroupId, Limit); var repository = new MongoRepository(new RepositoryKeys(), ConfigurationManager.AppSettings["MongoConnection"], ConfigurationManager.AppSettings["MongoDBName"]); while (true) { try { dynamic members = client.Get(endpoint); var actualUsers = new List <User> (); foreach (dynamic member in (JsonArray)members["data"]) { string id = member.id; User user = repository.Single <User> (id) ?? new User() { DateCreated = DateTime.Now }; user._id = id; user.FriendlyName = user.Username = member.name; user.IsAdmin = member.administrator; if (user.HasChanged()) { user.LastUpdated = DateTime.Now; repository.Save <User> (user); } actualUsers.Add(user); } var savedUsers = repository.All <User> ().Select(x => x._id); foreach (var user in savedUsers.Where(x => !actualUsers.Any(y => y._id == x))) { repository.Delete <User> (user); } } catch (FacebookOAuthException) { if (errorCount++ == 10) { return; } var admins = repository.Where <User> (new Dictionary <string, object> () { { "IsAdmin", true } }); var admin = admins.OrderByDescending(x => x.LastUpdated).FirstOrDefault(x => !string.IsNullOrEmpty(x.FacebookAccessToken) && x.FacebookAccessToken != FacebookAccessToken); if (admin != null) { FacebookAccessToken = admin.FacebookAccessToken; } } Thread.Sleep(600000 * (errorCount + 1)); } }
public static List<Room> GetAllRooms() { var mongoRepository = new MongoRepository<Room>(ConnectionString); return mongoRepository.All().ToList(); }
public IActionResult GetAudit() { return(new ObjectResult(_repository.All <Audit>())); }
public static async Task <List <ClienteModel> > ListaDeClientesAsync() { return(await Task.Run(() => repo.All <ClienteModel>().ToList())); }