private void View_Button_Click(object sender, EventArgs e) { try { using (var context = new Cabinet_MedicalEntities()) { string cell = PacientsData.SelectedRows[0].Cells[0].Value.ToString(); var query2 = (from pat in context.Patients where pat.Nume.Equals(cell) select pat).First(); if (PacientsData.SelectedRows.Count == 0) { throw new Exception("Selectati un pacient!"); } else { this.Hide(); View_Form view = new View_Form(query2, this, Abouts); view.Show(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Accept_Button_Click(object sender, EventArgs e) { try { if (PatientsData.SelectedRows.Count == 0) { throw new Exception("Selectati o programare!"); } if (PatientsData.SelectedCells[2].Value.ToString().Equals("Consultat")) { throw new Exception("Pacientul a fost deja consultat!"); } if (PatientsData.SelectedCells[2].Value.ToString().Equals("Refuzat")) { throw new Exception("Pacientul a fost deja refuzat!"); } Patient P; using (var context = new Cabinet_MedicalEntities()) { string name = PatientsData.SelectedCells[0].Value.ToString(); var query = (from app in context.Appointments join pat in context.Patients on app.ID_Pacient equals pat.ID where pat.Nume.Equals(name) select new { app.Accepted, pat.ID }).First(); PatientsData.SelectedCells[2].Value = "Consultat"; // var query2 = (from app in context.Appointments // where app.ID_Pacient == query.ID // select app).First(); var query3 = (from pat in context.Patients where pat.Nume.Equals(name) select pat).First(); context.SetData(name, 2); context.SaveChanges(); P = query3; } Form p = new View_Form(P, this, Abouts); p.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }