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