private void UpdateData(int id)
{
//int temp_b;
try
{
MySqlCommand cmd = new MySqlCommand("SELECT * FROM koszty_dodatkowe WHERE id_uzytkownik='" + id + "';", Form1.connection);
MySqlDataReader rdr = null;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
if (rdr.GetInt16(5) == 0)
{
topay += rdr.GetDecimal(2);
}
id_cost = rdr.GetInt32(0);
IDComboBox.Items.Add(id_cost);
//id_user = rdr.GetInt16(1);
//money = rdr.GetFloat(2);
//MoneyBox.Value = (decimal)money;
//date_temp = rdr.GetString(3);
//MessageBox.Show(date_temp);
//description = rdr.GetString(4);
//DescriptionBox.Text = description;
//temp_b = rdr.GetInt16(5);
//if (temp_b == 0) NoRButton.Checked = true;
//else YesRButton.Checked = true;
while (rdr.Read())
{
IDComboBox.Items.Add(rdr.GetString(0));
if (rdr.GetInt16(5) == 0)
{
topay += rdr.GetDecimal(2);
}
}
rdr.Close();
ToPayLabel.Text = "Do zapłacenia przez użytkownika: " + topay.ToString();
IDComboBox.SelectedIndex = IDComboBox.FindStringExact(id_cost.ToString());
}
else
{
rdr.Close();
MessageBox.Show("Brak kosztów dodatkowych użytkownika", "Informacja");
//Close();
}
}
catch (MySqlException ex)
{
MessageBox.Show(ex.ToString(), "ERROR");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "ERROR");
}
}
public AddPaymentForm(int id, string n, decimal m)
{
InitializeComponent();
id_user = id;
name = n;
old_money = m;
UserLogin.Text += name;
DateCheckBox.Checked = true;
HourBox.Hide();
MinuteBox.Hide();
TimeLabel.Hide();
IDLabel.Hide();
IDComboBox.Hide();
hLabel.Hide();
mLabel.Hide();
}
public AddECostForm(int id, string n, string formname)
{
InitializeComponent();
id_user = id;
login = n;
this.Text = formname;
if (formname == "Dodawanie kosztu dodatkowego")
{
NoRButton.Checked = true;
paid = false;
IDComboBox.Hide();
IDLabel.Hide();
PayInfo(id);
DateCheckBox.Checked = true;
choice = 1;
}
else if (formname == "Wyświetlanie kosztów dodatkowych")
{
UpdateData(id);
DescriptionBox.Enabled = false;
MoneyBox.Enabled = false;
DateBox.Enabled = false;
YesRButton.Enabled = false;
NoRButton.Enabled = false;
ApplyButton.Hide();
OKButton.Hide();
CancelButton.Text = "OK";
DateCheckBox.Hide();
DateBox.Format = DateTimePickerFormat.Custom;
DateBox.CustomFormat = "dd.MM.yyyy HH:mm";
choice = 2;
}
else if (formname == "Edycja kosztów dodatkowych")
{
UpdateData(id);
ApplyButton.Text = "Zastosuj zmiany";
now = false;
DateCheckBox.Checked = false;
choice = 3;
}
}
