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 dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
DeklaracjeTableAdapter deklaracjeTableAdapter = new DeklaracjeTableAdapter();
dataGridView1.DataSource = deklaracjeTableAdapter.GetDataByReport(dateTimePicker1.Value.Date, dateTimePicker2.Value.Date);
dataGridView1.Refresh();
}
public RaportForm()
{
InitializeComponent();
DeklaracjeTableAdapter deklaracjeTableAdapter = new DeklaracjeTableAdapter();
dataGridView1.DataSource = deklaracjeTableAdapter.GetDataByReport(dateTimePicker1.Value.Date, dateTimePicker2.Value.Date);
dataGridView1.Columns["ID"].Visible = false;
dataGridView1.Columns["IdPacjenta"].Visible = false;
dataGridView1.Columns["IdLekarza"].Visible = false;
dataGridView1.Columns["Pozytywna"].Visible = false;
}
private void button1_Click(object sender, EventArgs e)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
if (saveFileDialog.FileName != "")
{
CreateZipFile czf = new CreateZipFile(Path.GetDirectoryName(saveFileDialog.FileName), saveFileDialog.FileName);
DeklaracjeTableAdapter deklaracjeTableAdapter = new DeklaracjeTableAdapter();
DataTable dataTable = new DataTable("Deklaracja");
dataTable = deklaracjeTableAdapter.GetDataByReport(dateTimePicker1.Value.Date, dateTimePicker2.Value.Date);
czf.CreateZipFileFromDataTable(dataTable);
}
}
}
private void insertDButton_Click(object sender, EventArgs e)
{
DeklaracjeTableAdapter deklaracjeTableAdapter = new DeklaracjeTableAdapter();
try
{
deklaracjeTableAdapter.InsertQuery(Convert.ToInt32(comboBox1.SelectedValue), Convert.ToInt32(comboBox2.SelectedValue), dateTimePicker2.Value.Date, checkBox1.Checked);
comboBox1.SelectedIndex = -1;
comboBox2.SelectedIndex = -1;
dateTimePicker2.Text = DateTime.Now.ToShortDateString();
checkBox1.Checked = false;
MessageBox.Show("Deklaracja została pomyślne dodana do bazy danych.");
}
catch (Exception ex)
{
MessageBox.Show("Błąd podczas zapisywania deklaracji do bazy danych.");
}
dataGridView2.DataSource = deklaracjeTableAdapter.GetDataByJoin();
dataGridView2.Refresh();
}
