// Inherited Functions public override void Delete() { DatabaseQuery query = new DatabaseQuery(Database.Tables.LEAVE_DATES); DoDelete(query); StaffsManager.Remove(this); }
public override void Load() { DatabaseQuery query = new DatabaseQuery(Database.Tables.PRESCRIPTIONS); query.Add(Database.Tables.Prescriptions.PrescriberId); query.Add(Database.Tables.Prescriptions.PatientId); query.Add(Database.Tables.Prescriptions.Name); query.Add(Database.Tables.Prescriptions.Remark); query.Add(Database.Tables.Prescriptions.StartDate); query.Add(Database.Tables.Prescriptions.EndDate); MySqlDataReader reader = DoLoad(query); if (Loaded) { Prescriber = StaffsManager.GetMedicalStaff(reader.GetInt32(0)); Patient = PatientsManager.GetPatient(reader.GetInt32(1)); Name = reader.GetString(2); Remark = reader.GetString(3); StartDate = reader.GetDateTime(4); EndDate = reader.GetDateTime(5); PatientsManager.Add(this); } reader.Close(); // TODO: Implement fetching prescription's medications. }
public override void Load() { DatabaseQuery query = new DatabaseQuery(Database.Tables.WORKING_DAYS); query.Add(Database.Tables.WorkingDays.StaffId); query.Add(Database.Tables.WorkingDays.Sunday); query.Add(Database.Tables.WorkingDays.Monday); query.Add(Database.Tables.WorkingDays.Tuesday); query.Add(Database.Tables.WorkingDays.Wednesday); query.Add(Database.Tables.WorkingDays.Thursday); query.Add(Database.Tables.WorkingDays.Friday); query.Add(Database.Tables.WorkingDays.Saturday); MySqlDataReader reader = DoLoad(query); if (Loaded) { Owner = StaffsManager.GetMedicalStaff(reader.GetInt32(0)); Sunday = reader.GetByte(1) > 0 ? true : false; Monday = reader.GetByte(2) > 0 ? true : false; Tuesday = reader.GetByte(3) > 0 ? true : false; Wednesday = reader.GetByte(4) > 0 ? true : false; Thursday = reader.GetByte(5) > 0 ? true : false; Friday = reader.GetByte(6) > 0 ? true : false; Saturday = reader.GetByte(7) > 0 ? true : false; StaffsManager.Add(this); } reader.Close(); }
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); }
public override void Save() { DatabaseQuery query = new DatabaseQuery(Database.Tables.WORKING_DAYS); query.Add(Database.Tables.WorkingDays.StaffId, Owner); query.Add(Database.Tables.WorkingDays.Sunday, Sunday ? 1 : 0); query.Add(Database.Tables.WorkingDays.Monday, Monday ? 1 : 0); query.Add(Database.Tables.WorkingDays.Tuesday, Tuesday ? 1 : 0); query.Add(Database.Tables.WorkingDays.Wednesday, Wednesday ? 1 : 0); query.Add(Database.Tables.WorkingDays.Thursday, Thursday ? 1 : 0); query.Add(Database.Tables.WorkingDays.Friday, Friday ? 1 : 0); query.Add(Database.Tables.WorkingDays.Saturday, Saturday ? 1 : 0); DoSave(query); StaffsManager.Add(this); }
public override void Load() { DatabaseQuery query = new DatabaseQuery(Database.Tables.LEAVE_DATES); query.Add(Database.Tables.LeaveDates.Date); query.Add(Database.Tables.LeaveDates.StaffId); MySqlDataReader reader = DoLoad(query); if (Loaded) { Date = reader.GetDateTime(0); Owner = StaffsManager.GetMedicalStaff(reader.GetInt32(1)); StaffsManager.Add(this); } reader.Close(); }
public override void Load() { base.Load(); DatabaseQuery query = new DatabaseQuery(Database.Tables.MEDICAL_STAFFS); query.Comparator = Identifier; query.Add(Database.Tables.MedicalStaffs.LicenseNo); MySqlDataReader reader = DoLoad(query); if (Loaded) { // GetWorkingDaysByStaff should return only one result, because each staff has maximum of one WorkingDays entry. LicenseNo = reader.GetString(0); WorkingDays = StaffsManager.GetWorkingDaysByStaff(this)[0]; LeaveDates = StaffsManager.GetLeaveDatesByStaff(this); } reader.Close(); }
public override void Load() { DatabaseQuery query = new DatabaseQuery(Database.Tables.APPOINTMENTS); query.Add(Database.Tables.Appointments.MedicalStaffId); query.Add(Database.Tables.Appointments.PatientId); query.Add(Database.Tables.Appointments.Cancelled); query.Add(Database.Tables.Appointments.DateAppointed); MySqlDataReader reader = DoLoad(query); if (Loaded) { MedicalStaff = StaffsManager.GetMedicalStaff(reader.GetInt32(0)); Patient = PatientsManager.GetPatient(reader.GetInt32(1)); Cancelled = reader.GetByte(2) > 0 ? true : false; DateAppointed = reader.GetDateTime(3); PatientsManager.Add(this); } reader.Close(); }