private void FrmCita_Load(object sender, EventArgs e)
{
if (idEdit != null)
{
dsAnalisisResidenciaTableAdapters.ReservationTTableAdapter rta =
new dsAnalisisResidenciaTableAdapters.ReservationTTableAdapter();
dsAnalisisResidencia.ReservationTDataTable dtr = rta.GetDataIdOpR((int)idEdit);
dsAnalisisResidencia.ReservationTRow row = (dsAnalisisResidencia.ReservationTRow)dtr.Rows[0];
txtHinicioC.Text = Convert.ToString(row.ResStartTime);
txtHfinC.Text = Convert.ToString(row.ResFinishTime);
txtFecha.Text = row.ResDate.ToShortDateString();
idCurrent = Convert.ToInt32(rta.idPatient_fromReservation(idEdit));
dsAnalisisResidenciaTableAdapters.PatientTableAdapter pta =
new dsAnalisisResidenciaTableAdapters.PatientTableAdapter();
dsAnalisisResidencia.PatientDataTable dtp = pta.GetDataIdOp((int)idCurrent);
dsAnalisisResidencia.PatientRow row1 = (dsAnalisisResidencia.PatientRow)dtp.Rows[0];
txtNombreC.Text = row1.patientName;
txtApellidoC.Text = row1.patientLastName;
txtEmailC.Text = row1.patientEmail;
}
else
{
txtFecha.Text = FrmAgendaDoctor.vCompartidaFecha;
txtHinicioC.Text = FrmAgendaDoctor.vCompartidaHinicio;
txtHfinC.Text = FrmAgendaDoctor.vCompartidaHfin;
txtFecha.ReadOnly = true;
txtHinicioC.ReadOnly = true;
txtHfinC.ReadOnly = true;
}
}
public void Update()
{
lblName.Text = FrmDoctores.variableCompartida;
//Cargar Reservaciones
dsAnalisisResidenciaTableAdapters.ReservationTTableAdapter rta =
new dsAnalisisResidenciaTableAdapters.ReservationTTableAdapter();
varIdD = FrmDoctores.varId;
dsAnalisisResidencia.ReservationTDataTable rdt = rta.Getdoc_ReservationT(varIdD);
dataGViewReservation.DataSource = rdt;
}
public void ObtenerCorreos()
{
try
{
dsAnalisisResidenciaTableAdapters.ReservationTTableAdapter rta =
new dsAnalisisResidenciaTableAdapters.ReservationTTableAdapter();
dsAnalisisResidencia.ReservationTDataTable tableR =
rta.idPatient_Email(DateTime.Today.Day, DateTime.Today.Month, DateTime.Today.Year);
for (int i = 0; i < tableR.Rows.Count; i++)
{
Users.Add(tableR.Rows[i]["idPatient"].ToString());
Hora.Add(tableR.Rows[i]["ResStartTime"].ToString());
}
dsAnalisisResidenciaTableAdapters.PatientTableAdapter pta =
new dsAnalisisResidenciaTableAdapters.PatientTableAdapter();
dsAnalisisResidencia.PatientDataTable tableP;
for (int i = 0; i < Users.Count; i++)
{
tableP = pta.GetEmailP(Convert.ToInt32(Users[i]));
for (int j = 0; j < tableP.Rows.Count; j++)
{
Emails.Add(tableP.Rows[j]["patientEmail"].ToString());
Nombre.Add(tableP.Rows[j]["patientName"].ToString());
Apellido.Add(tableP.Rows[j]["patientLastName"].ToString());
}
}
Notify();
}
catch (Exception ex)
{ }
}
