private bool IsFileValid(MedicationFileUploadEditModel model, out long count)
{
try
{
var archiveLocation = _mediaRepository.GetMedicationUploadMediaFileLocation();
_csvReader.Delimiter = _csvReader.GetFileDelimiter(archiveLocation.PhysicalPath + model.File.Path).ToString();
var medicationTable = _csvReader.ReadWithTextQualifier(archiveLocation.PhysicalPath + model.File.Path);
count = medicationTable.Rows.Count;
if (medicationTable.Rows.Count == 0)
{
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("Uploaded file has no data.");
return(false);
}
var missingColumnNames = _medicationUploadHelper.CheckForColumns(medicationTable.Rows[0]);
if (!string.IsNullOrEmpty(missingColumnNames))
{
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("Missing Column Name(s) : " + missingColumnNames);
return(false);
}
return(true);
}
catch (Exception ex)
{
count = 0;
IoC.Resolve <ILogManager>().GetLogger <Global>().Error("Medication Upload Validation Failure: " + ex.Message + "\n\t" + ex.StackTrace);
return(false);
}
}
