internal V_SF(SeamlessViewsContext Context, SF SF) : base(Context) { _SFKEY = SF.SFKEY; _SURNAME = SF.SURNAME; _FIRST_NAME = SF.FIRST_NAME; _SECOND_NAME = SF.SECOND_NAME; _PREF_NAME = SF.PREF_NAME; _TITLE = SF.TITLE; _FACULTY01 = SF.FACULTY01; _FACULTY02 = SF.FACULTY02; _FACULTY03 = SF.FACULTY03; _FACULTY04 = SF.FACULTY04; _SUBJECT01 = SF.SUBJECT01; _SUBJECT02 = SF.SUBJECT02; _SUBJECT03 = SF.SUBJECT03; _SUBJECT04 = SF.SUBJECT04; _SUBJECT05 = SF.SUBJECT05; _SUBJECT06 = SF.SUBJECT06; _SUBJECT07 = SF.SUBJECT07; _SUBJECT08 = SF.SUBJECT08; _SUBJECT09 = SF.SUBJECT09; _SUBJECT10 = SF.SUBJECT10; _FTE = SF.FTE; _MAJORA = SF.MAJORA; _MAJORB = SF.MAJORB; _MAJORC = SF.MAJORC; _PAYROLL_CLASS = SF.PAYROLL_CLASS; _PAYROLL_REC_NO = SF.PAYROLL_REC_NO; }
internal V_KGC(SeamlessViewsContext Context, KGC KGC) : base(Context) { _KGCKEY = KGC.KGCKEY; _ROOM = KGC.ROOM; _TEACHER = KGC.TEACHER; }
internal V_SG(SeamlessViewsContext Context, SG SG) : base(Context) { _SGKEY = SG.SGKEY; _TITLE = SG.TITLE; _ADULT_RESPONSIBLE = SG.ADULT_RESPONSIBLE; }
internal V_AIM(SeamlessViewsContext Context, ST ST) : base(Context) { _student_code = ST.STKEY; _first_name = ST.FIRST_NAME; _middle_name = ST.SECOND_NAME; _surname = ST.SURNAME; _gender = ST.GENDER == "M" ? "MALE" : ST.GENDER == "F" ? "FEMAL" : ""; _date_of_birth = ST.BIRTHDATE.HasValue ? ST.BIRTHDATE.Value.ToString("dd/MM/yyyy") : null; _LBOTE = ST.LBOTE == "N" ? 0 : 1; _ATSI = ST.KOORIE == "K" || ST.KOORIE == "T" || ST.KOORIE == "B" || ST.KOORIE == "U" ? 1 : 0; _disability_status = ST.DISABILITY == "Y" ? 1 : 0; _EMA = ST.ED_ALLOW == "Y" ? 1 : 0; _ESL = ST.ENG_SPEAK == "N" ? 1 : 0; _home_group = ST.HOME_GROUP; _year_level = ST.SCHOOL_YEAR == "00" ? "P" : ST.SCHOOL_YEAR; }
internal V_SCI(SeamlessViewsContext Context, SCI SCI) : base(Context) { _SCIKEY = SCI.SCIKEY; _CAMPUS_NAME = SCI.CAMPUS_NAME; _CAMPUS_TYPE = SCI.CAMPUS_TYPE; _SCHOOL_NAME = SCI.SCHOOL_NAME; _SCHOOL_TYPE = SCI.SCHOOL_TYPE; }
internal V_SCL(SeamlessViewsContext Context, SCL SCL) : base(Context) { _SCLKEY = SCL.SCLKEY; _SUBJECT = SCL.SUBJECT; _CLASS = SCL.CLASS; _TEACHER01 = SCL.TEACHER01; _ROOM01 = SCL.ROOM01; }
internal V_SXAB(SeamlessViewsContext Context, SXAB SXAB) : base(Context) { _SXAB_ID = SXAB.SXAB_ID; _ABSENCE_DATE = SXAB.ABSENCE_DATE; _STKEY = SXAB.STKEY; _AM_ACT_TYPE = SXAB.AM_ACT_TYPE; _PM_ACT_TYPE = SXAB.PM_ACT_TYPE; }
internal V_SM(SeamlessViewsContext Context, SM SM) : base(Context) { _ROOM = SM.ROOM; _TITLE = SM.TITLE; _DESCRIPTION = SM.DESCRIPTION; _SEATING = SM.SEATING; _FACULTY = SM.FACULTY; }
internal V_STMA(SeamlessViewsContext Context, STMA STMA) : base(Context) { _SKEY = STMA.SKEY; _MKEY = STMA.MKEY; _CLASS = STMA.CLASS; _FULLNAME = STMA.FULLNAME; _TEACHER_NAME = STMA.TEACHER_NAME; _TTPERIOD = STMA.TTPERIOD; }
internal V_TXAS(SeamlessViewsContext Context, TXAS TXAS) : base(Context) { _CLASS = TXAS.CLASS; _DAY_NO = TXAS.DAY_NO; _LOCATION = TXAS.LOCATION; _PERIOD_NO = TXAS.PERIOD_NO; _SESSION_DATE = TXAS.SESSION_DATE; _SUBJECT = TXAS.SUBJECT; _TEACHER = TXAS.TEACHER; }
internal V_FAMILY_CONTACT(SeamlessViewsContext Context, DF DF) : base(Context) { var UM = DF.HOMEKEY_UM; _DFKEY = DF.DFKEY; _MOBILE = UM?.MOBILE; _TELEPHONE = UM?.TELEPHONE; _E_MAIL_A = DF.E_MAIL_A; _NAME_A = DF.NAME_A; _SURNAME_A = DF.SURNAME_A; _NAME_B = DF.NAME_B; _SURNAME_B = DF.SURNAME_B; }
internal V_SU(SeamlessViewsContext Context, SU SU) : base(Context) { var KCY = SU.SUBJECT_ACADEMIC_YEAR_KCY; _SUKEY = SU.SUKEY; _SHORTNAME = SU.SHORTNAME; _FULLNAME = SU.FULLNAME; _OVERVIEW = SU.OVERVIEW; _FACULTY = SU.FACULTY; _SEMESTER = SU.SEMESTER; _SUBJECT_ACADEMIC_YEAR = SU.SUBJECT_ACADEMIC_YEAR; _DESCRIPTION = KCY.DESCRIPTION; }
internal V_ST_ATTEND(SeamlessViewsContext Context, ST ST) : base(Context) { _SID = ST.REGISTRATION; _STKEY = ST.STKEY; _SURNAME = ST.SURNAME; _FIRST_NAME = ST.FIRST_NAME; _PREF_NAME = ST.PREF_NAME; _HOME_GROUP = ST.HOME_GROUP; _hgrpdesc = ST.HOME_GROUP_KGC?.DESCRIPTION ?? ST.HOME_GROUP; _SCHOOL_YEAR = ST.SCHOOL_YEAR; _yrlvldesc = ST.SCHOOL_YEAR_KCY?.SHORT_DESC ?? ST.SCHOOL_YEAR; _HOUSE = ST.HOUSE; _FAMILY = ST.FAMILY; _STATUS = ST.STATUS; _NOTES = ST.NOTES; _OVERSEAS = ST.OVERSEAS; _ACCESS_ALERT = ST.ACCESS_ALERT; _ATTENDANCE_MEMO = ST.ATTENDANCE_MEMO; _TAG = ST.TAG; _FAMB = ST.FAMB; _CAMPUS = ST.CAMPUS; _MEDICAL_ALERT = ST.MEDICAL_ALERT; }
internal V_KGL(SeamlessViewsContext Context, KGL KGL) : base(Context) { _KGLKEY = KGL.KGLKEY; _DESCRIPTION = KGL.DESCRIPTION; }
internal V_ST_ATTENDDataSet(SeamlessViewsContext Context) : base(Context) { }
internal V_ST(SeamlessViewsContext Context, ST ST) : base(Context) { var KCY = ST.SCHOOL_YEAR_KCY; var DF = ST.FAMILY_DF; var UM = DF.MAILKEY_UM; _STKEY = ST.STKEY; // STUDENT _STUDENT = $"{ST.SURNAME} {ST.PREF_NAME} {ST.SCHOOL_YEAR} {ST.HOME_GROUP}"; // PARENT1 if (ST.CONTACT_A == "A") { _PARENT1 = $"{DF.TITLE_A} {DF.NAME_A.Substring(0, 1)} {DF.SURNAME_A}"; } else if (ST.CONTACT_A == "B") { _PARENT1 = $"{DF.TITLE_B} {DF.NAME_B.Substring(0, 1)} {DF.SURNAME_B}"; } else if (ST.CONTACT_A == "N") { _PARENT1 = null; } else if (DF.SURNAME_A == DF.SURNAME_B) { _PARENT1 = $"{DF.TITLE_A} {DF.NAME_A.Substring(0, 1)} & {DF.TITLE_B} {DF.NAME_B.Substring(0, 1)} {DF.SURNAME_A}"; } else if (DF.SURNAME_A != null && DF.SURNAME_B != null) { _PARENT1 = $"{DF.TITLE_A} {DF.NAME_A.Substring(0, 1)} {DF.SURNAME_A} & {DF.TITLE_B} {DF.NAME_B.Substring(0, 1)} {DF.SURNAME_B}"; } else if (DF.SURNAME_A == null && DF.SURNAME_B != null) { _PARENT1 = $"{DF.TITLE_B} {DF.NAME_B.Substring(0, 1)} {DF.SURNAME_B}"; } else if (DF.SURNAME_B == null && DF.SURNAME_A != null) { _PARENT1 = $"{DF.TITLE_A} {DF.NAME_A.Substring(0, 1)} {DF.SURNAME_A}"; } else { _PARENT1 = "STUDENT HAS NO LISTED PARENTS"; } _LIVING_ARR = ST.LIVING_ARR; // PARENT2 if (ST.CONTACT_A == "A") { _PARENT2 = $"{DF.TITLE_A} {DF.SURNAME_A}"; } else if (ST.CONTACT_A == "B") { _PARENT2 = $"{DF.TITLE_B} {DF.SURNAME_B}"; } else if (ST.CONTACT_A == "N") { _PARENT2 = null; } else if (DF.SURNAME_A == DF.SURNAME_B) { _PARENT2 = $"{DF.TITLE_A} & {DF.TITLE_B} {DF.SURNAME_A}"; } else if (DF.SURNAME_A != null && DF.SURNAME_B != null) { _PARENT1 = $"{DF.TITLE_A} {DF.SURNAME_A} & {DF.TITLE_B} {DF.SURNAME_B}"; } else if (DF.SURNAME_A == null && DF.SURNAME_B != null) { _PARENT1 = $"{DF.TITLE_B} {DF.SURNAME_B}"; } else if (DF.SURNAME_B == null && DF.SURNAME_A != null) { _PARENT1 = $"{DF.TITLE_A} {DF.SURNAME_A}"; } else { _PARENT1 = "STUDENT HAS NO LISTED PARENTS"; } _SURNAME = ST.SURNAME; _FIRST_NAME = ST.FIRST_NAME; _SECOND_NAME = ST.SECOND_NAME; _PREF_NAME = ST.PREF_NAME; _TITLE = ST.TITLE; _AB_STUDY = ST.AB_STUDY; _EMA = ST.ED_ALLOW; _BIRTHDATE = ST.BIRTHDATE; _CAMPUS = ST.CAMPUS; _ENTRY = ST.ENTRY; _GENDER = ST.GENDER; _HOME_GROUP = ST.HOME_GROUP; _HOME_LANG = ST.HOME_LANG; _HOUSE = ST.HOUSE; _KOORIE = ST.KOORIE; _NOTES = ST.NOTES; _RELATION_A01 = ST.RELATION_A01; _SCHOOL_YEAR = ST.SCHOOL_YEAR; _FAM_ORDER = ST.FAM_ORDER; _DESCRIPTION = KCY.DESCRIPTION; _STATUS = ST.STATUS; _STUDENT_PIC = ST.STUDENT_PIC; _TAG = ST.TAG; _YOUTH_ALLOW = ST.YOUTH_ALLOW; _FAMILY = ST.FAMILY; _LOTE_HOME_CODE = ST.LOTE_HOME_CODE; _SGB_FUNDED = ST.SGB_FUNDED; _INTERNATIONAL_ST_ID = ST.INTERNATIONAL_ST_ID; _CONTACT_A = ST.CONTACT_A; _IMMUNISE_CERT_STATUS = ST.IMMUNISE_CERT_STATUS; _LBOTE = ST.LBOTE; _DFKEY = DF.DFKEY; _SURNAME_A = DF.SURNAME_A; _NAME_A = DF.NAME_A; _TITLE_A = DF.TITLE_A; _E_MAIL_A = DF.E_MAIL_A; _SURNAME_B = DF.SURNAME_B; _NAME_B = DF.NAME_B; _E_MAIL_B = DF.E_MAIL_B; _TITLE_B = DF.TITLE_B; _MAILKEY = DF.MAILKEY; _NO_STUDENTS = DF.NO_STUDENTS; _LOTE_HOME_CODE_A = DF.LOTE_HOME_CODE_A; _LOTE_HOME_CODE_B = DF.LOTE_HOME_CODE_B; _OCCUP_STATUS_A = DF.OCCUP_STATUS_A; _OCCUP_STATUS_B = DF.OCCUP_STATUS_B; _WORK_CONT_A = DF.WORK_CONT_A; _BH_AT_HOME_A = DF.BH_AT_HOME_A; _BH_CONTACT_A = DF.BH_CONTACT_A; _AH_AT_HOME_A = DF.AH_AT_HOME_A; _AH_CONTACT_A = DF.AH_CONTACT_A; _PREF_MAIL_MECH_A = DF.PREF_MAIL_MECH_A; _FAX_A = DF.FAX_A; _WORK_CONT_B = DF.WORK_CONT_B; _BH_AT_HOME_B = DF.BH_AT_HOME_B; _BH_CONTACT_B = DF.BH_CONTACT_B; _AH_AT_HOME_B = DF.AH_AT_HOME_B; _AH_CONTACT_B = DF.AH_CONTACT_B; _PREF_MAIL_MECH_B = DF.PREF_MAIL_MECH_B; _FAX_B = DF.FAX_B; _FAM_OCCUP = ST.FAMILY_OCCUPATION; _UMKEY = UM.UMKEY; _ADDRESS01 = UM.ADDRESS01; _ADDRESS02 = UM.ADDRESS02; _ADDRESS03 = UM.ADDRESS03; _POSTCODE = UM.POSTCODE; _STATE = UM.STATE; _TELEPHONE = UM.TELEPHONE; _FAX = UM.FAX; }
internal V_FAMILY_CONTACTDataSet(SeamlessViewsContext Context) : base(Context) { }
internal V_STPO(SeamlessViewsContext Context, STPO STPO) : base(Context) { _STPOKEY = STPO.STPOKEY; _SGLINK = STPO.SGLINK; }
internal V_RISK(SeamlessViewsContext Context, ST ST, bool KGDAvailable, bool KGGAvailable) : base(Context) { var year = DateTime.Now.Year; var eslCutOff = new DateTime(year, 1, 1); _FIRST_REG_NO = ST.FIRST_REG_NO; _STKEY = ST.STKEY; _ENTRY = ST.ENTRY?.ToString("MM/dd/yyyy"); _SCHOOL_YEAR = ST.SCHOOL_YEAR; _HOME_GROUP = ST.HOME_GROUP; _STUDENT = $"{ST.SURNAME}, {ST.FIRST_NAME}"; var attendance = ST. STKEY_SXAB_STKEY .Where(sxab => sxab.ABSENCE_DATE.Value.Year == year) .Select(sxab => new { sxab.STKEY, sxab.ABSENCE_DATE, AM = sxab.AM_ACT_TYPE_KCT, PM = sxab.PM_ACT_TYPE_KCT, Source = 0 // SXAB }) .Concat( ST.STKEY_SXABCONV_STKEY .Where(conv => conv.ABSENCE_DATE.Value.Year == year) .Select(conv => new { conv.STKEY, conv.ABSENCE_DATE, AM = conv.AM_TYPE_KCT, PM = conv.PM_TYPE_KCT, Source = 1 // SXABCONV })) .GroupBy( r => new { r.STKEY, r.ABSENCE_DATE }, (k, g) => new { k.STKEY, k.ABSENCE_DATE, AM = g.Aggregate((r1, r2) => r2.AM.KCTKEY > 0 && (r1.Source == 1 && (r2.Source == 0 || r2.AM.KCTKEY > r1.AM.KCTKEY)) || (r1.Source == 0 && r2.Source == 0 && r2.AM.KCTKEY > r1.AM.KCTKEY) ? r2 : r1).AM, PM = g.Aggregate((r1, r2) => r2.PM.KCTKEY > 0 && (r1.Source == 1 && (r2.Source == 0 || r2.PM.KCTKEY > r1.PM.KCTKEY)) || (r1.Source == 0 && r2.Source == 0 && r2.PM.KCTKEY > r1.PM.KCTKEY) ? r2 : r1).PM }).ToList(); var absences = attendance.Aggregate(0m, (v, r) => (r.AM.KCTKEY >= 200 && r.AM.CURRICULUM == "N" ? .5m : 0m) + (r.PM.KCTKEY >= 200 && r.PM.CURRICULUM == "N" ? .5m : 0m)); var daysMarked = attendance.Aggregate(0m, (v, r) => (r.AM.KCTKEY > 0 ? .5m : 0m) + (r.PM.KCTKEY > 0 ? .5m : 0m)); _UNAPPROVED = attendance.Aggregate(0m, (v, r) => (r.AM.KCTKEY == 208 || r.AM.KCTKEY == 300 || r.AM.KCTKEY == 500 ? .5m : 0m) + (r.PM.KCTKEY == 208 || r.PM.KCTKEY == 300 || r.PM.KCTKEY == 500 ? .5m : 0m)); _ATTEND_PERCENT = daysMarked > 0m ? (daysMarked - absences) / daysMarked * 100m : 0m; _ENGREA = ST.STKEY_STVDI_SKEY.Where(r => r.VDIMENSION == "ENGREA" && r.SCORE != "NA").Aggregate((STVDI)null, (a, r) => a == null || r.YEAR_SEMESTER.CompareTo(a.YEAR_SEMESTER) > 0 ? r : a)?.SCORE ?? ""; _ENGWRI = ST.STKEY_STVDI_SKEY.Where(r => r.VDIMENSION == "ENGWRI" && r.SCORE != "NA").Aggregate((STVDI)null, (a, r) => a == null || r.YEAR_SEMESTER.CompareTo(a.YEAR_SEMESTER) > 0 ? r : a)?.SCORE ?? ""; _MATNUM = ST.STKEY_STVDI_SKEY.Where(r => r.VDIMENSION == "MATNUM" && r.SCORE != "NA").Aggregate((STVDI)null, (a, r) => a == null || r.YEAR_SEMESTER.CompareTo(a.YEAR_SEMESTER) > 0 ? r : a)?.SCORE ?? ""; _MATSTR = ST.STKEY_STVDI_SKEY.Where(r => r.VDIMENSION == "MATSTR" && r.SCORE != "NA").Aggregate((STVDI)null, (a, r) => a == null || r.YEAR_SEMESTER.CompareTo(a.YEAR_SEMESTER) > 0 ? r : a)?.SCORE ?? ""; _INTERNAL_SUSPENSION = attendance.Aggregate(0m, (v, r) => (r.AM.KCTKEY == 400 ? .5m : 0m) + (r.PM.KCTKEY == 400 ? .5m : 0m)); _EXTERNAL_SUSPENSION = attendance.Aggregate(0m, (v, r) => (r.AM.KCTKEY == 401 ? .5m : 0m) + (r.PM.KCTKEY == 401 ? .5m : 0m)); _OCCUPATION_CODE = ST.FAMILY_OCCUPATION; _ALERTS = $"{ST.KOORIE ?? "N"}{(ST.BIRTH_COUNTRY_KGT?.REFUGEE == "Y" ? "Y" : (ST.ESL(eslCutOff, 7) == "Y" && ST.VISA_SUBCLASS_KCV?.REFUGEE == "Y" ? "Y" : "N"))}{ST.DISABILITY ?? "N"}{ST.INTEGRATION ?? "N"}{ST.YOUTH_ALLOW ?? "N"}{ST.ACCESS_ALERT ?? "N"}{ST.RISK_ALERT ?? "N"}{ST.MEDICAL_ALERT ?? "N"}"; _GENDER = ST.GENDER; _LIVING_ARR = ST.LIVING_ARR; _EXIT_DATE = ST.EXIT_DATE?.ToString("dd/MM/yyyy"); // KGD isn't currently included in any typical eduHub services if (KGDAvailable) { _EXIT_0 = ST.STATUS == "LEFT" ? (ST.SCHOOL_YEAR.CompareTo("09") < 0 || ST.SCHOOL_YEAR == "UG" ? ST.NEXT_SCHOOL_SKGS?.NAME ?? "" : ST.EXIT_DEST01_KGD?.DESCRIPTION ?? "") : ""; } else { _EXIT_0 = ST.STATUS == "LEFT" ? ST.NEXT_SCHOOL_SKGS?.NAME ?? "" : ""; } // KGG isn't currently included in any typical eduHub services if (KGGAvailable) { _EXIT_6 = ST.EXIT_CAT01_KGG?.DESCRIPTION; } else { _EXIT_6 = null; } }
internal V_KSF(SeamlessViewsContext Context, KSF KSF) : base(Context) { _KSFKEY = KSF.KSFKEY; _DESCRIPTION = KSF.DESCRIPTION; }
internal V_KSFDataSet(SeamlessViewsContext Context) : base(Context) { }
internal SeamlessViewsEntity(SeamlessViewsContext Context) { this.Context = Context; }
internal V_KGH(SeamlessViewsContext Context, KGH KGH) : base(Context) { _KGHKEY = KGH.KGHKEY; _DESCRIPTION = KGH.DESCRIPTION; }
internal SeamlessViewsDataSet(SeamlessViewsContext Context) { this.Context = Context; Items = new Lazy <List <T> >(EnsureAvailableAndLoad); }