public IEnumerable<User> FindAll()
{
var query = String.Format("SELECT * FROM Users");
using (var ctx = new SportsRfidTimerContext())
{
return ctx.Users.ToArray();
}
}
public void Delete(User entity)
{
using (var ctx = new SportsRfidTimerContext())
{
ctx.Users.Remove(entity);
ctx.SaveChanges();
}
}
public Race Get(Guid id)
{
Race race;
using (var ctx = new SportsRfidTimerContext())
{
race = ctx.Races.Find(id);
}
return race;
}
public User Get(Guid id)
{
User user;
using (var ctx = new SportsRfidTimerContext())
{
user = ctx.Users.Find(id);
}
return user;
}
public async Task<IEnumerable<User>> FindAsync(string text)
{
IEnumerable<User> result = Enumerable.Empty<User>();
var query = String.Format("Select * from Users Where {0} in Name OR {0} in Meta", text.Fnuttify());
using (var ctx = new SportsRfidTimerContext())
{
var users = ctx.Users.SqlQuery(query);
bool any = await users.AnyAsync();
if (any)
result = await users.ToArrayAsync();
}
return result;
}
public IEnumerable<User> Find(string text)
{
var query = String.Format("Select * from Users Where Name LIKE '%{0}%' OR Meta LIKE '%{0}%'", text);
using (var ctx = new SportsRfidTimerContext())
{
var users = ctx.Users.SqlQuery(query);
bool any = users.AnyAsync().Wait(TimeSpan.FromSeconds(1));
if (any)
{
return users.ToArray();
}
}
return Enumerable.Empty<User>();
}
public void Save(User entity)
{
using (var ctx = new SportsRfidTimerContext())
{
var user = ctx.Users.Find(entity.Id);
if (user != null)
{
user.Update(entity);
ctx.Users.Attach(user);
}
else
{
ctx.Users.Add(entity);
}
if (ctx.ChangeTracker.HasChanges())
Console.WriteLine("User Changed.");
ctx.SaveChanges();
}
}
public User FindByTag(string idString)
{
User result;
var query = String.Format("Select * from Users Where TagId = {0}", idString.Fnuttify());
using (var ctx = new SportsRfidTimerContext())
{
var users = ctx.Users.SqlQuery(query);
result = users.FirstOrDefault();
}
return result;
}