public void readSystemSettings() { try { string line = null; char[] splitter1 = { ';' }; char[] splitter2 = { ':' }; System.IO.TextReader readFile = new StreamReader(".../Main/text/SystemSettings.txt"); line = readFile.ReadLine(); if (line != null) { string _StringToWrite = loCryptorEngine.DecryptString(line); string[] data1 = _StringToWrite.Split(splitter1); for (int i = 0; i < data1.Length; i++) { string[] data2 = null; data2 = data1[i].Split(splitter2); if (data2[0].ToString() == "CurrentLocationId") { try { cboCurrentLocation.SelectedValue = data2[1].ToString(); } catch { } } else if (data2[0].ToString() == "CurrentBranchId") { try { cboCurrentBranch.SelectedValue = data2[1].ToString(); } catch { } } else if (data2[0].ToString() == "CurrentConnection") { try { cboCurrentConnection.Text = data2[1].ToString(); } catch { } } } } readFile.Close(); readFile = null; } catch (Exception ex) { throw ex; } }
public void readLicenseCertificate() { try { string line = null; char[] splitter1 = { ';' }; char[] splitter2 = { ':' }; System.IO.TextReader readFile = new StreamReader(".../Main/text/LicenseCertificate.txt"); line = readFile.ReadLine(); if (line != null) { string _StringToWrite = loCryptorEngine.DecryptString(line); string[] data1 = _StringToWrite.Split(splitter1); for (int i = 0; i < data1.Length; i++) { string[] data2 = null; data2 = data1[i].Split(splitter2); if (data2[0].ToString() == "ApplicationId") { GlobalVariables.ApplicationId = data2[1].ToString(); } if (data2[0].ToString() == "ProcessorId") { GlobalVariables.ProcessorId = data2[1].ToString(); } if (data2[0].ToString() == "TrialVersion") { GlobalVariables.TrialVersion = data2[1].ToString(); } if (data2[0].ToString() == "LicenseKey") { GlobalVariables.LicenseKey = data2[1].ToString(); } if (data2[0].ToString() == "ExpiryDate") { GlobalVariables.lLicenseExpiry = DateTime.Parse(data2[1].ToString()); } } } else { Application.Exit(); } readFile.Close(); readFile = null; } catch (Exception ex) { throw ex; } }
private void TimeLogUI_Load(object sender, EventArgs e) { string _DatabaseAddress = ""; try { string line = null; char[] splitter1 = { ';' }; char[] splitter2 = { ':' }; System.IO.TextReader readFile = new StreamReader(".../Main/text/databaseURL.txt"); line = readFile.ReadLine(); if (line != null) { string _StringToWrite = loCryptoEngine.DecryptString(line); _DatabaseAddress = _StringToWrite; } readFile.Close(); readFile = null; } catch { } lTime = ""; dgvTimeLog.DataSource = null; DataTable ldtTimeLog = loCommon.getTimeLogByEmployee(lDate, _DatabaseAddress, lBiometricsId); dgvTimeLog.DataSource = ldtTimeLog; lFromSelection = false; }
public bool connectDatabase() { string line = null; System.IO.TextReader readFile = new StreamReader("...\\databaseconnection.txt"); line = readFile.ReadLine(); if (line != null) { string _StringToRead = loCryptoEngine.DecryptString(line); myConnectionString = _StringToRead; } readFile.Close(); readFile = null; try { conn = new MySqlConnection(myConnectionString); conn.Open(); GlobalVariables.Connection = conn; char[] splitter1 = { ';' }; char[] splitter2 = { '=' }; string[] database = myConnectionString.Split(splitter1); for (int i = 0; i < database.Length; i++) { string[] detail = null; detail = database[i].Split(splitter2); if (detail[0].ToString().Replace(" ", "") == "SERVER") { GlobalVariables.DatabaseServer = detail[1].ToString(); } if (detail[0].ToString().Replace(" ", "") == "DATABASE") { GlobalVariables.DatabaseName = detail[1].ToString(); } if (detail[0].ToString().Replace(" ", "") == "UID") { GlobalVariables.DatabaseUID = detail[1].ToString(); } if (detail[0].ToString().Replace(" ", "") == "PWD") { GlobalVariables.DatabasePWD = detail[1].ToString(); } if (detail[0].ToString().Replace(" ", "") == "PORT") { GlobalVariables.DatabasePort = detail[1].ToString(); } } return(true); } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } }
private void ImportDataUI_Load(object sender, EventArgs e) { string line = null; System.IO.TextReader readFile = new StreamReader("...\\databaseconnection.txt"); line = readFile.ReadLine(); if (line != null) { string _StringToRead = loCryptoEngine.DecryptString(line); line = _StringToRead; } readFile.Close(); readFile = null; if (line != null) { string[] backuplocation = line.Split(';'); for (int i = 0; i < backuplocation.Length; i++) { string[] item; switch (i) { case 0: item = backuplocation[i].Split('='); txtBackupServer.Text = item[1].ToString(); txtRestoreServer.Text = item[1].ToString(); break; case 1: item = backuplocation[i].Split('='); txtBackupDatabase.Text = item[1].ToString(); txtRestoreDatabase.Text = item[1].ToString(); break; case 2: item = backuplocation[i].Split('='); txtBackupUserId.Text = item[1].ToString(); txtRestoreUserId.Text = item[1].ToString(); break; case 3: item = backuplocation[i].Split('='); txtBackupPassword.Text = item[1].ToString(); txtRestorePassword.Text = item[1].ToString(); break; case 4: item = backuplocation[i].Split('='); txtBackupPort.Text = item[1].ToString(); txtRestorePort.Text = item[1].ToString(); break; } } } txtSaveToURL.Text = GlobalVariables.BackupPath; string pages = tbcBackupRestore.SelectedTab.Text; switch (pages) { case "Backup": btnBackupDatabase.Visible = true; btnRestoreDatabase.Visible = false; break; case "Restore": btnRestoreDatabase.Visible = true; btnBackupDatabase.Visible = false; break; } }