public WPF_9_RelationalDB()
{
InitializeComponent();
HospitalManagementDBEntities db = new HospitalManagementDBEntities();
var result = from a in db.Appointments
select new
{
a.DoctorID,
DoctorName = a.Doctor.Name,
a.Doctor.Specialization,
a.PatientID,
Patient = a.Patient.Name,
a.Patient.ContactNo,
a.AppointmentDate
};
var resultOuterDoctor = from d in db.Doctors
from a in d.Appointments.DefaultIfEmpty()
select new
{
d.Name,
ApptID = a.Id.ToString(),
a.AppointmentDate,
Patient = a.Patient.Name
};
this.gridAppointments.ItemsSource = result.ToList();
}
private void BtnDeleteDoctor_Click(object sender, RoutedEventArgs e)
{
MessageBoxResult msgBoxResult = MessageBox.Show("Are you sure you want to Delete?",
"Delete Doctor",
MessageBoxButton.YesNo,
MessageBoxImage.Warning,
MessageBoxResult.No
);
if (msgBoxResult == MessageBoxResult.Yes)
{
HospitalManagementDBEntities db = new HospitalManagementDBEntities();
var r = from d in db.Doctors
where d.Id == this.updatingDoctorID
select d;
Doctor obj = r.SingleOrDefault();
if (obj != null)
{
db.Doctors.Remove(obj);
db.SaveChanges();
}
}
}
private void BtnAdd_Click(object sender, RoutedEventArgs e)
{
HospitalManagementDBEntities db = new HospitalManagementDBEntities();
Doctor doctorObject = new Doctor()
{
Name = txtName.Text,
Qualification = txtQualification.Text,
Specialization = txtSpecialization.Text
};
db.Doctors.Add(doctorObject);
db.SaveChanges();
}
private void BtnUpdateDoctor_Click(object sender, RoutedEventArgs e)
{
HospitalManagementDBEntities db = new HospitalManagementDBEntities();
var r = from d in db.Doctors
where d.Id == this.updatingDoctorID
select d;
Doctor obj = r.SingleOrDefault();
if (obj != null)
{
obj.Name = this.txtName2.Text;
obj.Specialization = this.txtSpecialization2.Text;
obj.Qualification = this.txtQualification2.Text;
obj.Age = int.Parse(this.txtAge.Text);
db.SaveChanges();
}
}
public WPF_8_EF_HMS()
{
InitializeComponent();
HospitalManagementDBEntities db = new HospitalManagementDBEntities();
var docs = from d in db.Doctors
select new
{
DoctorName = d.Name,
Speciality = d.Specialization
};
foreach (var item in docs)
{
Console.WriteLine(item.DoctorName);
Console.WriteLine(item.Speciality);
}
this.gridDoctors.ItemsSource = docs.ToList();
}
private void BtnLoadDoctors_Click(object sender, RoutedEventArgs e)
{
HospitalManagementDBEntities db = new HospitalManagementDBEntities();
this.gridDoctors.ItemsSource = db.Doctors.ToList();
}