private void button3_Click(object sender, EventArgs e)
{
Appointement appointement = context.AppointementSet.Where(i => i.Id == idAppointment).FirstOrDefault();
appointement.Diagnosis = rtb_diagnostic.Text;
appointement.Medication = rtb_medication.Text;
appointement.Obs = rtb_obs.Text;
context.SaveChanges();
MessageBox.Show("Appointment Registado", "Sucesso", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
private void listView1_DoubleClick(object sender, EventArgs e)
{
int index = int.Parse(listView1.SelectedItems[0].SubItems[0].Text);
Appointement appointement = context.AppointementSet.Where(i => i.Id == index).FirstOrDefault();
ProjectoESGPS.Properties.Settings.Default.Appointement = index;
ProjectoESGPS.Properties.Settings.Default.SNS = appointement.Patient.SNS;
ProjectoESGPS.Properties.Settings.Default.Save();
AppointmentInfo infoConsulta = new AppointmentInfo();
infoConsulta.Show();
this.Hide();
}
public AppointmentInfo()
{
InitializeComponent();
String user = ProjectoESGPS.Properties.Settings.Default.User;
User utilizador = context.UserSet.Where(i => i.Username == user).FirstOrDefault();
lb_username.TextAlign = ContentAlignment.MiddleRight;
lb_username.AutoSize = false;
lb_username.Text = utilizador.Fname + " " + utilizador.Lname;
bt_logout.Anchor = (AnchorStyles.Top | AnchorStyles.Right);
lb_username.Anchor = (AnchorStyles.Top | AnchorStyles.Right);
if (utilizador.Tipo == "N")
{
lb_diagnostic.Hide();
rtb_diagnostic.Hide();
rtb_medication.ReadOnly = true;
rtb_obs.ReadOnly = true;
}
Patient paciente = context.PatientSet.Where(i => i.SNS == snsPaciente).FirstOrDefault();
lb_sns.Text = paciente.SNS.ToString();
lb_name.Text = paciente.Fname + " " + paciente.Lname;
Appointement appointement = context.AppointementSet.Where(i => i.Id == idAppointment).FirstOrDefault();
lb_appointment.Text = appointement.Id.ToString();
if (appointement.Medication != null)
{
rtb_medication.Text = appointement.Medication;
}
if (appointement.Diagnosis != null)
{
rtb_diagnostic.Text = appointement.Medication;
}
if (appointement.Obs != null)
{
rtb_obs.Text = appointement.Obs;
}
}
private void button3_Click(object sender, EventArgs e)
{
if (dateTimePicker1.Value >= DateTime.Today)
{
Appointement consulta = new Appointement();
consulta.Patient = context.PatientSet.Where(i => i.SNS == snsPaciente).FirstOrDefault();
consulta.Doctor = comboBox1.Text;
consulta.Date = dateTimePicker1.Value.Date;
context.AppointementSet.Add(consulta);
context.SaveChanges();
MessageBox.Show("Consulta criada com sucesso", "Sucesso", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
MessageBox.Show("Data invalida", "Aviso", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
private void button3_Click(object sender, EventArgs e)
{
Appointement consulta = new Appointement();
consulta.Patient = context.PatientSet.Where(i => i.SNS == "100000000").FirstOrDefault();
consulta.Doctor = "doctor";
consulta.Date = new DateTime(2016, 5, 1);
context.AppointementSet.Add(consulta);
Appointement consulta1 = new Appointement();
consulta1.Patient = context.PatientSet.Where(i => i.SNS == "100000001").FirstOrDefault();
consulta1.Doctor = "doctor";
consulta1.Date = new DateTime(2016, 5, 1);
context.AppointementSet.Add(consulta1);
Appointement consulta2 = new Appointement();
consulta2.Patient = context.PatientSet.Where(i => i.SNS == "100000002").FirstOrDefault();
consulta2.Doctor = "doctor";
consulta2.Date = new DateTime(2016, 5, 1);
context.AppointementSet.Add(consulta2);
Appointement consulta3 = new Appointement();
consulta3.Patient = context.PatientSet.Where(i => i.SNS == "100000003").FirstOrDefault();
consulta3.Doctor = "doctor";
consulta3.Date = new DateTime(2016, 5, 1);
context.AppointementSet.Add(consulta3);
Appointement consulta4 = new Appointement();
consulta4.Patient = context.PatientSet.Where(i => i.SNS == "100000000").FirstOrDefault();
consulta4.Doctor = "doctor";
consulta4.Date = new DateTime(2016, 5, 2);
context.AppointementSet.Add(consulta4);
Appointement consulta5 = new Appointement();
consulta5.Patient = context.PatientSet.Where(i => i.SNS == "100000001").FirstOrDefault();
consulta5.Doctor = "doctor";
consulta5.Date = new DateTime(2016, 5, 2);
context.AppointementSet.Add(consulta5);
Appointement consulta6 = new Appointement();
consulta6.Patient = context.PatientSet.Where(i => i.SNS == "100000002").FirstOrDefault();
consulta6.Doctor = "doctor";
consulta6.Date = new DateTime(2016, 5, 2);
context.AppointementSet.Add(consulta6);
Appointement consulta7 = new Appointement();
consulta7.Patient = context.PatientSet.Where(i => i.SNS == "100000003").FirstOrDefault();
consulta7.Doctor = "doctor";
consulta7.Date = new DateTime(2016, 5, 2);
context.AppointementSet.Add(consulta7);
Appointement consulta8 = new Appointement();
consulta8.Patient = context.PatientSet.Where(i => i.SNS == "100000000").FirstOrDefault();
consulta8.Doctor = "doctor";
consulta8.Date = new DateTime(2016, 5, 3);
context.AppointementSet.Add(consulta8);
Appointement consulta9 = new Appointement();
consulta9.Patient = context.PatientSet.Where(i => i.SNS == "100000001").FirstOrDefault();
consulta9.Doctor = "doctor";
consulta9.Date = new DateTime(2016, 5, 3);
context.AppointementSet.Add(consulta9);
Appointement consulta10 = new Appointement();
consulta10.Patient = context.PatientSet.Where(i => i.SNS == "100000002").FirstOrDefault();
consulta10.Doctor = "doctor";
consulta10.Date = new DateTime(2016, 5, 3);
context.AppointementSet.Add(consulta10);
Appointement consulta11 = new Appointement();
consulta11.Patient = context.PatientSet.Where(i => i.SNS == "100000003").FirstOrDefault();
consulta11.Doctor = "doctor";
consulta11.Date = new DateTime(2016, 5, 3);
context.AppointementSet.Add(consulta11);
context.SaveChanges();
MessageBox.Show("Appointments criados com sucesso", "Sucesso", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
