// 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(); } }