public Task <M> ReadAsync <M>(Func <DbSet <T>, M> query)
{
using (var context = new SchoolDB())
{
return(Task.FromResult(query(DbSet(context))));
}
}
public Task <T> ReadAsync <TId>(TId id) where TId : IComparable
{
using (var context = new SchoolDB())
{
return(Task.FromResult(DbSet(context).SingleOrDefault(x => CompareId(id, x))));
}
}
public Task <ICollection <T> > ReadAsync()
{
using (var context = new SchoolDB())
{
return(Task.FromResult <ICollection <T> >(DbSet(context).ToList()));
}
}
public async Task UpdateAsync <TId>(TId id, T entity) where TId : IComparable
{
using (var context = new SchoolDB())
{
UpdateGraph(context, entity);
await context.SaveChangesAsync();
}
}
public async Task <T> CreateAsync(T entity)
{
using (var context = new SchoolDB())
{
entity = DbSet(context).Add(entity);
await context.SaveChangesAsync();
return(entity);
}
}
protected void Application_Start()
{
SchoolDB.SetInitializer();
AreaRegistration.RegisterAllAreas();
GlobalConfiguration.Configure(WebApiConfig.Register);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
DependencyConfig.RegisterDependencies();
}
public async Task DeleteAsync <TId>(TId id) where TId : IComparable
{
using (var context = new SchoolDB())
{
Guid userId = Guid.Parse(id.ToString());
var entity = DbSet(context).SingleOrDefault(x => CompareId(id, x));
if (entity != null)
{
DbSet(context).Remove(entity);
await context.SaveChangesAsync();
}
}
}
public async Task <User> GetUserAsync(string username, string password)
{
using (var context = new SchoolDB())
{
var user = await DbSet(context).Include(x => x.Student).Include(x => x.Teacher).SingleOrDefaultAsync(x => x.UserName == username);
if (user != null)
{
if (user.UserPassword == password)
{
return(user);
}
}
return(null);
}
}
protected override void UpdateGraph(SchoolDB context, User entity)
{
context.UpdateGraph(entity);
}
protected override DbSet <User> DbSet(SchoolDB context)
{
return(context.Users);
}
public TestDtos()
{
context = new SchoolDB();
}
protected abstract void UpdateGraph(SchoolDB context, T entity);
protected abstract DbSet <T> DbSet(SchoolDB context);
protected override DbSet <Student> DbSet(SchoolDB context)
{
return(context.Students);
}
public StudentController(SchoolDB context)
{
_db = context;
}
protected override DbSet <Grade> DbSet(SchoolDB context)
{
return(context.Grades);
}
public GroupController(SchoolDB context)
{
_db = context;
}
protected override DbSet <Teacher> DbSet(SchoolDB context)
{
return(context.Teachers);
}
protected override DbSet <Subject> DbSet(SchoolDB context)
{
return(context.Subjects);
}
