protected UploadJob GetJob(UploadJobType jobType, Guid jobGuid)
{
var job = new UploadJob
{
Guid = jobGuid,
Status = UploadJobStatus.NotStart,
DateCreated = DateTime.Now,
JobType = jobType,
Filename = @"fake.xls",
UserId = 11,
Username = @"phe\doris.hain"
};
return job;
}
public List<DuplicateRowInDatabaseError> GetDuplicates(List<UploadDataModel> data, CoreDataRepository repository, UploadJobType jobType)
{
var lastIndicatorId = -1;
var rowIndex = 1;
var duplicateRowInDatabaseErrors = new List<DuplicateRowInDatabaseError>();
foreach (UploadDataModel row in data)
{
rowIndex++;
if (row.IndicatorId != lastIndicatorId)
{
lastIndicatorId = row.IndicatorId;
}
if (jobType == UploadJobType.Simple)
{
row.CategoryId = -1;
row.CategoryTypeId = -1;
}
var duplicates = repository.GetDuplicateCoreDataSetForAnIndicator(row);
if (duplicates.Count > 0)
{
var duplicateDataError = new DuplicateRowInDatabaseError
{
ErrorMessage = "Data already exists for Indicator Id: " + row.IndicatorId,
RowNumber = rowIndex,
DbValue = duplicates.First().Value,
ExcelValue = row.Value,
IndicatorId = row.IndicatorId,
AgeId = row.AgeId,
SexId = row.SexId,
AreaCode = row.AreaCode,
Uid = duplicates.First().Uid
};
duplicateRowInDatabaseErrors.Add(duplicateDataError);
row.DuplicateExists = true;
}
}
return duplicateRowInDatabaseErrors;
}
// Helper to save files and create job in database
public bool SaveFile(HttpPostedFileBase indicatorDataFile, UploadJobType jobType)
{
bool response;
if (Request.Files == null)
{
return(false);
}
var guid = Guid.NewGuid();
var file = Request.Files[0];
var actualFileName = file.FileName;
var fileName = guid + Path.GetExtension(file.FileName);
try
{
if (!Directory.Exists(AppConfig.UploadFolder))
{
Directory.CreateDirectory(AppConfig.UploadFolder);
}
file.SaveAs(Path.Combine(AppConfig.UploadFolder, fileName));
var uploadJob = new UploadJob
{
DateCreated = DateTime.Now,
Guid = guid,
Filename = actualFileName,
JobType = jobType,
Status = UploadJobStatus.NotStart,
UserId = UserDetails.CurrentUser().Id
};
_fpmUploadRepository.CreateJob(uploadJob);
response = true;
}
catch (Exception ex)
{
response = false;
}
return(response);
}
// Helper to save files and create job in database
public bool SaveFile(HttpPostedFileBase indicatorDataFile, UploadJobType jobType)
{
bool response;
if (Request.Files == null)
{
return false;
}
var guid = Guid.NewGuid();
var file = Request.Files[0];
var actualFileName = file.FileName;
var fileName = guid + Path.GetExtension(file.FileName);
try
{
if (!Directory.Exists(AppConfig.UploadFolder))
{
Directory.CreateDirectory(AppConfig.UploadFolder);
}
file.SaveAs(Path.Combine(AppConfig.UploadFolder, fileName));
var uploadJob = new UploadJob
{
DateCreated = DateTime.Now,
Guid = guid,
Filename = actualFileName,
JobType = jobType,
Status = UploadJobStatus.NotStart,
UserId = UserDetails.CurrentUser().Id
};
_fpmUploadRepository.CreateJob(uploadJob);
response = true;
}
catch (Exception ex)
{
response = false;
}
return response;
}
