private void btnKonto_Click(object sender, EventArgs e)
{
//Now Year
string Jahrr = DateTime.Now.Year.ToString();
//Check if A DNr exist in db Table Stundenliste_konto
string DNrForKonto = this.comboDNr.SelectedItem.ToString();
//DateTime Now
DateTime dateTime = DateTime.Now;
DateTime nowTime = Convert.ToDateTime(dateTime);
try //stundenliste_konto
{
string Query = "select * from um_db.stundenliste_konto where DNr='" + DNrForKonto + "' and Jahr='" + Jahrr + "';";
MySqlConnection conDataBase = new MySqlConnection(constring);
MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase);
MySqlDataReader myReader;
//Open Connection
conDataBase.Open();
myReader = cmdDataBase.ExecuteReader();
if (myReader.HasRows)
{
while (myReader.Read())
{
//Show Konto form
Stundenliste_Konto std_konto = new Stundenliste_Konto();
std_konto.txtDNr.Text = this.comboDNr.SelectedItem.ToString();
std_konto.txtVorname.Text = this.txtVorname.Text;
std_konto.txtNachname.Text = this.txtNachname.Text;
std_konto.txtAktualisiert.Text = myReader.GetString("Datum_Aktualisiert");
std_konto.txtKontostand.Text = myReader.GetString("Kontostand");
std_konto.ShowDialog();
}
}
//Close Connection
conDataBase.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Stundenliste_Konto_Report_Load(object sender, EventArgs e)
{
Stundenliste_Konto std_konto = (Stundenliste_Konto)Application.OpenForms["Stundenliste_Konto"];
//Convert Kontostand textbox to integer
int intDNr;
intDNr = Convert.ToInt32(std_konto.txtDNr.Text);
intDNr = int.Parse(std_konto.txtDNr.Text);
string txtJahr = std_konto.comboJahr.SelectedItem.ToString();
// TODO: This line of code loads data into the 'um_db_DataSet.stundenliste_konto' table. You can move, or remove it, as needed.
this.stundenliste_kontoTableAdapter.Fill(this.um_db_DataSet.stundenliste_konto, intDNr, txtJahr);
// TODO: This line of code loads data into the 'um_db_DataSet.einstellungen_firma' table. You can move, or remove it, as needed.
this.einstellungen_firmaTableAdapter.Fill(this.um_db_DataSet.einstellungen_firma);
this.reportViewer1.RefreshReport();
}
