static void Main(string[] args)
{
string Dev64Connection = "DRIVER={mySql ODBC 5.3 Unicode Driver};SERVER=Dev64;port=3306;UID=graham;PASSWORD=1fuckyou;DATABASE=kdl_mod3";
string thisConnection = Dev64Connection;
string AlertusDbFileName = "AlertusDB";
string thisFolder = Directory.GetCurrentDirectory() + @"\";
if (System.IO.File.Exists(thisFolder + AlertusDbFileName))
{
clsCsvReader fileReader = new clsCsvReader(thisFolder + AlertusDbFileName);
string[] thisLine = fileReader.GetCsvLine();
thisConnection = thisLine[0];
fileReader.Dispose();
}
clsImportData thisImportData = new clsImportData();
thisImportData.Connect((int)thisImportData.DatabaseType_MySql(),
thisConnection);
try
{
thisImportData.PreImport();
thisImportData.RestartImportFromLastRecord(@"C:\", @"C:\KDL0504.CSV", 0);
thisImportData.AddOrdersAndItems();
thisImportData.AddUsersForPeople();
thisImportData.ExportContactsForMailMerge();
int currentYear = DateTime.Now.Year;
int currentMonth = DateTime.Now.Month;
for (int counter = 0; counter < 13; counter++)
{
int SeedInvoiceNumber = 1;
string LogFolder = @"W:\logs\";
string fileToExportTo = @"export.csv";
thisImportData.DoCorrespondence(new DateTime(currentYear, currentMonth, 1), SeedInvoiceNumber, LogFolder, fileToExportTo);
currentMonth++;
if (currentMonth > 12)
{
currentYear++;
currentMonth = currentMonth % 12;
}
}
}
catch (System.Exception e)
{
clsCsvWriter fileWriter = new clsCsvWriter(thisFolder + "Importererr.txt", true);
fileWriter.WriteFields(new
object[] {
e.ToString(),
e.Message,
DateTime.Now.ToString()
});
fileWriter.Close();
}
}
