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;
}
}
}
