private void GetFromDB() { DBConnection dBConnection = DBConnection.Instance(); if (dBConnection.IsConnect()) { string query = string.Format("SELECT rechnung.UNTERNEHMENS_DATEN_ID, rechnung.KLIENT_ID FROM rechnung WHERE rechnung.ID = {0}", this.ID); try { var cmd = new MySqlCommand(query, dBConnection.Connection); var reader = cmd.ExecuteReader(); while (reader.Read()) { this.Unternehmen = new Unternehmen(reader.GetInt32(0)); this.Käufer = new Käufer(reader.GetInt32(1)); } dBConnection.IsConnect(); query = string.Format("SELECT rechnung_produkt.RECHNUNG_ID, rechnung_produkt.PRODUKT_ID FROM rechnung_produkt WHERE rechnung_produkt.RECHNUNG_ID = {0};", this.ID); cmd = new MySqlCommand(query, dBConnection.Connection); reader = cmd.ExecuteReader(); while (reader.Read()) { this.Rechnung_Produkte.Add(new Rechnung_Produkt(reader.GetInt32(0), reader.GetInt32(1))); } } catch (Exception e) { throw e; } } }
private void GetFromDB() { DBConnection dBConnection = DBConnection.Instance(); if (dBConnection.IsConnect()) { string query = string.Format("SELECT produkt.Preis, produkt.Name, produkt.UST FROM produkt WHERE produkt.ID = {0};", this.ID); try { var cmd = new MySqlCommand(query, dBConnection.Connection); var reader = cmd.ExecuteReader(); while (reader.Read()) { this.Preis = reader.GetInt32(0); this.Name = reader.GetString(1); this.UST = reader.GetDecimal(2); } } catch (Exception e) { throw e; } } }
private void GetFromDB() { DBConnection dBConnection = DBConnection.Instance(); if (dBConnection.IsConnect()) { string query = string.Format("SELECT standort.STADT, standort.PLZ, standort.STRASSE, standort.HAUSNUMMER FROM standort WHERE standort.ID = {0};", this.ID); try { var cmd = new MySqlCommand(query, dBConnection.Connection); var reader = cmd.ExecuteReader(); while (reader.Read()) { this.Stadt = reader.GetString(0); this.PLZ = reader.GetInt32(1); this.Straße = reader.GetString(2); this.Hausnummer = reader.GetString(3); } } catch (Exception e) { throw e; } } }
private void GetFromDB() { DBConnection dBConnection = DBConnection.Instance(); if (dBConnection.IsConnect()) { string query = string.Format("SELECT unternehmens_daten.NAME, unternehmens_daten.EMAIL, unternehmens_daten.TELEFON, unternehmens_daten.FAX, unternehmens_daten.UID, unternehmens_daten.FIRMENBUCHNUMMER, unternehmens_daten.STANDORT_ID, unternehmens_daten.BANKVERBINDUNG_ID FROM unternehmens_daten WHERE unternehmens_daten.ID = {0}; ", this.ID); try { var cmd = new MySqlCommand(query, dBConnection.Connection); var reader = cmd.ExecuteReader(); while (reader.Read()) { this.Name = reader.GetString(0); this.EMail = reader.GetString(1); this.Telefon = reader.GetString(2); this.FAX = reader.GetString(3); this.UID = reader.GetString(4); this.Firmenbuchnummer = reader.GetString(5); this.Standort = new Standort(reader.GetInt32(6)); this.Bankverbindung = new Bankverbindung(reader.GetInt32(7)); } } catch (Exception e) { throw e; } } }
private void GetFromDB() { DBConnection dBConnection = DBConnection.Instance(); if (dBConnection.IsConnect()) { string query = string.Format("SELECT bankverbindung.BANKNAME, bankverbindung.BLZ, bankverbindung.KONTONUMMER, bankverbindung.IBAN, bankverbindung.BIC FROM bankverbindung WHERE bankverbindung.ID = {0};", this.ID); try { var cmd = new MySqlCommand(query, dBConnection.Connection); var reader = cmd.ExecuteReader(); while (reader.Read()) { this.Bankname = reader.GetString(0); this.BLZ = reader.GetString(1); this.Kontonummer = reader.GetString(2); this.IBAN = reader.GetString(3); this.BIC = reader.GetString(4); } } catch (Exception e) { throw e; } } }
private void GetFromDB() { DBConnection dBConnection = DBConnection.Instance(); if (dBConnection.IsConnect()) { string query = string.Format("SELECT klient.NAME, klient.STANDORT_ID, klient.BANKVERBINDUNG_ID FROM klient WHERE klient.ID = {0};", this.ID); try { var cmd = new MySqlCommand(query, dBConnection.Connection); var reader = cmd.ExecuteReader(); while (reader.Read()) { this.Name = reader.GetString(0); this.Standort = new Standort(reader.GetInt32(1)); this.Bankverbindung = new Bankverbindung(reader.GetInt32(2)); } } catch (Exception e) { throw e; } } }
private void FillListBox() { config.DBConnection dBConnection = config.DBConnection.Instance(); if (dBConnection.IsConnect()) { string query = "SELECT rechnung.ID FROM rechnung;"; try { var cmd = new MySqlCommand(query, dBConnection.Connection); var reader = cmd.ExecuteReader(); while (reader.Read()) { this.listBox1.Items.Add(reader.GetInt32(0)); } dBConnection.Close(); } catch (Exception e) { } } }
private void GetFromDB() { DBConnection dBConnection = DBConnection.Instance(); if (dBConnection.IsConnect()) { string query = string.Format("SELECT rechnung_produkt.MENGE, rechnung_produkt.RABATT FROM rechnung_produkt WHERE rechnung_produkt.RECHNUNG_ID = {0} AND rechnung_produkt.PRODUKT_ID = {1};", this.RechnungID, this.Produkt.ID); try { var cmd = new MySqlCommand(query, dBConnection.Connection); var reader = cmd.ExecuteReader(); while (reader.Read()) { this.Menge = reader.GetInt32(0); this.Rabatt = reader.GetDecimal(1); } } catch (Exception e) { throw e; } } }