private void TmR_Backup_Tick(object sender, EventArgs e) { TmR_Backup.Enabled = false; Cls_Procedure.BackupData(); TmR_Backup.Enabled = true; }
private void CmD_OK_Click(object sender, EventArgs e) { OracleConnection oConnection = new OracleConnection(); OracleCommand oCommandUpdate = new OracleCommand(); OracleDataReader drReader; int nResult = 0; string sPassword = Cls_Procedure.XorEncrypt(TxT_Password_1.Text.Trim(), Bauwagen.Properties.Settings.Default.Key); if (TxT_Password_1.Text.Trim() == TxT_Password_2.Text.Trim()) { using (oConnection) { try { oConnection.ConnectionString = Frm_Haupt.sDSN; oConnection.Open(); oCommandUpdate.Connection = oConnection; oCommandUpdate.CommandText = Cls_Query.UpdateBadLogonAnwender(LbL_Username.Text.Trim(), false, sPassword); nResult = oCommandUpdate.ExecuteNonQuery(); oConnection.Close(); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MessageBox.Show(ex.Message, "CmD_OK_Click"); } } } else { MessageBox.Show("Passwörter stimmen nicht überein!", "Fehler"); this.DialogResult = DialogResult.Cancel; } }
private void CheckPassword() { #region Prüfen der Berechtigung zum öffnen des Adminportals if (LbL_Status.Text == "admin") { string sAdminPassword1 = Cls_Procedure.XorEncrypt("뇛뇙뇟뇛뇚뇝뇚뇛뇛뇝", Bauwagen.Properties.Settings.Default.Key); string sAdminPassword2 = Cls_Procedure.XorEncrypt("뇛뇛뇛뇙뇓뇓뇟뇝뇙뇚", Bauwagen.Properties.Settings.Default.Key); if (sAdminPassword1 == TxT_Password.Text | sAdminPassword2 == TxT_Password.Text) { this.DialogResult = DialogResult.OK; } else { MessageBox.Show("Password falsch!", "Fehler", MessageBoxButtons.OK, MessageBoxIcon.Error); this.DialogResult = DialogResult.Abort; } if (System.Environment.MachineName == "EMARW001" | System.Environment.MachineName == "EMARL001" | System.Environment.MachineName == "EMARL002") { this.DialogResult = DialogResult.OK; } } else if (LbL_Status.Text == "user") { OracleConnection oConnection = new OracleConnection(); OracleCommand oCommandSelect = new OracleCommand(); OracleCommand oCommandUpdate = new OracleCommand(); OracleDataReader drReader; int nResult = 0; string sPassword = ""; bool bChangePW = false; using (oConnection) { oConnection.ConnectionString = Frm_Haupt.sDSN; oConnection.Open(); oCommandSelect.Connection = oConnection; oCommandUpdate.Connection = oConnection; oCommandSelect.CommandText = Cls_Query.GetAnwenderDaten(LbL_Username.Text.Trim(), false, ""); drReader = oCommandSelect.ExecuteReader(); while (drReader.Read()) { sPassword = Cls_Procedure.XorEncrypt(drReader.GetValue(3).ToString().Trim(), Bauwagen.Properties.Settings.Default.Key); if (drReader.GetValue(10).ToString().Trim() == "1") { bChangePW = true; } else { bChangePW = false; } } drReader.Close(); if (sPassword == TxT_Password.Text && bChangePW == false) { oCommandUpdate.CommandText = Cls_Query.UpdateBadLogonAnwender(LbL_Username.Text.Trim(), false, ""); nResult = oCommandUpdate.ExecuteNonQuery(); this.DialogResult = DialogResult.OK; } else if (sPassword == TxT_Password.Text && bChangePW == true) { MessageBox.Show("Passwort muss geändert werden", "Info"); Frm_ChangePassword frm_ChangePassword = new Frm_ChangePassword(); frm_ChangePassword.LbL_Username.Text = LbL_Username.Text.Trim(); if (frm_ChangePassword.ShowDialog() == DialogResult.OK) { oCommandUpdate.CommandText = Cls_Query.UpdateBadLogonAnwender(LbL_Username.Text.Trim(), false, ""); nResult = oCommandUpdate.ExecuteNonQuery(); this.DialogResult = DialogResult.OK; } else { oCommandUpdate.CommandText = Cls_Query.UpdateBadLogonAnwender(LbL_Username.Text.Trim(), true, ""); nResult = oCommandUpdate.ExecuteNonQuery(); this.DialogResult = DialogResult.Abort; } } else { MessageBox.Show("Password falsch!", "Fehler", MessageBoxButtons.OK, MessageBoxIcon.Error); oCommandUpdate.CommandText = Cls_Query.UpdateBadLogonAnwender(LbL_Username.Text.Trim(), true, ""); nResult = oCommandUpdate.ExecuteNonQuery(); this.DialogResult = DialogResult.Abort; } oConnection.Close(); } } #endregion }
private void TxT_Unverschlüsselt_TextChanged(object sender, EventArgs e) { string sAdminPassword = Cls_Procedure.XorEncrypt(TxT_Unverschlüsselt.Text.Trim(), Bauwagen.Properties.Settings.Default.Key); TxT_Verschlüsselt.Text = sAdminPassword; }
private void LoadUser() { OracleConnection oConnection = new OracleConnection(); OracleCommand oCommand = new OracleCommand(); OracleDataReader drReader; try { using (oConnection) { oConnection.ConnectionString = Frm_Haupt.sDSN; oConnection.Open(); oCommand.Connection = oConnection; oCommand.CommandText = Cls_Query.GetAnwenderDaten(CmB_User.Text.Trim(), true, ""); drReader = oCommand.ExecuteReader(); if (drReader.HasRows) { while (drReader.Read()) { string sPassword = Cls_Procedure.XorEncrypt(drReader.GetValue(3).ToString().Trim(), Bauwagen.Properties.Settings.Default.Key); TxT_Vorname.Text = drReader.GetValue(1).ToString().Trim(); TxT_Password.Text = sPassword; TxT_Budget.Text = drReader.GetValue(8).ToString().Trim(); TxT_Kredit.Text = drReader.GetValue(9).ToString().Trim(); TxT_TokenID.Text = drReader.GetValue(11).ToString().Trim(); NuD_Layer.Value = Convert.ToDecimal(drReader.GetValue(12)); if (drReader.GetValue(10).ToString().Trim() == "1") { ChK_ChangePW.Checked = true; } else { ChK_ChangePW.Checked = false; } if (Convert.ToInt32(drReader.GetValue(6)) <= 5) { ChK_Aktiv.Checked = true; } else { ChK_Aktiv.Checked = false; } } } drReader.Close(); oConnection.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "LoadUser"); } }
private void CmD_Create_Click(object sender, EventArgs e) { OracleConnection oConnection = new OracleConnection(); OracleCommand oCommandInsert = new OracleCommand(); OracleCommand oCommandSelect = new OracleCommand(); OracleDataReader drReader; int nResult = 0; bool bValid = false; bool bUpdate = false; string sPassword = Cls_Procedure.XorEncrypt(TxT_Password.Text.Trim(), Bauwagen.Properties.Settings.Default.Key); string sChangePW = ""; string sAktiv = ""; if (ChK_ChangePW.Checked) { sChangePW = "1"; } else { sChangePW = "0"; } if (ChK_Aktiv.Checked) { sAktiv = "1"; } else { sAktiv = "0"; } if (NuD_Layer.Value > 0 && NuD_Layer.Value <= 2) { bValid = true; } else { bValid = false; } if (bValid == true) { using (oConnection) { try { oConnection.ConnectionString = Frm_Haupt.sDSN; oConnection.Open(); oCommandInsert.Connection = oConnection; oCommandSelect.Connection = oConnection; oCommandSelect.CommandText = Cls_Query.GetAnwenderDaten(TxT_Vorname.Text.Trim(), true, ""); drReader = oCommandSelect.ExecuteReader(); while (drReader.Read()) { bUpdate = true; } drReader.Close(); oCommandInsert.CommandText = Cls_Query.InsertUser(bUpdate, TxT_Vorname.Text.Trim(), sPassword, TxT_Budget.Text.Trim(), TxT_Kredit.Text.Trim(), TxT_TokenID.Text.Trim(), sChangePW, sAktiv, Convert.ToInt32(NuD_Layer.Value)); nResult = oCommandInsert.ExecuteNonQuery(); MessageBox.Show("Erfolgreich gespeichert", "Info"); oConnection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "CmD_Create_Click"); } } } else { MessageBox.Show("Eingaben üngültig bitte das Layer prüfen", "Fehler", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Frm_Haupt_Load(object sender, EventArgs e) { OracleConnection oConnection = new OracleConnection(); OracleCommand oCommand = new OracleCommand(); OracleDataReader dataReader; bool bRun = true; int nCounter = 0; string sSammeluser = ""; XmlDocument doc = new XmlDocument(); doc.Load("Settings.xml"); XmlNode nodeSchema = doc.SelectSingleNode("/Bauwagen/Database/Schema"); sSchema = nodeSchema.FirstChild.Value; XmlNode nodeSchemaPassword = doc.SelectSingleNode("/Bauwagen/Database/SchemaPassword"); sSchemaPassword = nodeSchemaPassword.FirstChild.Value; XmlNode nodeDatabase = doc.SelectSingleNode("/Bauwagen/Database/Adress"); sDatabase = nodeDatabase.FirstChild.Value; XmlNode nodeListener = doc.SelectSingleNode("/Bauwagen/Database/ListenerPort"); sListenerPort = nodeListener.FirstChild.Value; XmlNode nodeBackupPfad = doc.SelectSingleNode("/Bauwagen/Database/BackupPfad"); sBackupPfad = nodeBackupPfad.FirstChild.Value; XmlNode nodeRestorePfad = doc.SelectSingleNode("/Bauwagen/Database/RestorePfad"); sRestorePfad = nodeRestorePfad.FirstChild.Value; XmlNode nodeHostAutomat = doc.SelectSingleNode("/Bauwagen/Software/HostName_Automat"); XmlNode nodeHostCocktail = doc.SelectSingleNode("/Bauwagen/Software/HostName_CocktailMixer"); XmlNode nodeSammelUser = doc.SelectSingleNode("/Bauwagen/Software/Gemeinschaftsuser"); sSammeluser = nodeSammelUser.FirstChild.Value; CmD_Automatenbuchung.Visible = false; CmD_Cocktailmixer.Visible = false; if (nodeHostAutomat.InnerText == System.Environment.MachineName.ToUpper().Trim()) { CmD_Automatenbuchung.Visible = true; } if (nodeHostCocktail.InnerText == System.Environment.MachineName.ToUpper().Trim()) { CmD_Cocktailmixer.Visible = true; } if (!Directory.Exists(sBackupPfad)) { Directory.CreateDirectory(sBackupPfad); } if (!Directory.Exists(sRestorePfad)) { Directory.CreateDirectory(sRestorePfad); } string sTemp = Cls_Procedure.XorEncrypt(sSchemaPassword, Bauwagen.Properties.Settings.Default.Key); sDSN = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + sDatabase + ")(PORT=" + sListenerPort + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=xe)));User Id=" + sSchema + "; Password="******";"; LbL_Summe.Text = "0,00 €"; LbL_Budget.Text = "0,00 €"; LbL_Verfügbar.Text = "0,00 €"; LbL_Kredit.Text = "0,00 €"; while (bRun == true) { try { oConnection.ConnectionString = sDSN; oConnection.Open(); oCommand.Connection = oConnection; oCommand.CommandText = Cls_Query.GetAnwenderDaten(sSammeluser, false, ""); dataReader = oCommand.ExecuteReader(); if (!dataReader.HasRows) { MessageBox.Show("Fehler in der Konfiguration, der angegebene Sammeluser existiert nicht!\n" + sSammeluser); } oConnection.Close(); bRun = false; } catch (Exception ex) { bRun = true; Thread.Sleep(1000); nCounter += 1; } if (nCounter > 1000) { MessageBox.Show("Datenbankfehler Anwendung wird geschlossen!"); this.Close(); } } CreateButtons(); Cls_Procedure.BackupData(); bLoad = false; }