protected void btnRegister_Click(object sender, EventArgs e)
{
Doctor doctor = _dc.Doctors.FirstOrDefault(dc => dc.FirstName + " " + dc.LastName == ddlDoctors.SelectedValue.Trim().ToString());
Speciality speciality = _dc.Specialities.FirstOrDefault(s => s.SpecialityName == ddlSpecialities.SelectedValue.Trim().ToString());
DoctorsAndSpeciality CheckDoc = _dc.DoctorsAndSpecialities.FirstOrDefault(ds => ds.DoctorsID == doctor.ID && ds.SpecialityID == speciality.ID);
if (CheckDoc == null)
{
DoctorsAndSpeciality docAndSpec = new DoctorsAndSpeciality();
docAndSpec.DoctorsID = doctor.ID;
docAndSpec.SpecialityID = speciality.ID;
_dc.DoctorsAndSpecialities.InsertOnSubmit(docAndSpec);
_dc.SubmitChanges();
Session["Message"] = "Success !";
Response.Redirect("SetDoctorSpeciality.aspx");
}
else
{
Session["Message"] = "The Doctor already has that speciality added";
Response.Redirect("SetDoctorSpeciality.aspx");
}
}
partial void DeleteSpeciality(Speciality instance);
partial void UpdateSpeciality(Speciality instance);
partial void InsertSpeciality(Speciality instance);
protected void Page_Load(object sender, EventArgs e)
{
if (Session["LoggedUserID"] != null)
{
User user = _dc.Users.FirstOrDefault(u => u.ID == Convert.ToInt32(Session["LoggedUserID"].ToString()));
if (Session["Message"] != null)
{
lblMessage.Text = Session["Message"].ToString();
Session["Message"] = null;
}
if (user.Type != 1)
{
//Normal User
btnCreateAppointment.Visible = true;
List <Appointment> userAppointmentsList = _dc.Appointments.Where(a => a.UserID == Convert.ToInt32(Session["LoggedUserID"].ToString()) && a.IsDeleted == false).ToList();
int count = 1;
foreach (Appointment userAppointment in userAppointmentsList)
{
Button btnDelete = new Button()
{
ID = userAppointment.ID.ToString() + "D", Text = "Delete", CssClass = "btn btn-danger"
};
btnDelete.Click += buttonDelete_Click;
Button btnEdit = new Button()
{
ID = userAppointment.ID.ToString() + "E", Text = "Edit", CssClass = "btn btn-warning"
};
btnEdit.Click += buttonEdit_Click;
TableRow row = new TableRow();
TableCell countNumber = new TableCell();
TableCell doctorCell = new TableCell();
TableCell specialityCell = new TableCell();
TableCell appointmentDateCell = new TableCell();
TableCell actionsCell = new TableCell();
//appointment date/time
DateTime appointmentDate = userAppointment.AppointmentDate;
DoctorsAndSpeciality docAndSpecs = _dc.DoctorsAndSpecialities.FirstOrDefault(d => d.ID == userAppointment.DoctorAndSpecialityID);
// Doctor name
Doctor doctorsName = _dc.Doctors.FirstOrDefault(d => d.ID == docAndSpecs.DoctorsID);
//Speciality
Speciality specialityName = _dc.Specialities.FirstOrDefault(d => d.ID == docAndSpecs.SpecialityID);
countNumber.Text = count.ToString();
doctorCell.Text = doctorsName.FirstName.ToString() + " " + doctorsName.LastName.ToString();
specialityCell.Text = specialityName.SpecialityName.ToString();
appointmentDateCell.Text = appointmentDate.ToString();
actionsCell.Controls.Add(btnEdit);
DateTime now = DateTime.Now;
DateTime tomorrow = now.AddDays(1);
if (appointmentDate > tomorrow)
{
actionsCell.Controls.Add(btnDelete);
}
row.Cells.Add(countNumber);
row.Cells.Add(doctorCell);
row.Cells.Add(specialityCell);
row.Cells.Add(appointmentDateCell);
row.Cells.Add(actionsCell);
AppointmentsTable.Rows.Add(row);
count++;
}
}
else
{
//Admin
List <Appointment> userAppointmentsList = _dc.Appointments.Where(a => a.IsDeleted == false).ToList();
int count = 1;
foreach (Appointment userAppointment in userAppointmentsList)
{
Button btnDelete = new Button()
{
ID = userAppointment.ID.ToString() + "D", Text = "Delete", CssClass = "btn btn-danger"
};
btnDelete.Click += buttonDelete_Click;
Button btnEdit = new Button()
{
ID = userAppointment.ID.ToString() + "E", Text = "Edit", CssClass = "btn btn-warning"
};
btnEdit.Click += buttonEdit_Click;
TableRow row = new TableRow();
TableCell countNumber = new TableCell();
TableCell doctorCell = new TableCell();
TableCell specialityCell = new TableCell();
TableCell appointmentDateCell = new TableCell();
TableCell actionsCell = new TableCell();
//appointment date/time
DateTime appointmentDate = userAppointment.AppointmentDate;
DoctorsAndSpeciality docAndSpecs = _dc.DoctorsAndSpecialities.FirstOrDefault(d => d.ID == userAppointment.DoctorAndSpecialityID);
// Doctor name
Doctor doctorsName = _dc.Doctors.FirstOrDefault(d => d.ID == docAndSpecs.DoctorsID);
//Speciality
Speciality specialityName = _dc.Specialities.FirstOrDefault(d => d.ID == docAndSpecs.SpecialityID);
countNumber.Text = count.ToString();
doctorCell.Text = doctorsName.FirstName.ToString() + " " + doctorsName.LastName.ToString();
specialityCell.Text = specialityName.SpecialityName.ToString();
appointmentDateCell.Text = appointmentDate.ToString();
actionsCell.Controls.Add(btnEdit);
DateTime now = DateTime.Now;
if (appointmentDate > now)
{
actionsCell.Controls.Add(btnDelete);
}
row.Cells.Add(countNumber);
row.Cells.Add(doctorCell);
row.Cells.Add(specialityCell);
row.Cells.Add(appointmentDateCell);
row.Cells.Add(actionsCell);
AppointmentsTable.Rows.Add(row);
count++;
}
}
}
else
{
Response.Redirect("Index.aspx");
}
}