private void CreateTableCocktail()
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommand = new OracleCommand();
int nResult = 0;
if (MessageBox.Show("ACHTUNG!!\n\nTabellen für Cocktails wird neu erstellt und vorhande Daten gelöscht! Wirklich durchführen?", "Info", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
using (oConnection)
{
oConnection.ConnectionString = Frm_Haupt.sDSN;
oConnection.Open();
oCommand.Connection = oConnection;
//Tabelle Cocktails erstellen
try
{
oCommand.CommandText = Cls_Query.DropTableCocktails();
nResult = oCommand.ExecuteNonQuery();
}
catch { }
try
{
oCommand.CommandText = Cls_Query.CreateTableCocktails();
nResult = oCommand.ExecuteNonQuery();
}
catch { }
oConnection.Close();
}
}
}
private void GetUser()
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommand = new OracleCommand();
OracleDataReader drReader;
using (oConnection)
{
try
{
oConnection.ConnectionString = Frm_Haupt.sDSN;
oConnection.Open();
oCommand.Connection = oConnection;
oCommand.CommandText = Cls_Query.GetAnwenderDaten("", false, "");
drReader = oCommand.ExecuteReader();
CmB_User.Items.Clear();
while (drReader.Read())
{
if (Convert.ToDouble(drReader.GetValue(6)) <= 5)
{
CmB_User.Items.Add(drReader.GetValue(1).ToString().Trim() + " " + drReader.GetValue(2).ToString().Trim());
}
}
drReader.Close();
oConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "GetUser");
}
}
}
private void LoadUserKomplett()
{
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("", true, "");
drReader = oCommand.ExecuteReader();
CmB_Name.Items.Clear();
while (drReader.Read())
{
CmB_Name.Items.Add(drReader.GetValue(1).ToString().Trim() + " " + drReader.GetValue(2).ToString().Trim());
}
drReader.Close();
oConnection.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "LoadUser");
}
}
private void TmR_Refresh_Tick(object sender, EventArgs e)
{
TmR_Refresh.Enabled = false;
if (bBlockRefresh == false)
{
for (int i = nAnzahlAnwender - 1; i >= 0; i--)
{
GetAnwenderControlByName("CmD_Anwender_" + i.ToString().PadLeft(2, '0')).Visible = false;
GetAnwenderControlByName("CmD_Anwender_" + i.ToString().PadLeft(2, '0')).Dispose();
}
for (int i = nAnzahlGüter - 1; i >= 0; i--)
{
GetGüterControlByName("CmD_Gueter_" + i.ToString().PadLeft(2, '0')).Visible = false;
GetGüterControlByName("CmD_Gueter_" + i.ToString().PadLeft(2, '0')).Dispose();
}
CreateButtons();
}
else
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommandSelect = new OracleCommand();
OracleDataReader drReader;
string sUser = "";
using (oConnection)
{
try
{
oConnection.ConnectionString = sDSN;
oConnection.Open();
sUser = LbL_User.Text.Trim();
oCommandSelect.Connection = oConnection;
oCommandSelect.CommandText = Cls_Query.GetAnwenderDaten(sUser, false, "");
drReader = oCommandSelect.ExecuteReader();
while (drReader.Read())
{
LbL_Budget.Text = String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(8))) + " €";
LbL_Kredit.Text = String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(9))) + " €";
}
drReader.Close();
GetAnwenderControlByName(sButtonClicked).Text = LbL_User.Text.Trim() + "\n" + LbL_Budget.Text.Trim();
oConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "TmR_Refresh_Tick");
}
}
}
TmR_Refresh.Enabled = true;
}
private void LoadData()
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommand = new OracleCommand();
OracleDataReader drReader;
try
{
using (oConnection)
{
oConnection.ConnectionString = Frm_Haupt.sDSN;
oConnection.Open();
DgV_UserHistory.AllowUserToAddRows = true;
oCommand.Connection = oConnection;
oCommand.CommandText = Cls_Query.GetUserHistory();
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
DataGridViewRow row = (DataGridViewRow)DgV_UserHistory.Rows[0].Clone();
row.Height = 45;
row.Cells[0].Value = drReader.GetValue(0);
row.Cells[1].Value = drReader.GetValue(1);
row.Cells[2].Value = drReader.GetValue(2);
row.Cells[3].Value = drReader.GetValue(3);
row.Cells[4].Value = drReader.GetValue(4);
row.Cells[5].Value = drReader.GetValue(5);
if (drReader.GetValue(1).ToString() == "Aufladung")
{
for (int i = 0; i <= 5; i++)
{
row.Cells[i].Style.BackColor = Color.LightGreen;
}
}
else
{
for (int i = 0; i <= 5; i++)
{
row.Cells[i].Style.BackColor = Color.LightYellow;
}
}
DgV_UserHistory.Rows.Add(row);
}
drReader.Close();
DgV_UserHistory.AllowUserToAddRows = false;
oConnection.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void SaveData()
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommand = new OracleCommand();
int nResult = 0;
bool bInsert = false;
bool bUpdate = false;
string sLocked = "0";
if (bDataExists == true)
{
bUpdate = true;
bInsert = false;
}
else
{
bUpdate = false;
bInsert = true;
}
if (ChK_Aktiv.Checked == true)
{
sLocked = "0";
}
else
{
sLocked = "1";
}
try
{
using (oConnection)
{
oConnection.ConnectionString = Frm_Haupt.sDSN;
oConnection.Open();
oCommand.Connection = oConnection;
oCommand.CommandText = Cls_Query.SaveGüterDaten(bInsert, bUpdate, CmB_Güter.Text.Trim(), TxT_Preis.Text.Trim().Replace(",", "."), sLocked);
nResult = oCommand.ExecuteNonQuery();
MessageBox.Show("Erfolgreich gespeichert", "Info");
oConnection.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "LoadData");
}
}
private void LoadUser()
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommand = new OracleCommand();
OracleDataReader drReader;
bool bDateFilter = false;
if (ChK_DatumsFilter.Checked == true)
{
bDateFilter = true;
}
else
{
bDateFilter = false;
}
try
{
using (oConnection)
{
oConnection.ConnectionString = Frm_Haupt.sDSN;
oConnection.Open();
oCommand.Connection = oConnection;
oCommand.CommandText = Cls_Query.GetUserDashboardHistory(CmB_Name.Text.Trim(), bDateFilter, DtP_DatumVon.Value.ToString().Trim(), DtP_DatumBis.Value.ToString().Trim());
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
if (drReader.GetValue(2).ToString().Trim() == "Verbrauch")
{
ChT_Verbrauch.Series[0].Points.AddXY(Convert.ToDateTime(drReader.GetValue(1)), Convert.ToDouble(drReader.GetValue(0)));
}
else if (drReader.GetValue(2).ToString().Trim() == "Aufladung")
{
ChT_Verbrauch.Series[1].Points.AddXY(Convert.ToDateTime(drReader.GetValue(1)), Convert.ToDouble(drReader.GetValue(0)));
}
}
drReader.Close();
oConnection.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "LoadUser");
}
}
private void CmD_Aufladen_Click(object sender, EventArgs e)
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommandUpdate = new OracleCommand();
int nResult = 0;
string sUser = "";
string sBetrag = "";
if (CmB_User.Text != "")
{
using (oConnection)
{
try
{
oConnection.ConnectionString = Frm_Haupt.sDSN;
oConnection.Open();
sUser = CmB_User.Text.Trim();
sBetrag = LbL_Aufladung.Text.Trim().Replace("€", " ").Trim();
oCommandUpdate.Connection = oConnection;
oCommandUpdate.CommandText = Cls_Query.InsertAufladung(sUser, sBetrag);
nResult = oCommandUpdate.ExecuteNonQuery();
if (nResult > 0)
{
nResult = 0;
oCommandUpdate.CommandText = Cls_Query.UpdateUserAufladung(sUser, sBetrag);
nResult = oCommandUpdate.ExecuteNonQuery();
}
LbL_Aufladung.Text = "0,00 €";
MessageBox.Show("Aufladung erfolgreich", "Info");
oConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "CmD_Aufladen_Click");
}
}
}
else
{
MessageBox.Show("Es ist kein Anwender ausgewählt", "Fehler");
}
}
private void LoadData()
{
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.GetGüterDaten(CmB_Güter.Text.Trim());
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
TxT_Preis.Text = drReader.GetValue(1).ToString().Trim();
if (drReader.GetValue(5).ToString().Trim() == "1")
{
ChK_Aktiv.Checked = false;
}
else
{
ChK_Aktiv.Checked = true;
}
bDataExists = true;
}
drReader.Close();
oConnection.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "LoadData");
}
}
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 LoadData()
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommand = new OracleCommand();
OracleDataReader drReader;
using (oConnection)
{
try
{
oConnection.ConnectionString = Frm_Haupt.sDSN;
oConnection.Open();
oCommand.Connection = oConnection;
oCommand.CommandText = Cls_Query.GetCocktailRezepte("", "");
drReader = oCommand.ExecuteReader();
DgV_Cocktails.AllowUserToAddRows = true;
DgV_Cocktails.Rows.Clear();
while (drReader.Read())
{
DataGridViewRow row = (DataGridViewRow)DgV_Cocktails.Rows[0].Clone();
row.Cells[0].Value = drReader.GetValue(0).ToString().Trim();
DgV_Cocktails.Rows.Add(row);
}
drReader.Close();
DgV_Cocktails.AllowUserToAddRows = false;
oConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "GetGüter");
}
}
}
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 CreateButtons()
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommand = new OracleCommand();
OracleDataReader drReader;
int nLocationX = 0;
int nLocationY = 0;
int nOffset = 0;
int nSpalte = 0;
int nOffsetX = 10;
int nOffsetY = 10;
int a = 0;
int b = 0;
try
{
using (oConnection)
{
oConnection.ConnectionString = Frm_Haupt.sDSN;
oConnection.Open();
#region Buttons für Cocktails erstellen
oCommand.Connection = oConnection;
oCommand.CommandText = Cls_Query.GetNumberOfCocktails();
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
nAnzahlButtonsCocktails = Convert.ToInt32(drReader.GetValue(0));
}
drReader.Close();
System.Windows.Forms.Button[] ButtonCocktails = new System.Windows.Forms.Button[nAnzahlButtonsCocktails];
oCommand.CommandText = Cls_Query.GetCocktailRezepte("", "1");
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
ButtonCocktails[a] = new Button();
ButtonCocktails[a].Height = 70;
ButtonCocktails[a].Width = 140;
nLocationY = (5 + ButtonCocktails[a].Height) * (a - nOffset) + nOffsetY;
nLocationX = (12 + ButtonCocktails[a].Width) * nSpalte + nOffsetX;
ButtonCocktails[a].Location = new Point(nLocationX, nLocationY);
ButtonCocktails[a].Name = "CmD_Cocktail_" + a.ToString().PadLeft(2, '0');
ButtonCocktails[a].Text = drReader.GetValue(0).ToString().Trim();
ButtonCocktails[a].Tag = drReader.GetValue(0).ToString().Trim();
ButtonCocktails[a].Font = new Font("Microsoft Sans Serif", 14.25f);
ButtonCocktails[a].Click += new EventHandler(buttonCocktail_Clicked);
FlW_Cocktails.Controls.Add(ButtonCocktails[a]);
//if (Convert.ToInt32(drReader.GetValue(5)) == 1 | Convert.ToInt32(drReader.GetValue(6)) > 5) { ButtonCocktails[a].Enabled = false; }
if (nLocationY > 550)
{
nOffset = a + 1; nSpalte += 1;
}
a++;
}
nAnzahlAnwender = a;
#endregion
oConnection.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "CreateButtons");
}
}
private void CmD_Buchen_Click(object sender, EventArgs e)
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommand = new OracleCommand();
OracleCommand oCommandUpdate = new OracleCommand();
OracleDataReader drReader;
int nDauerRelais = 0;
int nResult = 0;
string sUser = "";
string sItem = "";
string sAnzahl = "";
string sEinzelpreis = "";
string sSumme = "";
CmD_Buchen.Enabled = false;
CmD_InDenWarenkorb.Enabled = false;
CmD_LöschenWarenkorb.Enabled = false;
CmD_Logout.Enabled = false;
try
{
using (oConnection)
{
oConnection.ConnectionString = Frm_Haupt.sDSN;
oConnection.Open();
oCommand.Connection = oConnection;
for (int i = 0; i < DgV_Warenkorb.Rows.Count; i++)
{
oCommand.CommandText = Cls_Query.GetCocktailRezepte(DgV_Warenkorb.Rows[i].Cells[0].Value.ToString().Trim(), "1");
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
#region Klein Schwach
if (DgV_Warenkorb.Rows[i].Cells[1].Value.ToString().Trim() == "KLEIN_SCHWACH")
{
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(3)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x01, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x01, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(3 + 6)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x02, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x02, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(3 + 12)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x03, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x03, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(3 + 18)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x04, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x04, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(3 + 24)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x05, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x05, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(3 + 30)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x06, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x06, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(3 + 36)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x07, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x07, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(3 + 42)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x08, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x08, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(3 + 48)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x09, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x09, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(3 + 54)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x0A, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x0A, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(3 + 60)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x0B, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x0B, 0x00 }, 0, 3);
}
#endregion
#region Klein Mittel
if (DgV_Warenkorb.Rows[i].Cells[1].Value.ToString().Trim() == "KLEIN_MITTEL")
{
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(4)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x01, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x01, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(4 + 6)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x02, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x02, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(4 + 12)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x03, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x03, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(4 + 18)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x04, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x04, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(4 + 24)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x05, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x05, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(4 + 30)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x06, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x06, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(4 + 36)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x07, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x07, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(4 + 42)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x08, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x08, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(4 + 48)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x09, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x09, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(4 + 54)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x0A, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x0A, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(4 + 60)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x0B, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x0B, 0x00 }, 0, 3);
}
#endregion
#region Klein Stark
if (DgV_Warenkorb.Rows[i].Cells[1].Value.ToString().Trim() == "KLEIN_STARK")
{
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(5)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x01, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x01, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(5 + 6)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x02, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x02, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(5 + 12)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x03, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x03, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(5 + 18)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x04, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x04, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(5 + 24)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x05, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x05, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(5 + 30)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x06, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x06, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(5 + 36)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x07, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x07, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(5 + 42)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x08, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x08, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(5 + 48)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x09, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x09, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(5 + 54)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x0A, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x0A, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(5 + 60)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x0B, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x0B, 0x00 }, 0, 3);
}
#endregion
#region Groß Schwach
if (DgV_Warenkorb.Rows[i].Cells[1].Value.ToString().Trim() == "GROSS_SCHWACH")
{
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(6)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x01, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x01, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(6 + 6)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x02, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x02, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(6 + 12)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x03, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x03, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(6 + 18)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x04, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x04, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(6 + 24)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x05, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x05, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(6 + 30)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x06, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x06, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(6 + 36)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x07, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x07, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(6 + 42)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x08, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x08, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(6 + 48)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x09, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x09, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(6 + 54)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x0A, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x0A, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(6 + 60)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x0B, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x0B, 0x00 }, 0, 3);
}
#endregion
#region Groß Mittel
if (DgV_Warenkorb.Rows[i].Cells[1].Value.ToString().Trim() == "GROSS_MITTEL")
{
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(7)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x01, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x01, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(7 + 6)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x02, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x02, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(7 + 12)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x03, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x03, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(7 + 18)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x04, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x04, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(7 + 24)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x05, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x05, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(7 + 30)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x06, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x06, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(7 + 36)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x07, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x07, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(7 + 42)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x08, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x08, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(7 + 48)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x09, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x09, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(7 + 54)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x0A, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x0A, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(7 + 60)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x0B, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x0B, 0x00 }, 0, 3);
}
#endregion
#region Groß Stark
if (DgV_Warenkorb.Rows[i].Cells[1].Value.ToString().Trim() == "GROSS_STARK")
{
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(8)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x01, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x01, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(8 + 6)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x02, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x02, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(8 + 12)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x03, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x03, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(8 + 18)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x04, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x04, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(8 + 24)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x05, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x05, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(8 + 30)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x06, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x06, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(8 + 36)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x07, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x07, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(8 + 42)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x08, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x08, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(8 + 48)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x09, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x09, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(8 + 54)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x0A, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x0A, 0x00 }, 0, 3);
nDauerRelais = Convert.ToInt32(Convert.ToDouble(drReader.GetValue(8 + 60)) * 1000);
_serialPort.Write(new byte[] { 0xFF, 0x0B, 0x01 }, 0, 3);
Thread.Sleep(nDauerRelais);
_serialPort.Write(new byte[] { 0xFF, 0x0B, 0x00 }, 0, 3);
}
#endregion
}
drReader.Close();
sUser = LbL_User.Text.Trim();
sItem = DgV_Warenkorb.Rows[i].Cells[0].Value.ToString().Trim();
sAnzahl = "1";
sEinzelpreis = DgV_Warenkorb.Rows[i].Cells[2].Value.ToString().Trim();
sSumme = DgV_Warenkorb.Rows[i].Cells[3].Value.ToString().Trim();
oCommandUpdate.Connection = oConnection;
oCommandUpdate.CommandText = Cls_Query.InsertHistory(sUser, sItem, sAnzahl, sEinzelpreis, sSumme);
nResult = oCommandUpdate.ExecuteNonQuery();
if (nResult > 0)
{
nResult = 0;
oCommandUpdate.CommandText = Cls_Query.UpdateUserBudget(sUser, sSumme);
nResult = oCommandUpdate.ExecuteNonQuery();
}
MessageBox.Show("Cocktail fertig bitte entnehmen!\nFalls gewählt wird nach Bestätigung der nächste\nCocktail gemixt.");
}
oConnection.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "CmD_Buchen_Click");
}
CmD_Buchen.Enabled = true;
CmD_InDenWarenkorb.Enabled = true;
CmD_LöschenWarenkorb.Enabled = true;
CmD_Logout.Enabled = true;
this.Close();
}
private void buttonCocktail_Clicked(object sender, EventArgs e)
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommand = new OracleCommand();
OracleDataReader drReader;
bBlockRefresh = true;
Button angeklickterButton = (Button)sender;
string sName = angeklickterButton.Text.Trim();
sButtonClicked = angeklickterButton.Name;
sCocktailName = sName;
for (int i = 0; i < nAnzahlButtonsCocktails; i++)
{
if (GetAnwenderControlByName("CmD_Cocktail_" + i.ToString().PadLeft(2, '0')).Name == angeklickterButton.Name)
{
GetAnwenderControlByName("CmD_Cocktail_" + i.ToString().PadLeft(2, '0')).BackColor = Color.Green;
}
else
{
GetAnwenderControlByName("CmD_Cocktail_" + i.ToString().PadLeft(2, '0')).BackColor = Color.LightGray;
}
}
try
{
using (oConnection)
{
string sButtonTag = angeklickterButton.Tag.ToString().Trim();
oConnection.ConnectionString = Frm_Haupt.sDSN;
oConnection.Open();
oCommand.Connection = oConnection;
oCommand.CommandText = Cls_Query.GetCocktailRezepte(sButtonTag, "1");
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
if (drReader.GetValue(1).ToString().Trim() == "0")
{
CmD_Klein_Schwach.Visible = false;
}
else
{
CmD_Klein_Schwach.Visible = true;
}
if (drReader.GetValue(99).ToString().Trim() == "0")
{
CmD_klein_mittel.Visible = false;
}
else
{
CmD_klein_mittel.Visible = true;
}
if (drReader.GetValue(100).ToString().Trim() == "0")
{
CmD_Klein_Stark.Visible = false;
}
else
{
CmD_Klein_Stark.Visible = true;
}
if (drReader.GetValue(101).ToString().Trim() == "0")
{
CmD_Groß_schwach.Visible = false;
}
else
{
CmD_Groß_schwach.Visible = true;
}
if (drReader.GetValue(102).ToString().Trim() == "0")
{
CmD_Groß_mittel.Visible = false;
}
else
{
CmD_Groß_mittel.Visible = true;
}
if (drReader.GetValue(103).ToString().Trim() == "0")
{
CmD_Groß_stark.Visible = false;
}
else
{
CmD_Groß_stark.Visible = true;
}
CmD_Klein_Schwach.Text = "schwach\n" + String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(1))) + " €";
CmD_klein_mittel.Text = "mittel\n" + String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(99))) + " €";
CmD_Klein_Stark.Text = "stark\n" + String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(100))) + " €";
CmD_Groß_schwach.Text = "schwach\n" + String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(101))) + " €";
CmD_Groß_mittel.Text = "mittel\n" + String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(102))) + " €";
CmD_Groß_stark.Text = "stark\n" + String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(103))) + " €";
}
drReader.Close();
oConnection.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "buttonCocktail_Clicked");
}
}
private void CmD_Restore_Click(object sender, EventArgs e)
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommandSelect = new OracleCommand();
OracleCommand oCommandExecute = new OracleCommand();
OracleDataReader drReader;
int nCounter = 1;
int nResult = 0;
string sFileDatum = CmB_DatumBackup.Text.Substring(6, 4) + "_" + CmB_DatumBackup.Text.Substring(3, 2) + "_" + CmB_DatumBackup.Text.Substring(0, 2);
try
{
DataTable dtPersonen = GetTableFromCSV(Frm_Haupt.sRestorePfad + sFileDatum + "_Personen.csv", false);
DataTable dtGueter = GetTableFromCSV(Frm_Haupt.sRestorePfad + sFileDatum + "_Güter.csv", false);
DataTable dtAufadung = GetTableFromCSV(Frm_Haupt.sRestorePfad + sFileDatum + "_Aufladung.csv", false);
DataTable dtHistory = GetTableFromCSV(Frm_Haupt.sRestorePfad + sFileDatum + "_History.csv", false);
DataTable dtCocktails = GetTableFromCSV(Frm_Haupt.sRestorePfad + sFileDatum + "_Cocktails.csv", false);
RecreateTables();
using (oConnection)
{
oConnection.ConnectionString = Frm_Haupt.sDSN;
oConnection.Open();
oCommandSelect.Connection = oConnection;
oCommandExecute.Connection = oConnection;
PgB_Restore_Personen.Value = 0;
PgB_Restore_Güter.Value = 0;
PgB_Restore_Aufladung.Value = 0;
PgB_Restore_History.Value = 0;
PgB_Restore_Cocktails.Value = 0;
try {
PgB_Restore_Personen.Maximum = dtPersonen.Rows.Count;
}
catch { }
try
{
PgB_Restore_Güter.Maximum = dtGueter.Rows.Count;
}
catch { }
try
{
PgB_Restore_Aufladung.Maximum = dtAufadung.Rows.Count;
}
catch { }
try
{
PgB_Restore_History.Maximum = dtHistory.Rows.Count;
}
catch { }
try
{
PgB_Restore_Cocktails.Maximum = dtCocktails.Rows.Count;
}
catch { }
#region Restore der Tabelle Personen
nCounter = 1;
try
{
if (dtPersonen.Rows.Count > 0)
{
if (File.Exists(Frm_Haupt.sRestorePfad + sFileDatum + "_Personen.csv"))
{
string[] lines = File.ReadAllLines(Frm_Haupt.sRestorePfad + sFileDatum + "_Personen.csv");
string[][] parts = new string[lines.Length][];
for (int i = 0; i < lines.Length; i++)
{
parts[i] = lines[i].Split(';');
oCommandExecute.CommandText = Cls_Query.InsertUserRestore(parts[i][1], parts[i][3], parts[i][4], parts[i][5],
parts[i][6], parts[i][7], parts[i][8], parts[i][9], parts[i][10], parts[i][11], parts[i][12]);
nResult = oCommandExecute.ExecuteNonQuery();
PgB_Restore_Personen.Value = nCounter;
nCounter++;
}
}
}
}
catch { }
#endregion
#region Restore der Tabelle Güter
nCounter = 1;
try
{
if (dtGueter.Rows.Count > 0)
{
if (File.Exists(Frm_Haupt.sRestorePfad + sFileDatum + "_Güter.csv"))
{
string[] lines = File.ReadAllLines(Frm_Haupt.sRestorePfad + sFileDatum + "_Güter.csv");
string[][] parts = new string[lines.Length][];
for (int i = 0; i < lines.Length; i++)
{
parts[i] = lines[i].Split(';');
oCommandExecute.CommandText = Cls_Query.InsertGüterRestore(parts[i][0], parts[i][1], parts[i][2], parts[i][3],
parts[i][4], parts[i][5], parts[i][6]);
nResult = oCommandExecute.ExecuteNonQuery();
PgB_Restore_Güter.Value = nCounter;
nCounter++;
}
}
}
}
catch { }
#endregion
#region Restore der Tabelle Aufladungen
nCounter = 1;
try
{
if (dtAufadung.Rows.Count > 0)
{
if (File.Exists(Frm_Haupt.sRestorePfad + sFileDatum + "_Aufladung.csv"))
{
string[] lines = File.ReadAllLines(Frm_Haupt.sRestorePfad + sFileDatum + "_Aufladung.csv");
string[][] parts = new string[lines.Length][];
for (int i = 0; i < lines.Length; i++)
{
parts[i] = lines[i].Split(';');
oCommandExecute.CommandText = Cls_Query.InsertAufladungenRestore(parts[i][0], parts[i][1], parts[i][2]);
nResult = oCommandExecute.ExecuteNonQuery();
PgB_Restore_Aufladung.Value = nCounter;
nCounter++;
}
}
}
}
catch { }
#endregion
#region Restore der Tabelle History
nCounter = 1;
try
{
if (dtHistory.Rows.Count > 0)
{
if (File.Exists(Frm_Haupt.sRestorePfad + sFileDatum + "_History.csv"))
{
string[] lines = File.ReadAllLines(Frm_Haupt.sRestorePfad + sFileDatum + "_History.csv");
string[][] parts = new string[lines.Length][];
for (int i = 0; i < lines.Length; i++)
{
parts[i] = lines[i].Split(';');
oCommandExecute.CommandText = Cls_Query.InsertHistoryRestore(parts[i][0], parts[i][1], parts[i][2], parts[i][3],
parts[i][4], parts[i][5]);
nResult = oCommandExecute.ExecuteNonQuery();
PgB_Restore_History.Value = nCounter;
nCounter++;
}
}
}
}
catch (Exception ex) { }
#endregion
#region Restore der Tabelle Cocktails
nCounter = 1;
try
{
if (dtCocktails.Rows.Count > 0)
{
if (File.Exists(Frm_Haupt.sRestorePfad + sFileDatum + "_Cocktails.csv"))
{
string[] lines = File.ReadAllLines(Frm_Haupt.sRestorePfad + sFileDatum + "_Cocktails.csv");
string[][] parts = new string[lines.Length][];
for (int i = 0; i < lines.Length; i++)
{
parts[i] = lines[i].Split(';');
oCommandExecute.CommandText = Cls_Query.InsertNeuerCocktail(false, true,
parts[i][0],
"", parts[i][3], parts[i][4], parts[i][5], parts[i][6], parts[i][7], parts[i][8],
"", parts[i][9], parts[i][10], parts[i][11], parts[i][12], parts[i][13], parts[i][14],
"", parts[i][15], parts[i][16], parts[i][17], parts[i][18], parts[i][19], parts[i][20],
"", parts[i][21], parts[i][22], parts[i][23], parts[i][24], parts[i][25], parts[i][26],
"", parts[i][27], parts[i][28], parts[i][29], parts[i][30], parts[i][31], parts[i][32],
"", parts[i][33], parts[i][34], parts[i][35], parts[i][36], parts[i][37], parts[i][38],
"", parts[i][39], parts[i][40], parts[i][41], parts[i][42], parts[i][43], parts[i][44],
"", parts[i][45], parts[i][46], parts[i][47], parts[i][48], parts[i][49], parts[i][50],
"", parts[i][51], parts[i][52], parts[i][53], parts[i][54], parts[i][55], parts[i][56],
"", parts[i][57], parts[i][58], parts[i][59], parts[i][60], parts[i][61], parts[i][62],
"", parts[i][63], parts[i][64], parts[i][65], parts[i][66], parts[i][67], parts[i][68],
"", parts[i][69], parts[i][70], parts[i][71], parts[i][72], parts[i][73], parts[i][74],
"", parts[i][75], parts[i][76], parts[i][77], parts[i][78], parts[i][79], parts[i][80],
"", parts[i][81], parts[i][82], parts[i][83], parts[i][84], parts[i][85], parts[i][86],
"", parts[i][87], parts[i][88], parts[i][89], parts[i][90], parts[i][91], parts[i][92],
"", parts[i][93], parts[i][94], parts[i][95], parts[i][96], parts[i][97], parts[i][98],
parts[i][1], parts[i][99], parts[i][100], parts[i][101], parts[i][102], parts[i][103],
parts[i][2]);
nResult = oCommandExecute.ExecuteNonQuery();
PgB_Restore_Cocktails.Value = nCounter;
nCounter++;
}
}
}
}
catch (Exception ex) { }
#endregion
oConnection.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "CmD_Restore_Click");
}
}
private void RecreateTables()
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommand = new OracleCommand();
int nResult = 0;
if (MessageBox.Show("ACHTUNG!!\n\nTabellen werden neu erstellt und vorhande Daten gelöscht! Wirklich durchführen?", "Info", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
using (oConnection)
{
oConnection.ConnectionString = Frm_Haupt.sDSN;
oConnection.Open();
oCommand.Connection = oConnection;
//Tabelle Aufladungen erstellen
try
{
oCommand.CommandText = Cls_Query.DropTableAufladungen();
nResult = oCommand.ExecuteNonQuery();
}
catch { }
try
{
oCommand.CommandText = Cls_Query.CreateTableAufladungen();
nResult = oCommand.ExecuteNonQuery();
}
catch { }
//Tabelle History erstellen
try
{
oCommand.CommandText = Cls_Query.DropTableHistorydaten();
nResult = oCommand.ExecuteNonQuery();
}
catch { }
try
{
oCommand.CommandText = Cls_Query.CreateTableHistory();
nResult = oCommand.ExecuteNonQuery();
}
catch { }
//Tabelle Verbrauch erstellen
try
{
oCommand.CommandText = Cls_Query.DropTableGüterdaten();
nResult = oCommand.ExecuteNonQuery();
}
catch { }
try
{
oCommand.CommandText = Cls_Query.CreateTableGüter();
nResult = oCommand.ExecuteNonQuery();
}
catch { }
//Tabelle Personen erstellen
try
{
oCommand.CommandText = Cls_Query.DropTableNamen();
nResult = oCommand.ExecuteNonQuery();
}
catch { }
try
{
oCommand.CommandText = Cls_Query.CreateTableNamen();
nResult = oCommand.ExecuteNonQuery();
}
catch { }
//Sequence Personen erstellen
try
{
oCommand.CommandText = Cls_Query.DropSequenceUserID();
nResult = oCommand.ExecuteNonQuery();
}
catch { }
try
{
oCommand.CommandText = Cls_Query.CreateSequenceUserID("1");
nResult = oCommand.ExecuteNonQuery();
}
catch { }
//Constraints erstellen
try
{
oCommand.CommandText = Cls_Query.AddUniqueConstraintPersonen();
nResult = oCommand.ExecuteNonQuery();
oCommand.CommandText = Cls_Query.AddForeignKeyAufladungen();
nResult = oCommand.ExecuteNonQuery();
oCommand.CommandText = Cls_Query.AddForeignKeyHistory();
nResult = oCommand.ExecuteNonQuery();
}
catch { }
try
{
oCommand.CommandText = Cls_Query.DropTableCocktails();
nResult = oCommand.ExecuteNonQuery();
}
catch { }
try
{
oCommand.CommandText = Cls_Query.CreateTableCocktails();
nResult = oCommand.ExecuteNonQuery();
}
catch { }
oConnection.Close();
}
}
}
private void Buchen()
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommandUpdate = new OracleCommand();
OracleCommand oCommandSelect = new OracleCommand();
OracleDataReader drReader;
int nResult = 0;
string sUser = "";
string sItem = "";
string sAnzahl = "";
string sEinzelpreis = "";
string sSumme = "";
using (oConnection)
{
try
{
oConnection.ConnectionString = sDSN;
oConnection.Open();
oCommandUpdate.Connection = oConnection;
oCommandSelect.Connection = oConnection;
for (int i = 0; i < DgV_Warenkorb.Rows.Count; i++)
{
sUser = LbL_User.Text.Trim();
sItem = DgV_Warenkorb.Rows[i].Cells[0].Value.ToString().Trim();
sAnzahl = DgV_Warenkorb.Rows[i].Cells[1].Value.ToString().Trim();
sEinzelpreis = DgV_Warenkorb.Rows[i].Cells[2].Value.ToString().Trim();
sSumme = DgV_Warenkorb.Rows[i].Cells[3].Value.ToString().Trim();
oCommandUpdate.CommandText = Cls_Query.InsertHistory(sUser, sItem, sAnzahl, sEinzelpreis, sSumme);
nResult = oCommandUpdate.ExecuteNonQuery();
if (nResult > 0)
{
nResult = 0;
oCommandUpdate.CommandText = Cls_Query.UpdateUserBudget(sUser, sSumme);
nResult = oCommandUpdate.ExecuteNonQuery();
}
}
oCommandSelect.CommandText = Cls_Query.GetAnwenderDaten(sUser, false, "");
drReader = oCommandSelect.ExecuteReader();
while (drReader.Read())
{
LbL_Budget.Text = String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(8))) + " €";
LbL_Kredit.Text = String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(9))) + " €";
}
drReader.Close();
GetAnwenderControlByName(sButtonClicked).Text = LbL_User.Text.Trim() + "\n" + LbL_Budget.Text.Trim();
DgV_Warenkorb.Rows.Clear();
LbL_Summe.Text = "0,00 €";
LbL_Verfügbar.Text = "0,00 €";
oConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "CmD_Buchen_Click");
}
}
if (bGeburtstagsModus == false)
{
DisableGüter();
LbL_Summe.Text = "0,00 €";
LbL_Budget.Text = "0,00 €";
LbL_Verfügbar.Text = "0,00 €";
LbL_Kredit.Text = "0,00 €";
LbL_User.Text = "";
CmD_Systemsteuerung.Enabled = true;
bBlockRefresh = false;
}
}
private void CmD_Cocktailmixer_Click(object sender, EventArgs e)
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommandSelect = new OracleCommand();
OracleDataReader drReader;
string sUser = "";
sUser = LbL_User.Text.Trim();
Frm_CocktailMixer frm_cocktailmixer = new Frm_CocktailMixer();
frm_cocktailmixer.LbL_Budget.Text = LbL_Budget.Text;
frm_cocktailmixer.LbL_Kredit.Text = LbL_Kredit.Text;
frm_cocktailmixer.LbL_Summe.Text = "0,00 €";
frm_cocktailmixer.LbL_User.Text = LbL_User.Text.Trim();
//frm_cocktailmixer.LbL_Verfügbar.Text = "0,00 €";
frm_cocktailmixer.ShowDialog();
if (bGeburtstagsModus == false)
{
DisableGüter();
LbL_Summe.Text = "0,00 €";
LbL_Budget.Text = "0,00 €";
LbL_Verfügbar.Text = "0,00 €";
LbL_Kredit.Text = "0,00 €";
DgV_Warenkorb.Rows.Clear();
CmD_Systemsteuerung.Enabled = true;
bBlockRefresh = false;
using (oConnection)
{
try
{
oConnection.ConnectionString = sDSN;
oConnection.Open();
oCommandSelect.Connection = oConnection;
oCommandSelect.CommandText = Cls_Query.GetAnwenderDaten(sUser, false, "");
drReader = oCommandSelect.ExecuteReader();
while (drReader.Read())
{
LbL_Budget.Text = String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(8))) + " €";
LbL_Kredit.Text = String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(9))) + " €";
}
drReader.Close();
GetAnwenderControlByName(sButtonClicked).Text = LbL_User.Text.Trim() + "\n" + LbL_Budget.Text.Trim();
DgV_Warenkorb.Rows.Clear();
LbL_Summe.Text = "0,00 €";
LbL_Verfügbar.Text = "0,00 €";
LbL_User.Text = "";
oConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "CmD_Cocktailmixer_Click");
}
}
}
else
{
using (oConnection)
{
try
{
oConnection.ConnectionString = sDSN;
oConnection.Open();
oCommandSelect.Connection = oConnection;
oCommandSelect.CommandText = Cls_Query.GetAnwenderDaten(sUser, false, "");
drReader = oCommandSelect.ExecuteReader();
while (drReader.Read())
{
LbL_Budget.Text = String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(8))) + " €";
LbL_Kredit.Text = String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(9))) + " €";
}
drReader.Close();
GetAnwenderControlByName(sButtonClicked).Text = LbL_User.Text.Trim() + "\n" + LbL_Budget.Text.Trim();
oConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "CmD_Cocktailmixer_Click");
}
}
}
}
private void buttonGüter_Clicked(object sender, EventArgs e)
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommandSelect = new OracleCommand();
OracleDataReader drReader;
Button angeklickterButton = (Button)sender;
string sItem = angeklickterButton.Text;
int nAnzahl = 0;
int nIndex = 0;
int nPositionReturn = sItem.IndexOf("\n", 0);
bool bFound = false;
bool bKreditOK = false;
double nPreis = 0;
double nSumme = 0;
double nWarenkorbSumme = 0;
double nVerfügbar = 0;
angeklickterButton.Enabled = false;
sItem = sItem.Substring(0, nPositionReturn);
using (oConnection)
{
try
{
oConnection.ConnectionString = sDSN;
oConnection.Open();
oCommandSelect.Connection = oConnection;
oCommandSelect.CommandText = Cls_Query.GetGüterDaten(sItem);
drReader = oCommandSelect.ExecuteReader();
while (drReader.Read())
{
for (int i = 0; i < DgV_Warenkorb.Rows.Count; i++)
{
if (sItem == DgV_Warenkorb.Rows[i].Cells[0].Value.ToString().Trim())
{
nAnzahl = Convert.ToInt32(DgV_Warenkorb.Rows[i].Cells[1].Value) + 1;
nIndex = i;
bFound = true;
}
}
nPreis = Convert.ToDouble(drReader.GetValue(1));
nSumme = Math.Round(nPreis * nAnzahl, 2);
}
drReader.Close();
string sBudget = LbL_Budget.Text.Trim().Substring(0, LbL_Budget.Text.Trim().Length - 2);
string sKredit = LbL_Kredit.Text.Trim().Substring(0, LbL_Kredit.Text.Trim().Length - 2);
string sWarenkorb = LbL_Summe.Text.Trim().Substring(0, LbL_Summe.Text.Trim().Length - 2);
nVerfügbar = (Convert.ToDouble(sBudget) + Convert.ToDouble(sKredit)) - Convert.ToDouble(sWarenkorb) - nPreis;
if (nVerfügbar >= 0)
{
bKreditOK = true;
}
else
{
bKreditOK = false;
}
if (bKreditOK == true)
{
DgV_Warenkorb.AllowUserToAddRows = true;
if (bFound == false)
{
DataGridViewRow row = (DataGridViewRow)DgV_Warenkorb.Rows[0].Clone();
row.Height = 45;
row.Cells[0].Value = sItem;
row.Cells[1].Value = 1;
row.Cells[2].Value = nPreis;
row.Cells[3].Value = nPreis;
DgV_Warenkorb.Rows.Add(row);
}
else
{
DgV_Warenkorb.Rows[nIndex].Cells[1].Value = nAnzahl;
DgV_Warenkorb.Rows[nIndex].Cells[2].Value = nPreis;
DgV_Warenkorb.Rows[nIndex].Cells[3].Value = nSumme;
}
for (int i = 0; i < DgV_Warenkorb.Rows.Count; i++)
{
nWarenkorbSumme += Convert.ToDouble(DgV_Warenkorb.Rows[i].Cells[3].Value);
}
LbL_Summe.Text = String.Format("{0:0.00}", nWarenkorbSumme) + " €";
DgV_Warenkorb.AllowUserToAddRows = false;
}
else
{
MessageBox.Show("Verfügbarer Kreditrahmen reicht nicht aus, bitte Konto auffüllen", "Fehler", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
oConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "buttonGüter_Clicked");
}
}
angeklickterButton.Enabled = true;
}
private void SaveData()
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommandSelect = new OracleCommand();
OracleCommand oCommandInsert = new OracleCommand();
OracleDataReader drReader;
bool bUpdate = false;
bool bInsert = false;
int nResult = 0;
string sAktiv = "";
if (ChK_Aktiv.Checked == true)
{
sAktiv = "1";
}
else
{
sAktiv = "0";
}
using (oConnection)
{
try
{
oConnection.ConnectionString = Frm_Haupt.sDSN;
oConnection.Open();
oCommandSelect.Connection = oConnection;
oCommandInsert.Connection = oConnection;
oCommandSelect.CommandText = Cls_Query.GetCocktailRezepte(TxT_Name.Text.Trim(), "");
drReader = oCommandSelect.ExecuteReader();
if (drReader.HasRows)
{
bUpdate = true; bInsert = false;
}
else
{
bUpdate = false; bInsert = true;
}
drReader.Close();
oCommandInsert.CommandText = Cls_Query.InsertNeuerCocktail(bUpdate, bInsert, TxT_Name.Text.Trim(),
LbL_Zutat_01.Text.Trim(),
NuD_Klein_Schwach_01.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Mittel_01.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Stark_01.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Schwach_01.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Mittel_01.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Stark_01.Value.ToString().Trim().Replace(",", "."),
LbL_Zutat_02.Text.Trim(),
NuD_Klein_Schwach_02.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Mittel_02.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Stark_02.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Schwach_02.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Mittel_02.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Stark_02.Value.ToString().Trim().Replace(",", "."),
LbL_Zutat_03.Text.Trim(),
NuD_Klein_Schwach_03.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Mittel_03.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Stark_03.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Schwach_03.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Mittel_03.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Stark_03.Value.ToString().Trim().Replace(",", "."),
LbL_Zutat_04.Text.Trim(),
NuD_Klein_Schwach_04.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Mittel_04.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Stark_04.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Schwach_04.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Mittel_04.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Stark_04.Value.ToString().Trim().Replace(",", "."),
LbL_Zutat_05.Text.Trim(),
NuD_Klein_Schwach_05.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Mittel_05.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Stark_05.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Schwach_05.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Mittel_05.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Stark_05.Value.ToString().Trim().Replace(",", "."),
LbL_Zutat_06.Text.Trim(),
NuD_Klein_Schwach_06.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Mittel_06.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Stark_06.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Schwach_06.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Mittel_06.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Stark_06.Value.ToString().Trim().Replace(",", "."),
LbL_Zutat_07.Text.Trim(),
NuD_Klein_Schwach_07.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Mittel_07.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Stark_07.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Schwach_07.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Mittel_07.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Stark_07.Value.ToString().Trim().Replace(",", "."),
LbL_Zutat_08.Text.Trim(),
NuD_Klein_Schwach_08.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Mittel_08.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Stark_08.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Schwach_08.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Mittel_08.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Stark_08.Value.ToString().Trim().Replace(",", "."),
LbL_Zutat_09.Text.Trim(),
NuD_Klein_Schwach_09.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Mittel_09.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Stark_09.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Schwach_09.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Mittel_09.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Stark_09.Value.ToString().Trim().Replace(",", "."),
LbL_Zutat_10.Text.Trim(),
NuD_Klein_Schwach_10.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Mittel_10.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Stark_10.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Schwach_10.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Mittel_10.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Stark_10.Value.ToString().Trim().Replace(",", "."),
LbL_Zutat_11.Text.Trim(),
NuD_Klein_Schwach_11.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Mittel_11.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Stark_11.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Schwach_11.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Mittel_11.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Stark_11.Value.ToString().Trim().Replace(",", "."),
LbL_Zutat_12.Text.Trim(),
NuD_Klein_Schwach_12.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Mittel_12.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Stark_12.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Schwach_12.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Mittel_12.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Stark_12.Value.ToString().Trim().Replace(",", "."),
LbL_Zutat_13.Text.Trim(),
NuD_Klein_Schwach_13.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Mittel_13.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Stark_13.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Schwach_13.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Mittel_13.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Stark_13.Value.ToString().Trim().Replace(",", "."),
LbL_Zutat_14.Text.Trim(),
NuD_Klein_Schwach_14.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Mittel_14.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Stark_14.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Schwach_14.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Mittel_14.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Stark_14.Value.ToString().Trim().Replace(",", "."),
LbL_Zutat_15.Text.Trim(),
NuD_Klein_Schwach_15.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Mittel_15.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Stark_15.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Schwach_15.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Mittel_15.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Stark_15.Value.ToString().Trim().Replace(",", "."),
LbL_Zutat_16.Text.Trim(),
NuD_Klein_Schwach_16.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Mittel_16.Value.ToString().Trim().Replace(",", "."),
NuD_Klein_Stark_16.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Schwach_16.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Mittel_16.Value.ToString().Trim().Replace(",", "."),
NuD_Groß_Stark_16.Value.ToString().Trim().Replace(",", "."),
TxT_Preis_Klein_Schwach.Text.Trim().Replace(",", "."),
TxT_Preis_Klein_Mittel.Text.Trim().Replace(",", "."),
TxT_Preis_Klein_Stark.Text.Trim().Replace(",", "."),
TxT_Preis_Gross_Schwach.Text.Trim().Replace(",", "."),
TxT_Preis_Gross_Mittel.Text.Trim().Replace(",", "."),
TxT_Preis_Gross_Stark.Text.Trim().Replace(",", "."),
sAktiv);
nResult = oCommandInsert.ExecuteNonQuery();
oCommandInsert.CommandText = Cls_Query.SaveGüterDaten(bInsert, bUpdate, TxT_Name.Text.Trim(), "0", "1");
nResult = oCommandInsert.ExecuteNonQuery();
oConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "GetGüter");
}
}
}
private void LoadDataEinzeln()
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommand = new OracleCommand();
OracleDataReader drReader;
int nZähler = 0;
using (oConnection)
{
try
{
oConnection.ConnectionString = Frm_Haupt.sDSN;
oConnection.Open();
oCommand.Connection = oConnection;
oCommand.CommandText = Cls_Query.GetCocktailRezepte(TxT_Name.Text.Trim(), "");
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
TxT_Preis_Klein_Schwach.Text = drReader.GetValue(1).ToString().Trim();
TxT_Preis_Klein_Mittel.Text = drReader.GetValue(99).ToString().Trim();
TxT_Preis_Klein_Stark.Text = drReader.GetValue(100).ToString().Trim();
TxT_Preis_Gross_Schwach.Text = drReader.GetValue(101).ToString().Trim();
TxT_Preis_Gross_Mittel.Text = drReader.GetValue(102).ToString().Trim();
TxT_Preis_Gross_Stark.Text = drReader.GetValue(103).ToString().Trim();
if (drReader.GetValue(2).ToString().Trim() == "1")
{
ChK_Aktiv.Checked = true;
}
else
{
ChK_Aktiv.Checked = false;
}
NuD_Klein_Schwach_01.Value = Convert.ToDecimal(drReader.GetValue(3 + nZähler));
NuD_Klein_Mittel_01.Value = Convert.ToDecimal(drReader.GetValue(4 + nZähler));
NuD_Klein_Stark_01.Value = Convert.ToDecimal(drReader.GetValue(5 + nZähler));
NuD_Groß_Schwach_01.Value = Convert.ToDecimal(drReader.GetValue(6 + nZähler));
NuD_Groß_Mittel_01.Value = Convert.ToDecimal(drReader.GetValue(7 + nZähler));
NuD_Groß_Stark_01.Value = Convert.ToDecimal(drReader.GetValue(8 + nZähler));
nZähler = nZähler + 6;
NuD_Klein_Schwach_02.Value = Convert.ToDecimal(drReader.GetValue(3 + nZähler));
NuD_Klein_Mittel_02.Value = Convert.ToDecimal(drReader.GetValue(4 + nZähler));
NuD_Klein_Stark_02.Value = Convert.ToDecimal(drReader.GetValue(5 + nZähler));
NuD_Groß_Schwach_02.Value = Convert.ToDecimal(drReader.GetValue(6 + nZähler));
NuD_Groß_Mittel_02.Value = Convert.ToDecimal(drReader.GetValue(7 + nZähler));
NuD_Groß_Stark_02.Value = Convert.ToDecimal(drReader.GetValue(8 + nZähler));
nZähler = nZähler + 6;
NuD_Klein_Schwach_03.Value = Convert.ToDecimal(drReader.GetValue(3 + nZähler));
NuD_Klein_Mittel_03.Value = Convert.ToDecimal(drReader.GetValue(4 + nZähler));
NuD_Klein_Stark_03.Value = Convert.ToDecimal(drReader.GetValue(5 + nZähler));
NuD_Groß_Schwach_03.Value = Convert.ToDecimal(drReader.GetValue(6 + nZähler));
NuD_Groß_Mittel_03.Value = Convert.ToDecimal(drReader.GetValue(7 + nZähler));
NuD_Groß_Stark_03.Value = Convert.ToDecimal(drReader.GetValue(8 + nZähler));
nZähler = nZähler + 6;
NuD_Klein_Schwach_04.Value = Convert.ToDecimal(drReader.GetValue(3 + nZähler));
NuD_Klein_Mittel_04.Value = Convert.ToDecimal(drReader.GetValue(4 + nZähler));
NuD_Klein_Stark_04.Value = Convert.ToDecimal(drReader.GetValue(5 + nZähler));
NuD_Groß_Schwach_04.Value = Convert.ToDecimal(drReader.GetValue(6 + nZähler));
NuD_Groß_Mittel_04.Value = Convert.ToDecimal(drReader.GetValue(7 + nZähler));
NuD_Groß_Stark_04.Value = Convert.ToDecimal(drReader.GetValue(8 + nZähler));
nZähler = nZähler + 6;
NuD_Klein_Schwach_05.Value = Convert.ToDecimal(drReader.GetValue(3 + nZähler));
NuD_Klein_Mittel_05.Value = Convert.ToDecimal(drReader.GetValue(4 + nZähler));
NuD_Klein_Stark_05.Value = Convert.ToDecimal(drReader.GetValue(5 + nZähler));
NuD_Groß_Schwach_05.Value = Convert.ToDecimal(drReader.GetValue(6 + nZähler));
NuD_Groß_Mittel_05.Value = Convert.ToDecimal(drReader.GetValue(7 + nZähler));
NuD_Groß_Stark_05.Value = Convert.ToDecimal(drReader.GetValue(8 + nZähler));
nZähler = nZähler + 6;
NuD_Klein_Schwach_06.Value = Convert.ToDecimal(drReader.GetValue(3 + nZähler));
NuD_Klein_Mittel_06.Value = Convert.ToDecimal(drReader.GetValue(4 + nZähler));
NuD_Klein_Stark_06.Value = Convert.ToDecimal(drReader.GetValue(5 + nZähler));
NuD_Groß_Schwach_06.Value = Convert.ToDecimal(drReader.GetValue(6 + nZähler));
NuD_Groß_Mittel_06.Value = Convert.ToDecimal(drReader.GetValue(7 + nZähler));
NuD_Groß_Stark_06.Value = Convert.ToDecimal(drReader.GetValue(8 + nZähler));
nZähler = nZähler + 6;
NuD_Klein_Schwach_07.Value = Convert.ToDecimal(drReader.GetValue(3 + nZähler));
NuD_Klein_Mittel_07.Value = Convert.ToDecimal(drReader.GetValue(4 + nZähler));
NuD_Klein_Stark_07.Value = Convert.ToDecimal(drReader.GetValue(5 + nZähler));
NuD_Groß_Schwach_07.Value = Convert.ToDecimal(drReader.GetValue(6 + nZähler));
NuD_Groß_Mittel_07.Value = Convert.ToDecimal(drReader.GetValue(7 + nZähler));
NuD_Groß_Stark_07.Value = Convert.ToDecimal(drReader.GetValue(8 + nZähler));
nZähler = nZähler + 6;
NuD_Klein_Schwach_08.Value = Convert.ToDecimal(drReader.GetValue(3 + nZähler));
NuD_Klein_Mittel_08.Value = Convert.ToDecimal(drReader.GetValue(4 + nZähler));
NuD_Klein_Stark_08.Value = Convert.ToDecimal(drReader.GetValue(5 + nZähler));
NuD_Groß_Schwach_08.Value = Convert.ToDecimal(drReader.GetValue(6 + nZähler));
NuD_Groß_Mittel_08.Value = Convert.ToDecimal(drReader.GetValue(7 + nZähler));
NuD_Groß_Stark_08.Value = Convert.ToDecimal(drReader.GetValue(8 + nZähler));
nZähler = nZähler + 6;
NuD_Klein_Schwach_09.Value = Convert.ToDecimal(drReader.GetValue(3 + nZähler));
NuD_Klein_Mittel_09.Value = Convert.ToDecimal(drReader.GetValue(4 + nZähler));
NuD_Klein_Stark_09.Value = Convert.ToDecimal(drReader.GetValue(5 + nZähler));
NuD_Groß_Schwach_09.Value = Convert.ToDecimal(drReader.GetValue(6 + nZähler));
NuD_Groß_Mittel_09.Value = Convert.ToDecimal(drReader.GetValue(7 + nZähler));
NuD_Groß_Stark_09.Value = Convert.ToDecimal(drReader.GetValue(8 + nZähler));
nZähler = nZähler + 6;
NuD_Klein_Schwach_10.Value = Convert.ToDecimal(drReader.GetValue(3 + nZähler));
NuD_Klein_Mittel_10.Value = Convert.ToDecimal(drReader.GetValue(4 + nZähler));
NuD_Klein_Stark_10.Value = Convert.ToDecimal(drReader.GetValue(5 + nZähler));
NuD_Groß_Schwach_10.Value = Convert.ToDecimal(drReader.GetValue(6 + nZähler));
NuD_Groß_Mittel_10.Value = Convert.ToDecimal(drReader.GetValue(7 + nZähler));
NuD_Groß_Stark_10.Value = Convert.ToDecimal(drReader.GetValue(8 + nZähler));
nZähler = nZähler + 6;
NuD_Klein_Schwach_11.Value = Convert.ToDecimal(drReader.GetValue(3 + nZähler));
NuD_Klein_Mittel_11.Value = Convert.ToDecimal(drReader.GetValue(4 + nZähler));
NuD_Klein_Stark_11.Value = Convert.ToDecimal(drReader.GetValue(5 + nZähler));
NuD_Groß_Schwach_11.Value = Convert.ToDecimal(drReader.GetValue(6 + nZähler));
NuD_Groß_Mittel_11.Value = Convert.ToDecimal(drReader.GetValue(7 + nZähler));
NuD_Groß_Stark_11.Value = Convert.ToDecimal(drReader.GetValue(8 + nZähler));
nZähler = nZähler + 6;
NuD_Klein_Schwach_12.Value = Convert.ToDecimal(drReader.GetValue(3 + nZähler));
NuD_Klein_Mittel_12.Value = Convert.ToDecimal(drReader.GetValue(4 + nZähler));
NuD_Klein_Stark_12.Value = Convert.ToDecimal(drReader.GetValue(5 + nZähler));
NuD_Groß_Schwach_12.Value = Convert.ToDecimal(drReader.GetValue(6 + nZähler));
NuD_Groß_Mittel_12.Value = Convert.ToDecimal(drReader.GetValue(7 + nZähler));
NuD_Groß_Stark_12.Value = Convert.ToDecimal(drReader.GetValue(8 + nZähler));
nZähler = nZähler + 6;
NuD_Klein_Schwach_13.Value = Convert.ToDecimal(drReader.GetValue(3 + nZähler));
NuD_Klein_Mittel_13.Value = Convert.ToDecimal(drReader.GetValue(4 + nZähler));
NuD_Klein_Stark_13.Value = Convert.ToDecimal(drReader.GetValue(5 + nZähler));
NuD_Groß_Schwach_13.Value = Convert.ToDecimal(drReader.GetValue(6 + nZähler));
NuD_Groß_Mittel_13.Value = Convert.ToDecimal(drReader.GetValue(7 + nZähler));
NuD_Groß_Stark_13.Value = Convert.ToDecimal(drReader.GetValue(8 + nZähler));
nZähler = nZähler + 6;
NuD_Klein_Schwach_14.Value = Convert.ToDecimal(drReader.GetValue(3 + nZähler));
NuD_Klein_Mittel_14.Value = Convert.ToDecimal(drReader.GetValue(4 + nZähler));
NuD_Klein_Stark_14.Value = Convert.ToDecimal(drReader.GetValue(5 + nZähler));
NuD_Groß_Schwach_14.Value = Convert.ToDecimal(drReader.GetValue(6 + nZähler));
NuD_Groß_Mittel_14.Value = Convert.ToDecimal(drReader.GetValue(7 + nZähler));
NuD_Groß_Stark_14.Value = Convert.ToDecimal(drReader.GetValue(8 + nZähler));
nZähler = nZähler + 6;
NuD_Klein_Schwach_15.Value = Convert.ToDecimal(drReader.GetValue(3 + nZähler));
NuD_Klein_Mittel_15.Value = Convert.ToDecimal(drReader.GetValue(4 + nZähler));
NuD_Klein_Stark_15.Value = Convert.ToDecimal(drReader.GetValue(5 + nZähler));
NuD_Groß_Schwach_15.Value = Convert.ToDecimal(drReader.GetValue(6 + nZähler));
NuD_Groß_Mittel_15.Value = Convert.ToDecimal(drReader.GetValue(7 + nZähler));
NuD_Groß_Stark_15.Value = Convert.ToDecimal(drReader.GetValue(8 + nZähler));
nZähler = nZähler + 6;
NuD_Klein_Schwach_16.Value = Convert.ToDecimal(drReader.GetValue(3 + nZähler));
NuD_Klein_Mittel_16.Value = Convert.ToDecimal(drReader.GetValue(4 + nZähler));
NuD_Klein_Stark_16.Value = Convert.ToDecimal(drReader.GetValue(5 + nZähler));
NuD_Groß_Schwach_16.Value = Convert.ToDecimal(drReader.GetValue(6 + nZähler));
NuD_Groß_Mittel_16.Value = Convert.ToDecimal(drReader.GetValue(7 + nZähler));
NuD_Groß_Stark_16.Value = Convert.ToDecimal(drReader.GetValue(8 + nZähler));
nZähler = nZähler + 6;
}
drReader.Close();
oConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "GetGüter");
}
}
}
private void buttonNamen_Clicked(object sender, EventArgs e)
{
bBlockRefresh = true;
string sSammeluser = "";
XmlDocument doc = new XmlDocument();
doc.Load("Settings.xml");
XmlNode nodeSammelUser = doc.SelectSingleNode("/Bauwagen/Software/Gemeinschaftsuser");
sSammeluser = nodeSammelUser.FirstChild.Value;
Button angeklickterButton = (Button)sender;
string sName = angeklickterButton.Text.Trim();
int nPositionReturn = sName.IndexOf("\n", 0);
if (nPositionReturn < 0)
{
nPositionReturn = sName.Length;
}
sName = sName.Substring(0, nPositionReturn);
if (sName == "Bauwogn Gmeinschaft")
{
sName = sSammeluser;
}
Frm_Login frm_login = new Frm_Login();
frm_login.LbL_Status.Text = "user";
frm_login.LbL_Username.Text = sName;
if (frm_login.ShowDialog() == DialogResult.OK)
{
EnableGüter();
CmD_GebModus.Enabled = true;
CmD_Systemsteuerung.Enabled = false;
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommandSelect = new OracleCommand();
OracleCommand oCommandUpdate = new OracleCommand();
OracleDataReader drReader;
int nResult = 0;
using (oConnection)
{
try
{
oConnection.ConnectionString = sDSN;
oConnection.Open();
oCommandSelect.Connection = oConnection;
oCommandUpdate.Connection = oConnection;
oCommandSelect.CommandText = Cls_Query.GetAnwenderDaten(sName, false, "");
drReader = oCommandSelect.ExecuteReader();
while (drReader.Read())
{
LbL_Budget.Text = String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(8))) + " €";
LbL_Kredit.Text = String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(9))) + " €";
}
drReader.Close();
sButtonClicked = angeklickterButton.Name;
LbL_User.Text = sName;
oConnection.Clone();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "buttonNamen_Clicked");
}
}
}
else
{
DisableGüter();
CmD_Systemsteuerung.Enabled = true;
bBlockRefresh = false;
}
}
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;
}
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 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");
}
}
public static void BackupData()
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommand = new OracleCommand();
OracleDataReader drReader;
int nCounter = 0;
StringBuilder sb = new StringBuilder();
StreamWriter swPersonen = new StreamWriter(Frm_Haupt.sBackupPfad + System.DateTime.Now.Year.ToString().Trim() + "_" + System.DateTime.Now.Month.ToString().Trim().PadLeft(2, '0') + "_" + System.DateTime.Now.Day.ToString().Trim().PadLeft(2, '0') + "_Personen.csv");
StreamWriter swGüter = new StreamWriter(Frm_Haupt.sBackupPfad + System.DateTime.Now.Year.ToString().Trim() + "_" + System.DateTime.Now.Month.ToString().Trim().PadLeft(2, '0') + "_" + System.DateTime.Now.Day.ToString().Trim().PadLeft(2, '0') + "_Güter.csv");
StreamWriter swAufladung = new StreamWriter(Frm_Haupt.sBackupPfad + System.DateTime.Now.Year.ToString().Trim() + "_" + System.DateTime.Now.Month.ToString().Trim().PadLeft(2, '0') + "_" + System.DateTime.Now.Day.ToString().Trim().PadLeft(2, '0') + "_Aufladung.csv");
StreamWriter swHistory = new StreamWriter(Frm_Haupt.sBackupPfad + System.DateTime.Now.Year.ToString().Trim() + "_" + System.DateTime.Now.Month.ToString().Trim().PadLeft(2, '0') + "_" + System.DateTime.Now.Day.ToString().Trim().PadLeft(2, '0') + "_History.csv");
StreamWriter swCocktails = new StreamWriter(Frm_Haupt.sBackupPfad + System.DateTime.Now.Year.ToString().Trim() + "_" + System.DateTime.Now.Month.ToString().Trim().PadLeft(2, '0') + "_" + System.DateTime.Now.Day.ToString().Trim().PadLeft(2, '0') + "_Cocktails.csv");
try
{
using (oConnection)
{
oConnection.ConnectionString = Frm_Haupt.sDSN;
oConnection.Open();
oCommand.Connection = oConnection;
#region Backup Datenbank Personen
oCommand.CommandText = Cls_Query.GetAnwenderDaten("", true, "");
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
nCounter++;
}
drReader.Close();
nCounter = 0;
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
for (int i = 0; i < drReader.FieldCount; i++)
{
string value = drReader[i].ToString();
if (value.Contains(","))
{
value = value.Replace(",", ".");
}
sb.Append(value.Replace(Environment.NewLine, " ") + ";");
}
sb.Length--; // Remove the last comma
sb.AppendLine();
nCounter++;
}
drReader.Close();
swPersonen.Write(sb.ToString());
swPersonen.Close();
sb.Clear();
nCounter = 0;
#endregion
#region Backup Datenbank Güter
oCommand.CommandText = Cls_Query.GetGüterDatenBackup("");
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
nCounter++;
}
drReader.Close();
nCounter = 0;
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
for (int i = 0; i < drReader.FieldCount; i++)
{
string value = drReader[i].ToString();
if (value.Contains(","))
{
value = value.Replace(",", ".");
}
sb.Append(value.Replace(Environment.NewLine, " ") + ";");
}
sb.Length--; // Remove the last comma
sb.AppendLine();
nCounter++;
}
drReader.Close();
swGüter.Write(sb.ToString());
swGüter.Close();
sb.Clear();
nCounter = 0;
#endregion
#region Backup Datenbank Aufladung
oCommand.CommandText = Cls_Query.GetAufladungDaten("", "", "");
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
nCounter++;
}
drReader.Close();
nCounter = 0;
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
for (int i = 0; i < drReader.FieldCount; i++)
{
string value = drReader[i].ToString();
if (value.Contains(","))
{
value = value.Replace(",", ".");
}
sb.Append(value.Replace(Environment.NewLine, " ") + ";");
}
sb.Length--; // Remove the last comma
sb.AppendLine();
nCounter++;
}
drReader.Close();
swAufladung.Write(sb.ToString());
swAufladung.Close();
sb.Clear();
nCounter = 0;
#endregion
#region Backup Datenbank History
oCommand.CommandText = Cls_Query.GetHistoryDaten("", "", "");
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
nCounter++;
}
drReader.Close();
nCounter = 0;
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
for (int i = 0; i < drReader.FieldCount; i++)
{
string value = drReader[i].ToString();
if (value.Contains(","))
{
value = value.Replace(",", ".");
}
sb.Append(value.Replace(Environment.NewLine, " ") + ";");
}
sb.Length--; // Remove the last comma
sb.AppendLine();
nCounter++;
}
drReader.Close();
swHistory.Write(sb.ToString());
swHistory.Close();
sb.Clear();
nCounter = 0;
#endregion
#region Backup Datenbank Cocktails
oCommand.CommandText = Cls_Query.GetCocktailRezepte("", "");
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
nCounter++;
}
drReader.Close();
nCounter = 0;
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
for (int i = 0; i < drReader.FieldCount; i++)
{
string value = drReader[i].ToString();
if (value.Contains(","))
{
value = value.Replace(",", ".");
}
sb.Append(value.Replace(Environment.NewLine, " ") + ";");
}
sb.Length--; // Remove the last comma
sb.AppendLine();
nCounter++;
}
drReader.Close();
swCocktails.Write(sb.ToString());
swCocktails.Close();
sb.Clear();
nCounter = 0;
#endregion
oConnection.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Cls_Procedure.CmD_Backup_Click");
}
}
private void CreateButtons()
{
OracleConnection oConnection = new OracleConnection();
OracleCommand oCommand = new OracleCommand();
OracleDataReader drReader;
XmlDocument doc = new XmlDocument();
doc.Load("Settings.xml");
string sSammeluserSichtbar = "";
string sSammeluser = "";
bool bExecute = false;
int nLocationX = 0;
int nLocationY = 0;
int nOffset = 0;
int nSpalte = 0;
int nOffsetX = 10;
int nOffsetY = 10;
int a = 0;
int b = 0;
int nAnzahlButtonsNamen = 0;
int nAnzahlButtonsGüter = 0;
try
{
using (oConnection)
{
oConnection.ConnectionString = sDSN;
oConnection.Open();
#region Buttons für User erstellen
XmlNode nodeSammelUser = doc.SelectSingleNode("/Bauwagen/Software/Gemeinschaftsuser");
sSammeluser = nodeSammelUser.FirstChild.Value;
XmlNode nodeSammelUserSichtbar = doc.SelectSingleNode("/Bauwagen/Software/GemeinschaftsuserSichtbar");
sSammeluserSichtbar = nodeSammelUserSichtbar.FirstChild.Value;
oCommand.Connection = oConnection;
oCommand.CommandText = Cls_Query.GetMaxAnderID();
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
nAnzahlButtonsNamen = Convert.ToInt32(drReader.GetValue(0));
}
drReader.Close();
if (sSammeluserSichtbar == "0")
{
nAnzahlButtonsNamen = nAnzahlButtonsNamen - 1;
}
System.Windows.Forms.Button[] ButtonNamen = new System.Windows.Forms.Button[nAnzahlButtonsNamen];
oCommand.CommandText = Cls_Query.GetAnwenderDaten("", false, sLayer);
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
if (sSammeluserSichtbar == "0" && sSammeluser == drReader.GetValue(1).ToString().Trim())
{
bExecute = false;
}
else
{
bExecute = true;
}
if (bExecute == true)
{
ButtonNamen[a] = new Button();
ButtonNamen[a].Height = 70;
ButtonNamen[a].Width = 140;
nLocationY = (5 + ButtonNamen[a].Height) * (a - nOffset) + nOffsetY;
nLocationX = (12 + ButtonNamen[a].Width) * nSpalte + nOffsetX;
ButtonNamen[a].Location = new Point(nLocationX, nLocationY);
ButtonNamen[a].Name = "CmD_Anwender_" + a.ToString().PadLeft(2, '0');
ButtonNamen[a].Text = drReader.GetValue(1).ToString().Trim() + "\n" + String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(8))) + " €";
ButtonNamen[a].Tag = drReader.GetValue(6).ToString().Trim();
ButtonNamen[a].Font = new Font("Microsoft Sans Serif", 14.25f);
ButtonNamen[a].Click += new EventHandler(buttonNamen_Clicked);
FlW_Anwender.Controls.Add(ButtonNamen[a]);
if (Convert.ToInt32(drReader.GetValue(5)) == 1 | Convert.ToInt32(drReader.GetValue(6)) > 5)
{
ButtonNamen[a].Enabled = false;
}
if (nLocationY > 550)
{
nOffset = a + 1; nSpalte += 1;
}
a++;
}
}
nAnzahlAnwender = a;
#endregion
#region Buttons für Verbrauchsgüter erstellen
nSpalte = 6;
nOffset = 0;
oCommand.Connection = oConnection;
oCommand.CommandText = Cls_Query.GetMaxGüterID();
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
nAnzahlButtonsGüter = Convert.ToInt32(drReader.GetValue(0));
}
drReader.Close();
System.Windows.Forms.Button[] ButtonGüter = new System.Windows.Forms.Button[nAnzahlButtonsGüter];
oCommand.CommandText = Cls_Query.GetGüterDaten("");
drReader = oCommand.ExecuteReader();
while (drReader.Read())
{
ButtonGüter[b] = new Button();
ButtonGüter[b].Height = 70;
ButtonGüter[b].Width = 140;
nLocationY = (5 + ButtonGüter[b].Height) * (b - nOffset) + nOffsetY;
nLocationX = (12 + ButtonGüter[b].Width) * nSpalte + nOffsetX;
ButtonGüter[b].Location = new Point(nLocationX, nLocationY);
ButtonGüter[b].Name = "CmD_Gueter_" + b.ToString().PadLeft(2, '0');;
ButtonGüter[b].Text = drReader.GetValue(0).ToString().Trim() + "\n" + String.Format("{0:0.00}", Convert.ToDouble(drReader.GetValue(1))) + " €";
ButtonGüter[b].Tag = drReader.GetValue(0).ToString().Trim();
ButtonGüter[b].Font = new Font("Microsoft Sans Serif", 14.25f);
ButtonGüter[b].Click += new EventHandler(buttonGüter_Clicked);
FlW_Verbrauchsgüter.Controls.Add(ButtonGüter[b]);
ButtonGüter[b].Enabled = false;
if (nLocationY > 550)
{
nOffset = b + 1; nSpalte += 1;
}
b++;
}
nAnzahlGüter = b;
#endregion
oConnection.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "CreateButtons");
}
}
