public static Tap GetById(int id, int officeId)
{
using (var db = new DataContext())
{
var tap = db.Taps.FirstOrDefault(x => x.Id == id && x.OfficeId == officeId);
if (tap == null)
{
return(null);
}
var result = AutoMapper.Mapper.Map <Tap>(tap);
result.Keg = KegHelper.GetById(tap.KegId);
result.KegState = ChangeKegState(result.VolumeLeft, result.Keg.MinCapacity, result.Keg.MaxCapacity);
return(result);
}
}
public static IEnumerable <Tap> GetAllTapByOfficeId(int id)
{
using (var db = new DataContext())
{
var taps = db.Taps.Where(x => x.OfficeId == id).ToList();
var result = AutoMapper.Mapper.Map <IEnumerable <Tap> >(taps);
foreach (var tap in taps)
{
var keg = KegHelper.GetById(tap.KegId);
var item = result.FirstOrDefault(x => x.Id == tap.Id);
item.Keg = keg;
item.KegState = ChangeKegState(item.VolumeLeft, keg.MinCapacity, keg.MaxCapacity);
}
return(result);
}
}
public static void ReplaceKeg(int tapId, int officeId, int kegId)
{
using (var db = new DataContext())
{
var tap = db.Taps.FirstOrDefault(x => x.Id == tapId && x.OfficeId == officeId);
var keg = KegHelper.GetById(kegId);
if (tap == null)
{
throw new Exception(string.Format("Tap Resource with Office Id {0} and Tap Id {1} not found", officeId, tapId));
}
if (keg == null)
{
throw new Exception(string.Format("Keg Resource with Id {0} not found", kegId));
}
tap.KegId = kegId;
tap.VolumeLeft = keg.MaxCapacity;
db.Entry(tap).State = EntityState.Modified;
db.SaveChanges();
}
}