protected void RefreshGridView()
{
if (dbcon != null)
{
dbcon.Dispose();
}
dbcon = new TGDBEntities();
dbcon.AppointmentTables.Where(item => item.PatientId.Equals(userID)).Load();
UpcomingAppointmentsGridView.DataSource = dbcon.AppointmentTables.Local;
UpcomingAppointmentsGridView.DataBind();
}
protected void RefreshGridView()
{
if (dbcon != null)
{
dbcon.Dispose();
}
TGDBEntities dbconD = new TGDBEntities();
var docUser = (from x in dbconD.DoctorTables
where x.DoctorUserName == User.Identity.Name
select x).First();
userID = docUser.DoctorId;
TGDBEntities dbconA = new TGDBEntities();
dbconA.AppointmentTables.Where(item => item.DoctorId.Equals(userID)).Load();
UpcomingAppointmentsGridView.DataSource = dbconA.AppointmentTables.Local;
UpcomingAppointmentsGridView.DataBind();
}
