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(); }