/*
* gets the latest treatment plan of the patientID
*
*/
public TreatmentPlan getTreatmentPlan(int patientID)
{
using (var db = new DentalPracticeContext())
{
var result = from treatmentPlan in db.treatmentPlans
where treatmentPlan.patientID == patientID
orderby treatmentPlan.bookedDate descending
select treatmentPlan;
if (result.Any())
{
return(result.First());
}
return(null);
}
}
/*
* last booked treatmentdat of the patient
*
*
*/
public DateTime?getLastTreatmentBookedDate(int patientID)
{
using (var db = new DentalPracticeContext())
{
var result = from treatmentPlan in db.treatmentPlans
where treatmentPlan.patientID == patientID
orderby treatmentPlan.bookedDate descending
select treatmentPlan.bookedDate;
if (result.Count() == 0)
{
return(null);
}
return(result.First());
}
}
