private MarketingYearDto ToDto(Entities.MarketingYear entity)
{
var dto = new MarketingYearDto
{
Id = entity.Id,
Start = entity.Start,
End = entity.End
};
return(dto);
}
public MarketingYearDto GetById(int marketingYearId)
{
using (var db = new DbContext())
{
Entities.MarketingYear marketingYear = db.MarketingYear.Find(marketingYearId);
MarketingYearDto dto = marketingYear == null ? null : ToDto(marketingYear);
return(dto);
}
}
public MarketingYearDto GetCurrent()
{
using (var db = new DbContext())
{
Entities.MarketingYear marketingYear = db.MarketingYear.FirstOrDefault(x => x.Start <= DateTime.Now && DateTime.Now <= x.End);
MarketingYearDto dto = marketingYear == null ? null : ToDto(marketingYear);
return(dto);
}
}
public IList <LaborDto> GetByMarketingYear(int marketingYearId)
{
using (var db = new DbContext())
{
Entities.MarketingYear marketingYear = db.MarketingYear.Find(marketingYearId);
List <Entities.Labor> expenses = db.Labor.Where(x => x.Date >= marketingYear.Start && x.Date <= marketingYear.End).ToList();
IList <LaborDto> dtos = ToDtos(expenses);
return(dtos);
}
}
public IList <CatchDto> GetByMarketingYear(int marketingYearId)
{
using (var db = new DbContext())
{
Entities.MarketingYear marketingYear = db.MarketingYear.Find(marketingYearId);
List <Entities.Catch> catches = db.Catch.Where(x => x.Date >= marketingYear.Start && x.Date <= marketingYear.End).ToList();
IList <CatchDto> dtos = ToDtos(catches);
return(dtos);
}
}
public IList <FodderDto> GetByMarketingYear(int marketingYearId)
{
using (var db = new DbContext())
{
Entities.MarketingYear marketingYear = db.MarketingYear.Find(marketingYearId);
List <Entities.Fodder> fodder = db.Fodder.Where(x => x.Date >= marketingYear.Start && x.Date <= marketingYear.End).ToList();
var dtos = ToDtos(fodder);
return(dtos);
}
}
public IList <HuntDto> GetByMarketingYear(int marketingYearId)
{
using (var db = new DbContext())
{
Entities.MarketingYear marketingYear = db.MarketingYear.Find(marketingYearId);
List <Entities.Hunt> hunts = db.Hunt.Where(x => x.Date >= marketingYear.Start && x.Date <= marketingYear.End).ToList();
IList <HuntDto> dtos = ToDtos(hunts);
return(dtos);
}
}
public IList <PastureDto> GetActiveByMarketingYear(int marketingYearId)
{
using (var db = new DbContext())
{
Entities.MarketingYear marketingYear = db.MarketingYear.Find(marketingYearId);
List <Entities.Pasture> pastures = db.Pasture.Where(x => !x.RemovedDate.HasValue && x.CreatedDate <= marketingYear.End).ToList();
IList <PastureDto> dtos = ToDtos(pastures);
return(dtos);
}
}
public IList <PulpitDto> GetByMarketingYear(int marketingYearId)
{
using (var db = new DbContext())
{
Entities.MarketingYear marketingYear = db.MarketingYear.Find(marketingYearId);
List <Entities.Pulpit> pulpits = db.Pulpit.Where(x => x.CreatedDate <= marketingYear.End && !x.RemovedDate.HasValue ||
x.RemovedDate >= marketingYear.Start && x.RemovedDate <= marketingYear.End).ToList();
IList <PulpitDto> dtos = ToDtos(pulpits);
return(dtos);
}
}
public IList <HuntedGameDto> GetByMarketingYear(int marketingYearId)
{
using (var db = new DbContext())
{
Entities.MarketingYear marketingYear = db.MarketingYear.Find(marketingYearId);
List <int?> huntedGameIds = db.Hunt.Where(x => x.Date >= marketingYear.Start && x.Date <= marketingYear.End && x.HuntedGameId != null).Select(x => x.HuntedGameId).ToList();
List <Entities.HuntedGame> huntedGames = db.HuntedGame.Where(x => huntedGameIds.Contains(x.Id)).ToList();
IList <HuntedGameDto> dtos = ToDtos(huntedGames);
return(dtos);
}
}
public int Insert(MarketingYearDto dto)
{
var entity = new Entities.MarketingYear
{
Start = dto.Start,
End = dto.End
};
using (var db = new DbContext())
{
Entities.MarketingYear newMarketingYear = db.MarketingYear.Add(entity);
db.SaveChanges();
return(newMarketingYear.Id);
}
}
public IList <LossGameDto> GetSanitaryLossesByMarketingYear(int marketingYearId)
{
using (var db = new DbContext())
{
Entities.MarketingYear marketingYear = db.MarketingYear.Find(marketingYearId);
List <Entities.LossGame> lossGames = (from loss in db.Loss
join lossGame in db.LossGame on loss.LossGameId equals lossGame.Id
where loss.Date >= marketingYear.Start && loss.Date <= marketingYear.End && loss.SanitaryLoss
select lossGame).ToList();
IList <LossGameDto> dtos = ToDtos(lossGames);
return(dtos);
}
}
public IList <CarcassRevenueDto> GetByMarketingYear(int marketingYearId)
{
using (var db = new DbContext())
{
Entities.MarketingYear marketingYear = db.MarketingYear.Find(marketingYearId);
List <Entities.CarcassRevenue> carcassRevenues =
(
from carcassRevenue in db.CarcassRevenue
join huntedGame in db.HuntedGame on carcassRevenue.HuntedGameId equals huntedGame.Id
join hunt in db.Hunt on huntedGame.Id equals hunt.HuntedGameId
where hunt.Date >= marketingYear.Start && hunt.Date <= marketingYear.End
select carcassRevenue
).ToList();
IList <CarcassRevenueDto> dtos = ToDtos(carcassRevenues);
return(dtos);
}
}
