protected void Page_Load(object sender, EventArgs e)
{
dbcontext.Doctors.Load();
SQL.Patient me = (from x in dbcontext.Patients
where x.Email.Equals(User.Identity.Name)
select x).First();
List <SQL.Message> msgList = (from x in dbcontext.Messages
where x.TO.Equals(User.Identity.Name)
select x).ToList();
GridView1.DataSource = msgList;
GridView1.DataBind();
if (!IsPostBack)
{
var result = from x in dbcontext.Doctors.Local
select new
{
Name = x.FirstName + ", " + x.LastName,
x.Email
};
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "Email";
DropDownList1.DataSource = result;
DropDownList1.DataBind();
}
}
protected void aptGridView_SelectedIndexChanged(object sender, EventArgs e)
{
//if (!IsPostBack)
//{
SQL.HealthclinicEntities dbcon = new SQL.HealthclinicEntities();
dbcon.Appointments.Load();
SQL.Patient patient = (from x in dbcon.Patients
where x.Email.Equals(User.Identity.Name)
select x).First();
int something = Convert.ToInt32(aptGridView.SelectedDataKey[0]);
SQL.Appointment apt = (from x in dbcon.Appointments
where x.AppointmentID == something
select x).First();
SQL.Doctor doc = (from x in dbcon.Doctors
where x.DoctorID == apt.DoctorID
select x).First();
var testShite = (from a in dbcon.Appointments
select new
{
aptID = a.AppointmentID,
aptPatient = a.PatientID,
aptDoctor = a.DoctorID,
aptDate = a.AppointmentDate,
aptTime = a.AppointmentTime,
aptLoc = a.AppointmentLocation,
aptDept = a.DepartmentID,
aptHospital = a.HospitalID,
aptReason = a.Reason
}).ToList();
string[] potentialKeys = { "AppointmentID" };
aptGridView.DataSource = testShite;
aptGridView.DataKeyNames = potentialKeys;
lblPName.Text = "Patient name: " + patient.LastName + "," + patient.FirstName;
lblDName.Text = "Doctor name: " + doc.LastName + "," + doc.FirstName;
lblLoc.Text = "Appointment location: " + apt.AppointmentLocation;
lblDate.Text = "Appointment date: " + apt.AppointmentDate + "@" + apt.AppointmentTime;
lblReason.Text = "Reason: " + apt.Reason;
//}
}
protected void Button2_Click(object sender, EventArgs e)
{
IEnumerable <SQL.Appointment> testAppointmentList =
(from testDate in dbcontext.Appointments.Local
where testDate.AppointmentDate.Equals(startDateTextBox.Text)
orderby testDate.AppointmentTime
select testDate).AsEnumerable();
foreach (SQL.Appointment testDate in testAppointmentList)
{
if (appointmentsDropDownList.SelectedValue.Equals(testDate.AppointmentTime))
{
appointmentsDropDownList.SelectedValue.Remove(appointmentsDropDownList.SelectedIndex);
}
}
/*
* var userID = User.Identity.GetUserId();
*
* dbcontext.Patients.Load();
* //SQL.Patient myPatient = new SQL.Patient();
*
* SQL.Patient myPatient = (from y in dbcontext.Patients.Local
* where y.Email.Equals(userID)
* select y).First();
* SQL.Patient np = myPatient;
*/
dbcontext.Appointments.Load();
SQL.Patient patient = (from x in dbcontext.Patients
where x.Email.Equals(User.Identity.Name)
select x).First();
SQL.Appointment myAppointment = new SQL.Appointment();
myAppointment.AppointmentDate = Convert.ToDateTime(startDateTextBox.Text);
myAppointment.AppointmentTime = TimeSpan.Parse(appointmentsDropDownList.SelectedValue);
myAppointment.PatientID = patient.PatientID;
myAppointment.DoctorID = Convert.ToInt32(doctorDropDownList.SelectedValue);
myAppointment.HospitalID = Convert.ToInt32(locationDropDownList.SelectedValue);
myAppointment.AppointmentLocation = Convert.ToInt32(locationDropDownList.SelectedValue);
myAppointment.DepartmentID = Convert.ToInt32(departmentDropDownList.SelectedValue);
myAppointment.Reason = reasonTextBox.Text;
dbcontext.Appointments.Add(myAppointment);
dbcontext.SaveChanges();
}
protected void Page_Load(object sender, EventArgs e)
{
SQL.HealthclinicEntities dbcon = new SQL.HealthclinicEntities();
dbcon.Appointments.Load();
try
{
SQL.Patient patient = (from x in dbcon.Patients
where x.Email.Equals(User.Identity.Name)
select x).First();
List <SQL.Appointment> apts = (from x in dbcon.Appointments
where x.PatientID == patient.PatientID
select x).ToList();
aptGridView.DataSource = apts;
//aptGridView.DataKeyNames = "AppointmentID";
aptGridView.DataBind();
}
catch (InvalidOperationException)
{
throw;
}
}
