public override void Save()
{
DatabaseQuery query = new DatabaseQuery(Database.Tables.LEAVE_DATES);
query.Add(Database.Tables.LeaveDates.Date, QueryElement.DateOf(Date));
query.Add(Database.Tables.LeaveDates.StaffId, Owner);
DoSave(query);
StaffsManager.Add(this);
}
// Getting leave dates within a set range through the staff ID.
public static List <MedicalStaff> GetMedicalStaffLeavesFrom(DateTime start, DateTime end, bool not)
{
DatabaseQuery nestedQuery = new DatabaseQuery(Database.Tables.LEAVE_DATES);
if (start.Date.Equals(end.Date))
{
nestedQuery.Comparator = new QueryComparator
{
Source = new QueryElement(Database.Tables.LeaveDates.Date),
Operand = new QueryElement(null, QueryElement.DateOf(start))
};
}
else
{
nestedQuery.Comparator = new QueryComparator
{
Source = new QueryComparator()
{
Source = new QueryElement(Database.Tables.LeaveDates.Date),
Operand = new QueryElement(null, QueryElement.DateOf(start)),
Equal = !not,
More = !not,
Less = not
},
Operand = new QueryComparator()
{
Source = new QueryElement(Database.Tables.LeaveDates.Date),
Operand = new QueryElement(null, QueryElement.DateOf(end)),
Equal = !not,
Less = !not,
More = not
},
And = !not,
Or = not
};
}
nestedQuery.Add(Database.Tables.LeaveDates.StaffId);
return(ManagerHelper.FilterType <MedicalStaff>
(
StaffManager.Merge
(
Database.Tables.STAFFS,
ManagerHelper.GetInComparator
(
Database.Tables.Generic.ID,
nestedQuery
)
)
));
}
public override void Save()
{
DatabaseQuery query = new DatabaseQuery(Database.Tables.PRESCRIPTIONS);
query.Add(Database.Tables.Prescriptions.PrescriberId, Prescriber);
query.Add(Database.Tables.Prescriptions.PatientId, Patient);
query.Add(Database.Tables.Prescriptions.Name, Name);
query.Add(Database.Tables.Prescriptions.Remark, Remark);
query.Add(Database.Tables.Prescriptions.StartDate, QueryElement.DateOf(StartDate));
query.Add(Database.Tables.Prescriptions.EndDate, QueryElement.DateOf(EndDate));
DoSave(query);
PatientsManager.Add(this);
}
public static List <Prescription> GetPrescriptionsByEndDate(DateTime date)
{
return(PrescriptionManager.Merge(Database.Tables.PRESCRIPTIONS, ManagerHelper.GetEqualComparator(Database.Tables.Prescriptions.EndDate, QueryElement.DateOf(date))));
}