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