private void SetCurrentParameterIds(XlsUpload xlsUpload)
{
CurrentScenarioId = xlsUpload.ScenarioId;
CurrentKeyParameterId = xlsUpload.KeyParameterId;
CurrentKeyParameterLevelId = xlsUpload.KeyParameterLevelId;
CurrentParentRegionId = xlsUpload.ParentRegionId;
}
private void SetCurrentFilterVariables(XlsUpload xlsFileDescription)
{
CurrentSecenarioId = xlsFileDescription.ScenarioId;
CurrentKeyParameterId = xlsFileDescription.KeyParameterId;
CurrentKeyParameterLevelId = xlsFileDescription.KeyParameterLevelId;
CurrentRegionId = xlsFileDescription.RegionId == null ? 0 : xlsFileDescription.RegionId.Value;
}
public async Task <XlsUpload> UploadFile_(int regionId, int keyParameterId, int keyParameterLevelId, int scenarioId, IFormFile file, string uploadsFolderPath)
{
var fileName = await xlsStorage.StoreXls(uploadsFolderPath, file);
var xlsFile = new XlsUpload {
FileName = fileName
};
var xlsUpload = new XlsUpload
{
KeyParameterId = keyParameterId,
KeyParameterLevelId = keyParameterLevelId,
ScenarioId = scenarioId,
FileName = fileName,
UploadDate = DateTime.Now
};
xlsUploadRepository.Add(xlsUpload);
await _unitOfWork.CompleteAsync();
return(xlsUpload);
}
public async Task <XlsUpload> UploadFileWithRegion(int regionId, int keyParameterId, int keyParameterLevelId, int scenarioId, IFormFile file, string uploadsFolderPath)
{
var relationalPath = await GetFilePathAsync(regionId, keyParameterId, keyParameterLevelId, scenarioId);
var xlsFileFullPath = Path.Combine(uploadsFolderPath, relationalPath);
var fileName = await xlsStorage.StoreXls(xlsFileFullPath, file);
var relationalFileName = Path.Combine(relationalPath, fileName);
var xlsUpload = new XlsUpload
{
KeyParameterId = keyParameterId,
KeyParameterLevelId = keyParameterLevelId,
ScenarioId = scenarioId,
FileName = relationalFileName,
UploadDate = DateTime.Now
};
xlsUploadRepository.Add(xlsUpload);
await _unitOfWork.CompleteAsync();
return(xlsUpload);
}
public void Update(XlsUpload xlsUpload)
{
context.XlsUploads.Update(xlsUpload);
}
public void Add(XlsUpload xlsUpload)
{
context.XlsUploads.Add(xlsUpload);
}
