public FieldPlanViewModel GetFieldPlanViewModel(int marketingYearId)
{
FieldPlanDto fieldPlanDto = _fieldPlanDao.GetByMarketingYear(marketingYearId);
FiledPlanModel filedPlanModel = null;
if (fieldPlanDto != null)
{
filedPlanModel = new FiledPlanModel
{
Hectare = fieldPlanDto.Hectare
};
}
MarketingYearModel marketingYearModel = _marketingYearService.GetMarketingYearModel(marketingYearId);
AnnualPlanStatusModel annualPlanStatusModel = _annualPlanStatusService.GetByMarketingYearId(marketingYearId);
var fieldPlanViewModel = new FieldPlanViewModel
{
FiledPlanModel = filedPlanModel,
MarketingYearModel = marketingYearModel,
AnnualPlanStatusModel = annualPlanStatusModel
};
return(fieldPlanViewModel);
}
public void GetByMarketingYearTest()
{
int marketingYearId = 3;
FieldPlanDto results = _fieldPlanDao.GetByMarketingYear(marketingYearId);
Assert.That(results, Is.Not.Null);
}
public void UpdateFieldPlan(FiledPlanModel model, int marketingYearId)
{
var dto = new FieldPlanDto
{
Hectare = model.Hectare,
MarketingYearId = marketingYearId
};
_fieldPlanDao.Update(dto);
}
private FieldPlanDto ToDto(Entities.FieldPlan entity)
{
var dto = new FieldPlanDto
{
Id = entity.Id,
Hectare = entity.Hectare,
MarketingYearId = entity.MarketingYearId
};
return(dto);
}
public void Update(FieldPlanDto dto)
{
using (var db = new DbContext())
{
Entities.FieldPlan fieldPlan = db.FieldPlan.Single(x => x.MarketingYearId == dto.MarketingYearId);
fieldPlan.Hectare = dto.Hectare;
db.SaveChanges();
}
}
private FieldPlanModel GetFieldPlanModel()
{
FieldPlanDto previousMarketingYearFieldPlan = _fieldPlanDao.GetByMarketingYear(PreviousMarketingYearId);
FieldPlanDto currentMarketingYearFieldPlan = _fieldPlanDao.GetByMarketingYear(CurrentMarketingYearId);
var fieldPlanModel = new FieldPlanModel
{
PreviousPlan = previousMarketingYearFieldPlan?.Hectare ?? 0,
Execution = 0, //TODO: Add Field utility
CurrentState = 0,
FutureState = currentMarketingYearFieldPlan?.Hectare ?? 0
};
return(fieldPlanModel);
}
public void Insert(FieldPlanDto dto)
{
var entity = new Entities.FieldPlan
{
Id = dto.Id,
Hectare = dto.Hectare,
MarketingYearId = dto.MarketingYearId
};
using (var db = new DbContext())
{
db.FieldPlan.Add(entity);
db.SaveChanges();
}
}
public FieldPlanDto GetByMarketingYear(int marketingYearId)
{
using (var db = new DbContext())
{
Entities.FieldPlan fieldPlan = db.FieldPlan.FirstOrDefault(x => x.MarketingYearId == marketingYearId);
if (fieldPlan == null)
{
return(null);
}
FieldPlanDto dto = ToDto(fieldPlan);
return(dto);
}
}
public void AddFieldPlan(FiledPlanModel model, int marketingYearId)
{
FieldPlanDto existingFieldPlanDto = _fieldPlanDao.GetByMarketingYear(marketingYearId);
if (existingFieldPlanDto != null)
{
throw new Exception("Plan gospodarczy powierzchni łąk śródleśnych i przyleśnych już istnieje! Proszę użyć opcji edycji istniejącego już planu.");
}
var dto = new FieldPlanDto
{
Hectare = model.Hectare,
MarketingYearId = marketingYearId
};
_fieldPlanDao.Insert(dto);
}
