public EditPatientForm()
{
InitializeComponent();
DeklaracjeTableAdapter deklaracjeTableAdapter = new DeklaracjeTableAdapter();
WizytyTableAdapter wizytyTableAdapter = new WizytyTableAdapter();
dataGridView2.DataSource = deklaracjeTableAdapter.GetDataByJoin();
dataGridView3.DataSource = wizytyTableAdapter.GetDataByJoin();
dataGridView2.Columns["ID"].Visible = false;
dataGridView2.Columns["IdPacjenta"].Visible = false;
dataGridView2.Columns["IdLekarza"].Visible = false;
dataGridView3.Columns["ID"].Visible = false;
dataGridView3.Columns["IdLekarza"].Visible = false;
dataGridView3.Columns["IdPacjenta"].Visible = false;
dataGridView3.Columns["KodICD"].Visible = false;
comboBox1.DataSource = this.pacjenciTableAdapter.GetDataByCombo();
comboBox1.DisplayMember = "Pacjent";
comboBox1.ValueMember = "ID";
comboBox2.DataSource = this.lekarzeTableAdapter.GetDataByCombo();
comboBox2.DisplayMember = "Lekarz";
comboBox2.ValueMember = "ID";
comboBox3.DataSource = this.pacjenciTableAdapter.GetDataByCombo();
comboBox3.DisplayMember = "Pacjent";
comboBox3.ValueMember = "ID";
comboBox4.DataSource = this.lekarzeTableAdapter.GetDataByCombo();
comboBox4.DisplayMember = "Lekarz";
comboBox4.ValueMember = "ID";
comboBox5.DataSource = this.iCDTableAdapter.GetData();
comboBox5.DisplayMember = "Nazwa";
comboBox5.ValueMember = "ID";
}
private void insertWButton_Click(object sender, EventArgs e)
{
WizytyTableAdapter wizytyTableAdapter = new WizytyTableAdapter();
try
{
wizytyTableAdapter.InsertQuery(dateTimePicker3.Value.Date, Convert.ToInt32(comboBox3.SelectedValue), Convert.ToInt32(comboBox4.SelectedValue), Convert.ToInt32(comboBox5.SelectedValue), textBox10.Text);
comboBox3.SelectedIndex = -1;
comboBox4.SelectedIndex = -1;
comboBox5.SelectedIndex = -1;
dateTimePicker3.Text = DateTime.Now.ToShortDateString();
MessageBox.Show("Wizyta została pomyślne dodana do bazy danych.");
}
catch (Exception ex)
{
MessageBox.Show("Błąd podczas zapisywania wizyty do bazy danych.");
}
dataGridView3.DataSource = wizytyTableAdapter.GetDataByJoin();
dataGridView3.Refresh();
}