public void processCitiFiles(string fileDate)
{
string fileXLS = "";
int filecount = 0;
XlsReader xlsReader = new XlsReader();
XlsReader.FileTypes fileType = XlsReader.FileTypes.XLSType;
string path = ConfigurationManager.AppSettings.Get("CitiSourceFolder");
//Step 1 : Read all available file in the directory
string fileToProcess = "*" + fileDate + "*.*";
string[] files = Directory.GetFiles(path, fileToProcess, SearchOption.AllDirectories);
Console.WriteLine();
if (files.Length != 0)
{
for (int i = 0; i < files.Length; i++)
{
filecount++;
fileXLS = "";
string fileXLSToProcess = "";
// Get the file from path
fileXLS = @files[i];
string fileExt = Path.GetExtension(fileXLS);
//Rename the file to XLS format
if (fileExt.ToLower() != ".xls")
{
File.Move(fileXLS, fileXLS + ".xls");
fileXLSToProcess = fileXLS + ".xls";
}
else
{
fileXLSToProcess = fileXLS;
}
// ReadFile(sampleCSV);
DataTable xlsDt = xlsReader.ReadXLSToDT(fileType, fileXLSToProcess);
if (xlsDt.Columns.Count == 7)
{
processCitiData(xlsDt, fileXLSToProcess);
}
else
{
Console.WriteLine(string.Format("skippiing {0} file as it seems empty", fileXLSToProcess));
}
}
}
}
public DataTable ReadXLSToDT(XlsReader.FileTypes fileType, string fileLoc)
{
DataTable xlsDT = new DataTable();
switch (fileType)
{
case XlsReader.FileTypes.XLSType:
xlsDT = ReadXLSFile(fileLoc);
break;
default:
break;
}
return(xlsDT);
}
