static void Main(string[] args)
{
Console.WriteLine("Hello...");
var setUp = new SetUp();
Console.WriteLine("process starting");
var ProgramPerams = new myProgramPerams();
Console.WriteLine("Downloading and Importing Data");
var import = new ImportData(ProgramPerams);
var alterData = new AlterData(import.ImportedData, ProgramPerams.RemovalStringsColumn,
ProgramPerams.RemovalStringsColumn, ProgramPerams.DateColumn,
ProgramPerams.DupsColumn);
Console.WriteLine("creating new csv file for SharePoint List");
var outputData = new OutputData(alterData.DataImport, ProgramPerams);
try
{
Directory.Delete(ProgramPerams.DestDir, true);
}
catch (Exception x)
{
Console.WriteLine(x.Message);
}
}
public ImportData(myProgramPerams p)
{
perams = p;
Console.WriteLine("downloading file via vba urlmon c++ com utility");
downloadFile();
Console.WriteLine("pulling downloaded csv into memory");
GetDataTableFromCsv();
}
public OutputData(DataTable dt, myProgramPerams p)
{
perams = p;
DataExport = dt;
Console.WriteLine("creating the csv file");
createCsvFile();
Console.WriteLine("uploading the file into sharepoint via access");
uploadFileToSharePoint();
}