// MANUAL !!! UPLOAD "SPRUSNBU" INTO NEW 2016 SQL FROM DBF:
private void NewSprusnbuIntoSql_Click(object sender, RoutedEventArgs e)
{
try
{
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
dlg.DefaultExt = ".dbf";
dlg.Filter = "DBF Files Only (*.dbf)|*.dbf";
bool? dbfFileSelected = dlg.ShowDialog();
if (dbfFileSelected == true)
{
//FileInfo dbfFile = new FileInfo(dlg.FileName);
string dbLogin = passwordBoxLogin.Password.Trim();
string dbPassw = passwordBoxPassw.Password.Trim();
if (dbLogin.Length < 1 || dbPassw.Length < 1)
{
MessageBox.Show("Set Login & Password Before!");
}
else
{
string connString = "Server=" + _SERVER + "; Database=" + _DATABASE + "; Uid=" + dbLogin + "; Pwd=" + dbPassw + "";
UploadDbfIntoSql uploadDbf = new UploadDbfIntoSql();
string uploadRez = uploadDbf.ReadDbfAndInsert(dlg.FileName, _DATABASE, _SPRUSNBU_2016, connString);
MessageBox.Show(uploadRez);
}
}
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
// RUN TASKS USING SHCHEDULER :
private void RunEveryFifteenMin(object sender, EventArgs e)
{
// DON'T RUN UNTIL 7 O'CLOCK FOR WAITHING ALL BACKUP TASKS HAS FINISHED :
if (DateTime.Now.Hour > 7)
{
// TODO: TEMPORARY AUTO SPRUSNBU UPLOADER !!!!!
// TODO: TEMPORARY AUTO SPRUSNBU UPLOADER !!!!!
// TODO: TEMPORARY AUTO SPRUSNBU UPLOADER !!!!!
string dir4sprusnbu = "C:\\NBUMAIL\\SPRUSNBD4SQL\\";
string log4sprusnbu = "NBU_Mailer_2016_Sprusnbu_Upload.log";
string currentSprusFile = "SPRUSNBU.DBF";
string todaySprusFilePath = dir4sprusnbu + DateTime.Now.ToString("yy-MM-dd") + ".SPRUSNBU.DBF";
if ((DateTime.Now.Hour == 11 || DateTime.Now.Hour == 15) && DateTime.Now.Minute > 40)
{
try
{
if (!Directory.Exists(dir4sprusnbu)) Directory.CreateDirectory(dir4sprusnbu);
bool currSprusAlreadyLoad = false;
FileInfo[] oldSprusFiles = new DirectoryInfo(dir4sprusnbu).GetFiles("*.dbf");
DateTime currSprusDate = new FileInfo("C:\\NBUMAIL\\" + currentSprusFile).LastWriteTime;
// MessageBox.Show(oldSprusFiles.Length + " files in " + dir4sprusnbu);
foreach (FileInfo file in oldSprusFiles)
{
if (file.LastWriteTime == currSprusDate)
{
currSprusAlreadyLoad = true;
break;
}
}
if (!currSprusAlreadyLoad)
{
// CREATE TEMPORARY FILE FOR ODBC UPLOADING :
File.Copy("C:\\NBUMAIL\\" + currentSprusFile, dir4sprusnbu + currentSprusFile);
string dbLogin = passwordBoxLogin.Password.Trim();
string dbPassw = passwordBoxPassw.Password.Trim();
// UPLOAD IN SQL - UPDATE 2016 !!!
// UPLOAD IN SQL - UPDATE 2016 !!!
string table = "SPRUSNBU_BANKS";
string connString = "Server=" + _SERVER + "; Database=" + _DATABASE + "; Uid=" + dbLogin + "; Pwd=" + dbPassw + "";
UploadDbfIntoSql uploadDbf = new UploadDbfIntoSql();
// UPLOAD 2 =SPRUSNBU= 4 NEW 2016 :
string uploadRez = uploadDbf.ReadDbfAndInsert(dir4sprusnbu + currentSprusFile, _DATABASE, table, connString);
File.AppendAllText(log4sprusnbu, "\r\n" + DateTime.Now + " - " + uploadRez);
// UPLOAD 2 =SPRUSNBU_BANKS= 4 OLD 2015
// UPLOAD IN SQL - OVERWRITE 2014 !!!
// UPLOAD IN SQL - OVERWRITE 2014 !!!
WorkWithDB_2015 workWithDB = new WorkWithDB_2015(_DATABASE, dbLogin, dbPassw);
string uploadRez2014 = workWithDB.UpdateSprusnbuFromDbf(_SPRUSNBU_2014, dir4sprusnbu, currentSprusFile);
File.AppendAllText(log4sprusnbu, "\r\n" + DateTime.Now + " - " + uploadRez2014);
System.Threading.Thread.Sleep(4000);
// STORE TEMPORARY FILE FOR NEXT TIME CHECKING :
File.Move(dir4sprusnbu + currentSprusFile, todaySprusFilePath);
}
}
catch (Exception exc)
{
File.AppendAllText(log4sprusnbu, "\r\n" + DateTime.Now + " - " + exc.Message);
}
}
///////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////
ProcessEnvelopes();
}
}
