public IEnumerable <ResultAccount> TryToImportFile(Stream inputStream, string period, string year, string comment, string usedbudget)
{
DeleteResultByMonth(period, Convert.ToInt32(year));
var dataSet = ConvertStreamToDataSet(inputStream);
IEnumerable <ResultAccount> results = ConvertDataSetToObjectCollection(dataSet, (int)Enum.Parse(typeof(ResultPeriod), period), Convert.ToInt32(year));
SaveResultModel saveModel = SortResults(results, Convert.ToInt32(year));
_resultRepository.SaveMeny(MapManyToDTO(saveModel.SavedResults));
SaveOverview(period, Convert.ToInt32(year), comment, usedbudget);
return(saveModel.FailedResults);
}
private SaveResultModel SortResults(IEnumerable <ResultAccount> results, int year)
{
IEnumerable <int> validAccountNumbers = _accountInfoRepository.GetAllAccountNumbersByYear(year);
SaveResultModel saveModel = new SaveResultModel();
foreach (var result in results)
{
if (validAccountNumbers.Contains(result.AccountNumber))
{
saveModel.SavedResults.Add(result);
}
else
{
saveModel.FailedResults.Add(result);
}
}
return(saveModel);
}
private SaveResultModel SortResults(IEnumerable<ResultAccount> results, int year)
{
IEnumerable<int> validAccountNumbers = _accountInfoRepository.GetAllAccountNumbersByYear(year);
SaveResultModel saveModel = new SaveResultModel();
foreach(var result in results)
{
if (validAccountNumbers.Contains(result.AccountNumber))
saveModel.SavedResults.Add(result);
else
saveModel.FailedResults.Add(result);
}
return saveModel;
}
