public override object GetStagingValue(Row stagingRow, FixupCaches caches, DataStoreConfiguration config) { Ct7Entity resType = (Ct7Entity)stagingRow[StagingTypeColumn]; Entity entityType = EntityUtils.FromCt7Entity(resType); object id = config.Consolidation.Get(entityType).None ? stagingRow[FederatedStagingIdColumn] : stagingRow[ConsolidatedStagingIdColumn]; if (id == null || id == DBNull.Value) { return(DBNull.Value); } long idVal = (long)id; var name = caches.NameCache.Get(entityType, idVal, config); if (name != null) { if (PublicColumn.Contains("unique")) { return(name.UniqueName); } if (string.IsNullOrEmpty(name.Name)) { return(DBNull.Value); } return(name.Name); } return(DBNull.Value); }
public override object GetStagingValue(Row stagingRow, FixupCaches caches, DataStoreConfiguration config) { Ct7Entity resType = (Ct7Entity)stagingRow[PublicStagingTypeColumn]; Entity entityType = EntityUtils.FromCt7Entity(resType); return(config.Consolidation.Get(entityType).None ? stagingRow[FederatedStagingColumn] : stagingRow[ConsolidatedStagingColumn]); }
public static string GetIdFldName(Ct7Entity et) { string name; switch (et) { case Ct7Entity.Course: name = "course_id"; break; case Ct7Entity.Module: name = "module_id"; break; case Ct7Entity.Group: name = "group_id"; break; case Ct7Entity.Staff: name = "staff_id"; break; case Ct7Entity.Room: name = "room_id"; break; case Ct7Entity.Student: name = "student_id"; break; case Ct7Entity.Equipment: name = "equip_id"; break; case Ct7Entity.Team: name = "team_id"; break; case Ct7Entity.Terminology: name = "terminology_id"; break; case Ct7Entity.Faculty: name = "faculty_id"; break; case Ct7Entity.Department: name = "dept_id"; break; case Ct7Entity.Fixture: name = "fixture_id"; break; case Ct7Entity.Layout: name = "room_layout_id"; break; case Ct7Entity.Site: name = "site_id"; break; case Ct7Entity.Span: name = "span_id"; break; case Ct7Entity.Role: name = "role_id"; break; case Ct7Entity.Origin: name = "origin_id"; break; case Ct7Entity.Event: name = "event_id"; break; case Ct7Entity.EventCat: name = "event_cat_id"; break; case Ct7Entity.User: name = "user_id"; break; case Ct7Entity.WeekScheme: name = "week_scheme_id"; break; case Ct7Entity.Charge: name = "charge_id"; break; case Ct7Entity.Exam: name = "exam_id"; break; case Ct7Entity.Session: name = "session_id"; break; case Ct7Entity.Slot: name = "slot_id"; break; case Ct7Entity.Supervisor: name = "supervisor_id"; break; case Ct7Entity.ExamSet: name = "exam_set_id"; break; case Ct7Entity.Constraint: name = "constraint_id"; break; case Ct7Entity.Template: name = "template_id"; break; case Ct7Entity.TemplateStaffEntry: name = "staff_entry_id"; break; case Ct7Entity.TemplateRoomEntry: name = "room_entry_id"; break; case Ct7Entity.ConstraintDef: name = "constraint_def_id"; break; case Ct7Entity.ConstraintGenre: name = "constraint_genre_id"; break; case Ct7Entity.GroupSplit: name = "split_id"; break; case Ct7Entity.EventStore: name = "store_id"; break; case Ct7Entity.DefaultAccessRights: name = "resource_type"; break; case Ct7Entity.MultiSelect: name = "multi_select_id"; break; case Ct7Entity.StaffCat: name = "staff_cat_id"; break; case Ct7Entity.Mark: name = "mark_id"; break; default: throw new ArgumentOutOfRangeException(nameof(et), "Could not recognise ct7 entity"); } return(name); }
// taken from Ct7 codebase (CTDataDLL...ctEntityType.cpp) public static string GetTableName(Ct7Entity et) { string tableName; switch (et) { case Ct7Entity.Course: tableName = "CT_COURSE"; break; case Ct7Entity.Module: tableName = "CT_MODULE"; break; case Ct7Entity.Group: tableName = "CT_GROUP"; break; case Ct7Entity.Staff: tableName = "CT_STAFF"; break; case Ct7Entity.Room: tableName = "CT_ROOM"; break; case Ct7Entity.Student: tableName = "CT_STUDENT"; break; case Ct7Entity.Equipment: tableName = "CT_EQUIP"; break; case Ct7Entity.Team: tableName = "CT_TEAM"; break; case Ct7Entity.Terminology: tableName = "CT_TERMINOLOGY"; break; case Ct7Entity.Faculty: tableName = "CT_FACULTY"; break; case Ct7Entity.Department: tableName = "CT_DEPT"; break; case Ct7Entity.Fixture: tableName = "CT_FIXTURE"; break; case Ct7Entity.Layout: tableName = "CT_LAYOUT"; break; case Ct7Entity.Site: tableName = "CT_SITE"; break; case Ct7Entity.Span: tableName = "CT_SPAN"; break; case Ct7Entity.Role: tableName = "CT_ROLE"; break; case Ct7Entity.Origin: tableName = "CT_ORIGIN"; break; case Ct7Entity.Event: tableName = "CT_EVENT"; break; case Ct7Entity.EventCat: tableName = "CT_EVENT_CAT"; break; case Ct7Entity.User: tableName = "CT_USER"; break; case Ct7Entity.WeekScheme: tableName = "CT_WEEK_SCHEME"; break; case Ct7Entity.Charge: tableName = "CT_CHARGE"; break; case Ct7Entity.Exam: tableName = "CT_ES_EXAM"; break; case Ct7Entity.Session: tableName = "CT_ES_SESSION"; break; case Ct7Entity.Slot: tableName = "CT_ES_SLOT"; break; case Ct7Entity.Supervisor: tableName = "CT_SUPERVISOR"; break; case Ct7Entity.Constraint: tableName = "CT_CS_CONSTRAINT"; break; case Ct7Entity.Template: tableName = "CT_CS_TEMPLATE"; break; case Ct7Entity.TemplateStaffEntry: tableName = "CT_CS_STAFF_ENTRY"; break; case Ct7Entity.TemplateRoomEntry: tableName = "CT_CS_ROOM_ENTRY"; break; case Ct7Entity.ConstraintDef: tableName = "CT_CS_CONSTRAINT_DEF"; break; case Ct7Entity.ConstraintGenre: tableName = "CT_CS_CONSTRAINT_GENRE"; break; case Ct7Entity.GroupSplit: tableName = "CT_CS_GROUPSPLIT"; break; case Ct7Entity.EventStore: tableName = "CT_EVENT_STORE"; break; case Ct7Entity.DefaultAccessRights: tableName = "CT_ACCESS_DEF_TT"; break; case Ct7Entity.MultiSelect: tableName = "CT_MULTI_SELECT"; break; case Ct7Entity.StaffCat: tableName = "CT_STAFF_CAT"; break; case Ct7Entity.Mark: tableName = "CT_AT_MARK"; break; case Ct7Entity.AuxMark: tableName = "CT_AT_AUX_MARK"; break; default: throw new ArgumentOutOfRangeException(nameof(et), "Could not recognise ct7 entity"); } return(tableName); }
public static Entity FromCt7Entity(Ct7Entity e) { switch (e) { case Ct7Entity.Course: return(Entity.Course); case Ct7Entity.Module: return(Entity.Module); case Ct7Entity.Group: return(Entity.Group); case Ct7Entity.Staff: return(Entity.Staff); case Ct7Entity.Room: return(Entity.Room); case Ct7Entity.Student: return(Entity.Student); case Ct7Entity.Equipment: return(Entity.Equip); case Ct7Entity.Team: return(Entity.Team); case Ct7Entity.Faculty: return(Entity.Faculty); case Ct7Entity.Department: return(Entity.Dept); case Ct7Entity.Fixture: return(Entity.Fixture); case Ct7Entity.Layout: return(Entity.Layout); case Ct7Entity.Site: return(Entity.Site); case Ct7Entity.Span: return(Entity.Span); case Ct7Entity.Origin: return(Entity.Origin); case Ct7Entity.Event: return(Entity.Event); case Ct7Entity.EventCat: return(Entity.EventCat); case Ct7Entity.User: return(Entity.User); case Ct7Entity.WeekScheme: return(Entity.WeekScheme); case Ct7Entity.Exam: return(Entity.EsExam); case Ct7Entity.Session: return(Entity.EsSession); case Ct7Entity.Slot: return(Entity.EsSlot); case Ct7Entity.Supervisor: return(Entity.Supervisor); case Ct7Entity.StaffCat: return(Entity.StaffCat); case Ct7Entity.Mark: return(Entity.AtMark); default: case Ct7Entity.AuxMark: case Ct7Entity.MultiSelect: case Ct7Entity.DefaultAccessRights: case Ct7Entity.Template: case Ct7Entity.Constraint: case Ct7Entity.Terminology: case Ct7Entity.TemplateStaffEntry: case Ct7Entity.TemplateRoomEntry: case Ct7Entity.Charge: case Ct7Entity.Role: case Ct7Entity.ExamSet: case Ct7Entity.ConstraintDef: case Ct7Entity.GroupSplit: case Ct7Entity.ConstraintGenre: case Ct7Entity.EventStore: case Ct7Entity.Undefined: return(Entity.Unknown); } }