public void ClearFilter() { foreach (Control c in this.Controls) { if (c is TextBox) { c.Text = ""; c.Enabled = false; } else if (c is ComboBox) { ((ComboBox)c).SelectedIndex = 0; c.Enabled = false; } else if (c is DateTimePicker) { ((DateTimePicker)c).Value = DateTime.Today.Date; c.Enabled = false; } } ctx.Dispose(); ctx = new TubDataBaseEntities(); ctx.Patients.Load(); bind.DataSource = ctx.Patients.Local.ToBindingList(); }
private void DeletePatientBut_Click(object sender, EventArgs e) { ctx.Dispose(); ctx = new TubDataBaseEntities(); ctx.Patients.Load(); DialogResult d = MessageBox.Show("Ви впевнені, що бажаєте видалити цього пацієнта?", "Видалення", MessageBoxButtons.YesNo); if (d == DialogResult.Yes) { var p = (from c in ctx.Patients where (c.p_id == patient.p_id) select c).FirstOrDefault(); int a = (from c in ctx.BlTest___Patient where (c.bltp_patid == patient.p_id) select c).Count() + (from c in ctx.UrTest__Patient where (c.utp_patid == patient.p_id) select c).Count() + (from c in ctx.HepTest___Patient where (c.htp_patid == patient.p_id) select c).Count() + (from c in ctx.SputumTest___Patient where (c.sptp_patid == patient.p_id) select c).Count() + (from c in ctx.Consult___Patient where (c.cp_patid == patient.p_id) select c).Count(); if (a == 0) { ctx.Patients.Remove(p); ctx.SaveChanges(); MessageBox.Show("Пацієнта видалено"); this.DialogResult = DialogResult.OK; } else { MessageBox.Show("До пацієнта прив'язані аналізи, видаляти заборонено"); } } }
protected override void OnClosing(CancelEventArgs e) { base.OnClosing(e); ctx.Dispose(); }