private DataTable CreateDataTable(string csvFileToConvertIntoDataTable)
{
if (string.IsNullOrWhiteSpace(csvFileToConvertIntoDataTable) || DirectoryOperationsHelper.IsFileExist(csvFileToConvertIntoDataTable) == false)
{
_logger.Info("File not exists at following path: " + csvFileToConvertIntoDataTable);
return(null);
}
try
{
var dtable = _csvReader.ConvertCsvToDataTable(csvFileToConvertIntoDataTable, true, "_$$");
if (dtable == null || dtable.Rows == null || dtable.Rows.Count <= 0)
{
_logger.Info("No record found in current File: " + csvFileToConvertIntoDataTable);
return(null);
}
return(dtable);
}
catch (Exception ex)
{
_logger.Error("Some Exception occurred while converting csvtoDataTable");
_logger.Error("Message: " + ex.Message);
_logger.Error("Stack Trace: " + ex.StackTrace);
}
return(null);
}
