public void Update(TClass item)
{
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
context.Entry(item).State = EntityState.Modified;
context.SaveChanges();
}
}
public async Task UpdateAsync(TClass item)
{
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
context.Entry(context.Set <TClass>()).State = EntityState.Modified;
await context.SaveChangesAsync();
}
}
public override async Task RemoveAsync(int id)
{
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
var playingPosition = context.PlayingPositions.FirstOrDefault(t => t.Id == id);
context.Entry(playingPosition).State = System.Data.Entity.EntityState.Deleted;
await context.SaveChangesAsync();
}
}
public override async Task RemoveAsync(int id)
{
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
var eventPlace = context.EventPlaces.FirstOrDefault(t => t.Id == id);
context.Entry(eventPlace).State = System.Data.Entity.EntityState.Deleted;
await context.SaveChangesAsync();
}
}
public override async Task RemoveAsync(int id)
{
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
var photo = context.Set <Photo>().FirstOrDefault(t => t.Id == id);
context.Entry(photo).State = System.Data.Entity.EntityState.Deleted;
await context.SaveChangesAsync();
}
}
public async Task RemoveAsync(int teamId, int userId)
{
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
var userArchTeam = context.UsersArchiveTeams.FirstOrDefault(t => t.ArchiveTeam_Id == teamId && t.User_Id == userId);
context.Entry(userArchTeam).State = System.Data.Entity.EntityState.Deleted;
await context.SaveChangesAsync();
}
}
public override async Task RemoveAsync(int id)
{
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
var agreedPlayersList = context.AgreedPlayersLists.FirstOrDefault(t => t.Id == id);
context.Entry(agreedPlayersList).State = System.Data.Entity.EntityState.Deleted;
await context.SaveChangesAsync();
}
}
public override void Remove(int id)
{
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
var message = context.Set <TClass>().FirstOrDefault(t => t.Id == id);
context.Entry(message).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
}
public override void Remove(int id)
{
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
var league = context.Leagues.FirstOrDefault(t => t.Id == id);
context.Entry(league).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
}
public override AgreedPlayersList GetById(int id)
{
AgreedPlayersList result = null;
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
result = context.AgreedPlayersLists.Where(t => t.Id == id).FirstOrDefault();
}
return(result);
}
public async Task <IEnumerable <TClass> > GetAllAsync()
{
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
return(await Task <IEnumerable <TClass> > .Factory.StartNew(() => {
return (from t in context.Set <TClass>()
select t).ToList();
}));
}
}
public override PlayingPosition GetById(int id)
{
PlayingPosition result = null;
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
result = context.PlayingPositions.Where(t => t.Id == id).FirstOrDefault();
}
return(result);
}
public override VisitLog GetById(int id)
{
VisitLog result = null;
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
result = context.Visits.Where(t => t.Id == id).FirstOrDefault();
}
return(result);
}
public override ArchiveTeam GetById(int id)
{
ArchiveTeam result = null;
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
result = context.ArchiveTeams.Where(t => t.Id == id).FirstOrDefault();
}
return(result);
}
public async Task <UserArchiveTeam> GetByIdAsync(int teamId, int userId)
{
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
return(await Task <UserArchiveTeam> .Factory.StartNew(() =>
{
return context.UsersArchiveTeams.Where(t => t.ArchiveTeam_Id == teamId && t.User_Id == userId).FirstOrDefault();
}));
}
}
public UserArchiveTeam GetById(int teamId, int userId)
{
UserArchiveTeam result = null;
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
result = context.UsersArchiveTeams.Where(t => t.ArchiveTeam_Id == teamId && t.User_Id == userId).FirstOrDefault();
}
return(result);
}
//[Authorize(Roles ="admin")]
public ActionResult GetUsers() //получение инф-и о пользователях
{
List <User> users = new List <User>();
using (SoccerIdDbContext db = new SoccerIdDbContext())
{
users = db.Users.ToList();
}
return(View(users));
}
public override async Task <PlayingPosition> GetByIdAsync(int id)
{
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
return(await Task <PlayingPosition> .Factory.StartNew(() =>
{
return context.PlayingPositions.Where(t => t.Id == id).FirstOrDefault();
}));
}
}
public override TeamEvent GetById(int id)
{
TeamEvent result = null;
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
result = context.TeamEvents.Where(t => t.Id == id).FirstOrDefault();
}
return(result);
}
public override async Task <AgreedPlayersList> GetByIdAsync(int id)
{
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
return(await Task <AgreedPlayersList> .Factory.StartNew(() =>
{
return context.AgreedPlayersLists.Where(t => t.Id == id).FirstOrDefault();
}));
}
}
public override TClass GetById(int id)
{
TClass result = null;
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
result = context.Set <TClass>().Where(t => t.Id == id).FirstOrDefault();
}
return(result);
}
public override async Task <TClass> GetByIdAsync(int id)
{
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
return(await Task <TClass> .Factory.StartNew(() =>
{
return context.Set <TClass>().Where(t => t.Id == id).FirstOrDefault();
}));
}
}
public override League GetById(int id)
{
League result = null;
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
result = context.Leagues.Where(t => t.Id == id).FirstOrDefault();
}
return(result);
}
public override async Task <League> GetByIdAsync(int id)
{
League result = null;
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
result = await context.Leagues.Where(t => t.Id == id).FirstOrDefaultAsync();
}
return(result);
}
public TClass Add(TClass item)
{
TClass result = null;
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
result = context.Set <TClass>().Add(item);
context.SaveChanges();
}
return(result);
}
public IEnumerable <TClass> GetAll()
{
IEnumerable <TClass> result = null;
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
result = (from t in context.Set <TClass>()
select t).ToList();
}
return(result);
}
public async Task <TClass> AddAsync(TClass item)
{
TClass result = null;
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
result = context.Set <TClass>().Add(item);
await context.SaveChangesAsync();
}
return(result);
}
public async Task <IEnumerable <TClass> > FindAsync(Func <TClass, bool> predicate, string navigationProperty = "")
{
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
return(await Task <IEnumerable <TClass> > .Factory.StartNew(() =>
{
if (String.IsNullOrEmpty(navigationProperty))
{
return (from t in context.Set <TClass>().Where(predicate)
select t).ToList();
}
else
{
return (from t in context.Set <TClass>().Include(navigationProperty).Where(predicate)
select t).ToList();
}
}));
}
}
public IEnumerable <TClass> Find(Func <TClass, bool> predicate, string navigationProperty = "")
{
IEnumerable <TClass> result = null;
using (SoccerIdDbContext context = new SoccerIdDbContext())
{
if (String.IsNullOrEmpty(navigationProperty))
{
result = (from t in context.Set <TClass>().Where(predicate)
select t).ToList();
}
else
{
result = (from t in context.Set <TClass>().Include(navigationProperty).Where(predicate)
select t).ToList();
}
}
return(result);
}
