public Stats FindByBandId(int bandId) { using (var _db = new MusicBandContext()) { return(_db.Stats.Where(x => x.BandId == bandId).FirstOrDefault()); } }
public void Update(Stats item) { using (var _db = new MusicBandContext()) { _db.Entry(item).State = System.Data.Entity.EntityState.Modified; } }
public void Create(Stats item) { using (var _db = new MusicBandContext()) { _db.Stats.Add(item); } }
public IEnumerable <MusicianProfile> Get() { using (var _db = new MusicBandContext()) { return(_db.MusicianProfiles.AsNoTracking().ToList()); } }
public Song FindById(int id) { using (var _db = new MusicBandContext()) { return(_db.Songs.Find(id)); } }
public IEnumerable <Song> Get(Func <Song, bool> predicate) { using (var _db = new MusicBandContext()) { return(_db.Songs.AsNoTracking().Where(predicate).ToList()); } }
public IEnumerable <Performance> Get() { using (var _db = new MusicBandContext()) { return(_db.Performances.AsNoTracking().ToList()); } }
public IEnumerable <Performance> Get(Func <Performance, bool> predicate) { using (var _db = new MusicBandContext()) { return(_db.Performances.AsNoTracking().Where(predicate).ToList()); } }
private void UpdateStats(Band item) { using (var _db = new MusicBandContext()) { using (var transaction = _db.Database.BeginTransaction()) { try { _db.Entry(item).State = System.Data.Entity.EntityState.Modified; var stat = _db.Stats.FirstOrDefault(x => x.BandId == item.BandId); if (item.IsDeleted && !stat.IsDeleted) { stat.IsDeleted = true; } stat.NumberOfMusicians = item.Musicians.Count; stat.NumberOfSongs = item.Songs.Count; stat.RoyaltiesForAllSongs = item.Songs.Sum(x => x.Royalties); if (item.Songs.Any()) { stat.AverageRoyalties = item.Songs.Average(x => x.Royalties); } _db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); } } } }
public Performance FindById(int id) { using (var _db = new MusicBandContext()) { return(_db.Performances.Find(id)); } }
public IEnumerable <MusicianProfile> Get(Func <MusicianProfile, bool> predicate) { using (var _db = new MusicBandContext()) { return(_db.MusicianProfiles.AsNoTracking().Where(predicate).ToList()); } }
public IEnumerable <Song> Get() { using (var _db = new MusicBandContext()) { return(_db.Songs.AsNoTracking().ToList()); } }
public MusicianProfile FindById(int id) { using (var _db = new MusicBandContext()) { return(_db.MusicianProfiles.Find(id)); } }
public void Create(Performance item) { using (var _db = new MusicBandContext()) { _db.Performances.Add(item); _db.SaveChanges(); } }
public void Create(Song item) { using (var _db = new MusicBandContext()) { _db.Songs.Add(item); _db.SaveChanges(); } }
public void Create(MusicianProfile item) { using (var _db = new MusicBandContext()) { _db.MusicianProfiles.Add(item); _db.SaveChanges(); } }
public void Delete(Stats item) { using (var _db = new MusicBandContext()) { item.IsDeleted = true; _db.Entry(item).State = System.Data.Entity.EntityState.Modified; } }
public void Update(Song item) { using (var _db = new MusicBandContext()) { _db.Entry(item).State = System.Data.Entity.EntityState.Modified; _db.SaveChanges(); } }
public void Delete(Performance item) { using (var _db = new MusicBandContext()) { item.IsDeleted = true; _db.Entry(item).State = System.Data.Entity.EntityState.Modified; _db.SaveChanges(); } }
public void Create(Band item) { using (var _db = new MusicBandContext()) { using (var transaction = _db.Database.BeginTransaction()) { try { _db.Bands.Add(item); _db.Stats.Add(new Stats() { Band = item }); _db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); } } } }