public static HealthCardEPCRemainingChangeHistory[] GetByHealthCardID(int health_card_id) { string sql = @" SELECT health_card_epc_remaining_change_history_id,HealthCardEPCRemainingChangeHistory.health_card_epc_remaining_id,HealthCardEPCRemainingChangeHistory.staff_id,date, pre_num_services_remaining,post_num_services_remaining, health_card_id,HealthCardEPCRemaining.field_id,num_services_remaining,deleted_by,date_deleted, Field.descr, staff.staff_id as staff_staff_id, staff.person_id as staff_person_id, staff.login as staff_login, staff.pwd as staff_pwd, staff.staff_position_id as staff_staff_position_id, staff.field_id as staff_field_id, staff.costcentre_id as staff_costcentre_id, staff.is_contractor as staff_is_contractor, staff.tfn as staff_tfn, staff.provider_number as staff_provider_number, staff.is_fired as staff_is_fired, staff.is_commission as staff_is_commission, staff.commission_percent as staff_commission_percent, staff.is_stakeholder as staff_is_stakeholder,staff.is_master_admin as staff_is_master_admin,staff.is_admin as staff_is_admin,staff.is_principal as staff_is_principal,staff.is_provider as staff_is_provider, staff.is_external as staff_is_external, staff.staff_date_added as staff_staff_date_added, staff.start_date as staff_start_date, staff.end_date as staff_end_date, staff.comment as staff_comment, staff.num_days_to_display_on_booking_screen as staff_num_days_to_display_on_booking_screen, staff.show_header_on_booking_screen as staff_show_header_on_booking_screen, staff.bk_screen_field_id as staff_bk_screen_field_id, staff.bk_screen_show_key as staff_bk_screen_show_key, staff.enable_daily_reminder_sms as staff_enable_daily_reminder_sms, staff.enable_daily_reminder_email as staff_enable_daily_reminder_email, staff.hide_booking_notes as staff_hide_booking_notes, " + PersonDB.GetFields("person_", "person") + @", title.title_id as title_title_id, title.descr as title_descr FROM HealthCardEPCRemainingChangeHistory LEFT OUTER JOIN HealthCardEPCRemaining ON HealthCardEPCRemainingChangeHistory.health_card_epc_remaining_id = HealthCardEPCRemaining.health_card_epc_remaining_id LEFT OUTER JOIN Field ON HealthCardEPCRemaining.field_id = Field.field_id LEFT OUTER JOIN Staff staff ON staff.staff_id = HealthCardEPCRemainingChangeHistory.staff_id LEFT OUTER JOIN Person person ON person.person_id = staff.person_id LEFT OUTER JOIN Title title ON title.title_id = person.title_id WHERE HealthCardEPCRemaining.health_card_id = " + health_card_id; DataTable tbl = DBBase.ExecuteQuery(sql).Tables[0]; HealthCardEPCRemainingChangeHistory[] histories = new HealthCardEPCRemainingChangeHistory[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { histories[i] = Load(tbl.Rows[i]); histories[i].HealthCardEpcRemaining = HealthCardEPCRemainingDB.Load(tbl.Rows[i]); histories[i].HealthCardEpcRemaining.Field = IDandDescrDB.Load(tbl.Rows[i], "field_id", "descr"); histories[i].Staff = StaffDB.Load(tbl.Rows[i], "staff_"); histories[i].Staff.Person = PersonDB.Load(tbl.Rows[i], "person_"); histories[i].Staff.Person.Title = IDandDescrDB.Load(tbl.Rows[i], "title_title_id", "title_descr"); } return(histories); }
public static HealthCardEPCRemainingChangeHistory[] GetByHealthCardID(int health_card_id) { string sql = @" SELECT health_card_epc_remaining_change_history_id,HealthCardEPCRemainingChangeHistory.health_card_epc_remaining_id,HealthCardEPCRemainingChangeHistory.staff_id,date, pre_num_services_remaining,post_num_services_remaining, health_card_id,HealthCardEPCRemaining.field_id,num_services_remaining,deleted_by,date_deleted, Field.descr, staff.staff_id as staff_staff_id, staff.person_id as staff_person_id, staff.login as staff_login, staff.pwd as staff_pwd, staff.staff_position_id as staff_staff_position_id, staff.field_id as staff_field_id, staff.costcentre_id as staff_costcentre_id, staff.is_contractor as staff_is_contractor, staff.tfn as staff_tfn, staff.provider_number as staff_provider_number, staff.is_fired as staff_is_fired, staff.is_commission as staff_is_commission, staff.commission_percent as staff_commission_percent, staff.is_stakeholder as staff_is_stakeholder,staff.is_master_admin as staff_is_master_admin,staff.is_admin as staff_is_admin,staff.is_principal as staff_is_principal,staff.is_provider as staff_is_provider, staff.is_external as staff_is_external, staff.staff_date_added as staff_staff_date_added, staff.start_date as staff_start_date, staff.end_date as staff_end_date, staff.comment as staff_comment, staff.num_days_to_display_on_booking_screen as staff_num_days_to_display_on_booking_screen, staff.show_header_on_booking_screen as staff_show_header_on_booking_screen, staff.bk_screen_field_id as staff_bk_screen_field_id, staff.bk_screen_show_key as staff_bk_screen_show_key, staff.enable_daily_reminder_sms as staff_enable_daily_reminder_sms, staff.enable_daily_reminder_email as staff_enable_daily_reminder_email, staff.hide_booking_notes as staff_hide_booking_notes, " + PersonDB.GetFields("person_", "person") + @", title.title_id as title_title_id, title.descr as title_descr FROM HealthCardEPCRemainingChangeHistory LEFT OUTER JOIN HealthCardEPCRemaining ON HealthCardEPCRemainingChangeHistory.health_card_epc_remaining_id = HealthCardEPCRemaining.health_card_epc_remaining_id LEFT OUTER JOIN Field ON HealthCardEPCRemaining.field_id = Field.field_id LEFT OUTER JOIN Staff staff ON staff.staff_id = HealthCardEPCRemainingChangeHistory.staff_id LEFT OUTER JOIN Person person ON person.person_id = staff.person_id LEFT OUTER JOIN Title title ON title.title_id = person.title_id WHERE HealthCardEPCRemaining.health_card_id = " + health_card_id; DataTable tbl = DBBase.ExecuteQuery(sql).Tables[0]; HealthCardEPCRemainingChangeHistory[] histories = new HealthCardEPCRemainingChangeHistory[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { histories[i] = Load(tbl.Rows[i]); histories[i].HealthCardEpcRemaining = HealthCardEPCRemainingDB.Load(tbl.Rows[i]); histories[i].HealthCardEpcRemaining.Field = IDandDescrDB.Load(tbl.Rows[i], "field_id", "descr"); histories[i].Staff = StaffDB.Load(tbl.Rows[i], "staff_"); histories[i].Staff.Person = PersonDB.Load(tbl.Rows[i], "person_"); histories[i].Staff.Person.Title = IDandDescrDB.Load(tbl.Rows[i], "title_title_id", "title_descr"); } return histories; }