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