Ejemplo n.º 1
0
        public v_Course_Offerings getCourseOfferingsQuery(CourseTypeID CourseTypeID, WMAS WMASID1)
        {
            Years = base.GetYearList();

            _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL);

            bool useFullkeys;

            _clauseForCompareToSchoolsDistrict =
                GetClauseForCompareToSchoolsDistrict(
                    FullKeyUtils.FullKeyDecode(OrigFullKey), S4orALL,
                    CompareTo, OrgLevel,
                    SCounty, SAthleticConf, SCESA, SRegion,
                    out useFullkeys);

            DALCourseOfferings dalCO = new DALCourseOfferings();
            v_Course_Offerings ds    = new v_Course_Offerings();

            List <string> orderBy = GetOrderByList(ds.v_COURSE_OFFERINGS, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey));

            ds = dalCO.GetData(_fullKeys, Years, CourseTypeID, WMASID1, _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy);

            // to get it to compile
            return(ds);
        }
        public v_Coursework getCourseworkQuery(int Grade, CourseTypeID CourseTypeID, WMAS WMASID1)
        {
            List <int> sexCodes, raceCodes, disabilityCodes,
                       gradeCodes, econDisadvCodes, ELPCodes;

            base.GetViewByList(ViewBy, OrgLevel, out sexCodes,
                               out raceCodes, out disabilityCodes, out
                               gradeCodes, out econDisadvCodes, out ELPCodes);

            Years = base.GetYearList();

            _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL);

            bool useFullkeys;

            _clauseForCompareToSchoolsDistrict =
                GetClauseForCompareToSchoolsDistrict(
                    FullKeyUtils.FullKeyDecode(OrigFullKey), S4orALL,
                    CompareTo, OrgLevel,
                    SCounty, SAthleticConf, SCESA, SRegion,
                    out useFullkeys);

            DALCoursesTaken dalCT = new DALCoursesTaken();
            v_Coursework    ds    = new v_Coursework();

            List <string> orderBy = GetOrderByList(ds.v_COURSEWORK, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey));

            ds = dalCT.GetData(_fullKeys, Years, sexCodes, Grade, CourseTypeID, WMASID1, _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy);

            // to get it to compile
            return(ds);
        }
        public vExpulsionServicesAndReturns GetExpulsionAndReturnsData()
        {
            DALExpulsionServices         dal = new DALExpulsionServices();
            vExpulsionServicesAndReturns ds  = new vExpulsionServicesAndReturns();

            Years = base.GetYearList();

            _fullKeys = FullKeyUtils.GetFullKeysList(
                CompareTo, OrgLevel, OrigFullKey,
                CompareToSchoolsOrDistrict, S4orALL);

            bool useFullkeys = true;

            _clauseForCompareToSchoolsDistrict =
                GetClauseForCompareToSchoolsDistrict(
                    FullKeyUtils.FullKeyDecode(OrigFullKey), S4orALL,
                    CompareTo, OrgLevel,
                    SCounty, SAthleticConf, SCESA, SRegion,
                    out useFullkeys);

            List <string> orderBy = GetOrderByList(
                ds._vExpulsionServicesAndReturns, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey));

            ds = dal.GetExpulsionAndReturnsData(
                Years,
                FullKeyUtils.FullKeyDecode(_fullKeys),
                _clauseForCompareToSchoolsDistrict,
                useFullkeys,
                orderBy);

            //for sql trace
            this.sql = dal.SQL;

            return(ds);
        }
Ejemplo n.º 4
0
        public v_DropoutsWWoDisEconELPSchoolDistState GetDropoutData2()
        {
            DALDropouts dropouts = new DALDropouts();

            List <int> schoolTypes = GetSchoolTypesList(this.SchoolType);

            _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL);

            List <int> gradeCodeRange = GetGradeCodes();

            Years = base.GetYearList();

            List <int> sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes;

            GetViewByList(ViewBy, OrgLevel, out sexCodes, out raceCodes, out disabilityCodes, out gradeCodes, out econDisadvCodes, out ELPCodes);

            v_DropoutsWWoDisEconELPSchoolDistState ds = new v_DropoutsWWoDisEconELPSchoolDistState();
            List <string> orderBy = GetOrderByList(ds._v_DropoutsWWoDisEconELPSchoolDistState, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey));

            ds = dropouts.GetDropoutData2(FullKeyUtils.FullKeyDecode(this._fullKeys), schoolTypes,
                                          Years, sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes,
                                          ELPCodes, orderBy);

            this.sql = dropouts.SQL;

            return(ds);
        }
        public v_WSAS GetData(int Grade, List <string> Subjects, List <int> Groups)
        {
            v_WSAS ds = new v_WSAS();

            Years = base.GetYearList();

            _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL);

            bool useFullkeys;

            _clauseForCompareToSchoolsDistrict =
                GetClauseForCompareToSchoolsDistrict(
                    FullKeyUtils.FullKeyDecode(OrigFullKey), S4orALL,
                    CompareTo, OrgLevel,
                    SCounty, SAthleticConf, SCESA, SRegion,
                    out useFullkeys);


            List <string> orderBy = GetOrderByList(ds._v_WSAS, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey));

            ds = new DALWSAS().GetData(Years, _fullKeys, Grade, Subjects, Groups, _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy);


            return(ds);
        }
Ejemplo n.º 6
0
        public v_ActivitiesSchoolDistState getActivitiesQuery(string SHOW)
        {
            Years = base.GetYearList();

            _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL);

            List <int> schoolTypes = GetSchoolTypesList(this.SchoolType);

            bool useFullkeys;

            _clauseForCompareToSchoolsDistrict =
                GetClauseForCompareToSchoolsDistrict(
                    OrigFullKey, S4orALL,
                    CompareTo, OrgLevel,
                    SCounty, SAthleticConf, SCESA, SRegion,
                    out useFullkeys);

            DALActivities dalAO = new DALActivities();

            v_ActivitiesSchoolDistState ds = new v_ActivitiesSchoolDistState();

            List <string> orderBy = GetOrderByList(ds._v_ActivitiesSchoolDistState, CompareTo, OrigFullKey);

            ds = dalAO.GetActivitiesSchoolDistStateData(Years, _fullKeys, schoolTypes, SHOW, _clauseForCompareToSchoolsDistrict, useFullkeys, orderBy);

            // to get it to compile
            return(ds);
        }
        public v_Suspensions GetSuspensionsDaysLostData()
        {
            List <int> schoolTypes = GetSchoolTypesList(this.SchoolType);

            //create a bunch of Generics Lists, automatically
            //    populated with a 9 (the default value).
            List <int> sexCodes, raceCodes, disabilityCodes,
                       gradeCodes, econDisadvCodes, ELPCodes;

            base.GetViewByList(ViewBy, OrgLevel, out sexCodes,
                               out raceCodes, out disabilityCodes, out
                               gradeCodes, out econDisadvCodes, out ELPCodes);

            // jdj: must override default grade when ViewBY <> Grade
            if (ViewBy.Key != GroupKeys.Grade)
            {
                gradeCodes = GenericsListHelper.GetPopulatedList(99);
            }

            Years = base.GetYearList();


            //Special logic for which fullkeys to use.
            _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel,
                                                     OrigFullKey, CompareToSchoolsOrDistrict, S4orALL);


            bool useFullkeys = true; //

            _clauseForCompareToSchoolsDistrict =
                GetClauseForCompareToSchoolsDistrict(
                    FullKeyUtils.FullKeyDecode(OrigFullKey), S4orALL,
                    CompareTo, OrgLevel,
                    SCounty, SAthleticConf, SCESA, SRegion,
                    out useFullkeys);

            DALSuspensionsDaysLost SuspensionsDaysLost = new DALSuspensionsDaysLost();
            v_Suspensions          ds      = new v_Suspensions();
            List <string>          orderBy = GetOrderByList(ds._v_Suspensions,
                                                            CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey));

            ds = SuspensionsDaysLost.GetSuspensionsDaysLostData(
                raceCodes, sexCodes, disabilityCodes, Years,
                FullKeyUtils.FullKeyDecode(_fullKeys), gradeCodes,
                schoolTypes, econDisadvCodes, ELPCodes,
                _clauseForCompareToSchoolsDistrict,
                useFullkeys,
                orderBy);

            this.sql = SuspensionsDaysLost.SQL;
            return(ds);
        }
Ejemplo n.º 8
0
        private List <string> MyGetFullKeysList(CompareTo compareTo, OrgLevel orgLevel, string origFullKey, List <string> compareToSchoolsOrDistrict)
        {
            string myOrigFullkey = origFullKey;

            if (OrgLevel.Key != OrgLevelKeys.School)
            {
                //On Post Grad Intent page, if org level == district, school level fullkey should not appear.
                if (FullKeyUtils.GetOrgLevelFromFullKeyX(origFullKey).Key == OrgLevelKeys.School)
                {
                    myOrigFullkey = FullKeyUtils.DistrictFullKey(origFullKey);
                }
            }
            return(FullKeyUtils.GetFullKeysList(compareTo, orgLevel, myOrigFullkey, compareToSchoolsOrDistrict, S4orALL));
        }
Ejemplo n.º 9
0
        public v_ACT GetACTData()
        {
            List <int> schoolTypes = GetSchoolTypesList(this.SchoolType);

            //create a bunch of Generics Lists, automatically populated with a 9 (the default value).
            List <int> sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes;

            base.GetViewByList(ViewBy, OrgLevel, out sexCodes, out raceCodes,
                               out disabilityCodes, out gradeCodes, out econDisadvCodes, out ELPCodes);

            Years = base.GetYearList();

            if (ViewBy.Key == GroupKeys.Race)
            {
                raceCodes = GenericsListHelper.GetPopulatedList(1, 2, 3, 4, 5, 8);
            }

            //Special logic for which fullkeys to use.
            _fullKeys = FullKeyUtils.GetFullKeysList(
                CompareTo, OrgLevel, OrigFullKey,
                CompareToSchoolsOrDistrict, S4orALL);

            bool useFullkeys = true; //

            _clauseForCompareToSchoolsDistrict =
                GetClauseForCompareToSchoolsDistrict(
                    FullKeyUtils.FullKeyDecode(OrigFullKey), S4orALL,
                    CompareTo, OrgLevel,
                    SCounty, SAthleticConf, SCESA, SRegion,
                    out useFullkeys);

            DALACT        act     = new DALACT();
            v_ACT         ds      = new v_ACT();
            List <string> orderBy = GetOrderByList(
                ds._v_ACT, CompareTo, FullKeyUtils.FullKeyDecode(OrigFullKey));

            ds = act.GetACTData(
                raceCodes, sexCodes, disabilityCodes, Years,
                FullKeyUtils.FullKeyDecode(_fullKeys), gradeCodes, schoolTypes,
                econDisadvCodes, ELPCodes,
                _clauseForCompareToSchoolsDistrict,
                useFullkeys,
                orderBy);

            this.sql = act.SQL;
            return(ds);
        }
Ejemplo n.º 10
0
        public v_Staff GetStaffData()
        {
            //List<int> schoolTypes = GetSchoolTypesList(this.STYP);

            ////create a bunch of Generics Lists, automatically populated with a 9 (the default value).
            //List<int> sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes;
            //base.GetViewByList(ViewBy, OrgLevel, out sexCodes, out raceCodes,
            //    out disabilityCodes, out gradeCodes, out econDisadvCodes, out ELPCodes);

            Years = base.GetYearList();

            //Special logic for which fullkeys to use.
            _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL);


            bool useFullkeys = true; //

            _clauseForCompareToSchoolsDistrict =
                GetClauseForCompareToSchoolsDistrict(
                    OrigFullKey, S4orALL,
                    CompareTo, OrgLevel,
                    SCounty, SAthleticConf, SCESA, SRegion,
                    out useFullkeys);

            DALStaff      staff   = new DALStaff();
            v_Staff       ds      = new v_Staff();
            List <string> orderBy = GetOrderByList(ds._v_Staff, CompareTo, OrigFullKey);

            //List<string> orderBy = new List<string>();
            //orderBy.Add("PRIORYEAR");

            if (CompareTo.Key == CompareToKeys.SelSchools ||
                CompareTo.Key == CompareToKeys.SelDistricts)
            {
                orderBy.Add(ds._v_Staff.LinkedDistrictNameColumn.ColumnName);
            }

            orderBy.Add("Category");

            ds = staff.GetStaffData(
                Years, _fullKeys,
                _clauseForCompareToSchoolsDistrict,
                useFullkeys,
                orderBy);
            this.sql = staff.SQL;
            return(ds);
        }
        private List <string> MyGetFullKeysList(CompareTo compareTo, OrgLevel orgLevel, string origFullKey, List <string> compareToSchoolsOrDistrict)
        {
            List <string> retval = new List <string>();

            if (OrgLevel.Key == OrgLevelKeys.School)
            {
                //For Grad Requirements page:  school level data are not available.  Use District instead.
                string maskedFullKey = FullKeyUtils.DistrictFullKey(origFullKey);
                retval.Add(maskedFullKey);
            }
            else
            {
                retval = FullKeyUtils.GetFullKeysList(compareTo, orgLevel, origFullKey, compareToSchoolsOrDistrict, S4orALL);
            }

            return(retval);
        }
        /*public override string GetCompareToColumnName()
         * {
         *  return "Category";
         * }*/

        public v_Expend_2 GetExpenditureData()
        {
            Years = base.GetYearList();

            //before database view changed, hard code here
            //List <string> category = new List<string>();
            //category.Add("Food and Comm. Serv.");
            //category.Add("Transportation + Facilities");
            //category.Add("Current Education Cost");
            //category.Add("Total Cost");

            List <string> CT = new List <string>();

            CT.Add(cost);
            CT.Add(SligoCS.BL.WI.Constants.MONEY_PAGE_CURRENT_EDUCATION_COST);

            //Special logic for which fullkeys to use.
            _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel, OrigFullKey, CompareToSchoolsOrDistrict, S4orALL);

            bool useFullkeys = true; //

            _clauseForCompareToSchoolsDistrict =
                GetClauseForCompareToSchoolsDistrict(
                    FullKeyUtils.FullKeyDecode(OrigFullKey), S4orALL,
                    CompareTo, OrgLevel,
                    SCounty, SAthleticConf, SCESA, SRegion,
                    out useFullkeys);

            DALExpenditure dal = new DALExpenditure();
            v_Expend_2     ds  = new v_Expend_2();

            // before database view changed, hard code here. the base orderBy logic does not work here
            //List<string> orderBy = GetOrderByList(ds._v_Revenues_2, CompareToEnum, FullKeyUtils.FullKeyDecode(OrigFullKey));
            List <string> orderBy = new List <string>();

            orderBy.Add("Year desc");

            ds = dal.GetExpendData(CT, Years,
                                   FullKeyUtils.FullKeyDecode(_fullKeys),
                                   _clauseForCompareToSchoolsDistrict,
                                   useFullkeys,
                                   orderBy);
            this.sql = dal.SQL;
            return(ds);
        }
        protected List <string> MyGetFullKeysList(
            CompareTo compareTo, OrgLevel orgLevel, string origFullKey,
            List <string> compareToSchoolsOrDistrict)
        {
            List <string> retval = FullKeyUtils.GetFullKeysList(compareTo,
                                                                orgLevel, origFullKey, compareToSchoolsOrDistrict, S4orALL);

            if (this.OrgLevel.Key != OrgLevelKeys.School)
            {
                List <string> maskedVals = new List <string>();
                foreach (string fullkey in retval)
                {
                    string maskedVal = FullKeyUtils.GetMaskedFullkey(fullkey, this.OrgLevel);
                    maskedVals.Add(maskedVal);
                }
                retval = maskedVals;
            }

            return(retval);
        }
        public v_RetentionWWoDisEconELPSchoolDistState GetRetentionData2()
        {
            List <int> schoolTypes = GetSchoolTypesList(this.SchoolType);

            //create a bunch of Generics Lists, automatically populated with a 9 (the default value).
            List <int> sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes;

            base.GetViewByList(ViewBy, OrgLevel, out sexCodes, out raceCodes,
                               out disabilityCodes, out gradeCodes, out econDisadvCodes, out ELPCodes);

            Years = GetYearList(); // base.GetYearList();

            _fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel,
                                                     OrigFullKey, CompareToSchoolsOrDistrict, S4orALL);

            bool useFullkeys = true; //

            _clauseForCompareToSchoolsDistrict =
                GetClauseForCompareToSchoolsDistrict(
                    OrigFullKey, S4orALL,
                    CompareTo, OrgLevel,
                    SCounty, SAthleticConf, SCESA, SRegion,
                    out useFullkeys);

            DALRetention retention = new DALRetention();
            v_RetentionWWoDisEconELPSchoolDistState ds = new v_RetentionWWoDisEconELPSchoolDistState();
            List <string> orderBy = GetOrderByList(ds._v_RetentionWWoDisEconELPSchoolDistState,
                                                   CompareTo, OrigFullKey);

            ds = retention.GetRetentionData2(
                raceCodes, sexCodes, disabilityCodes, Years,
                _fullKeys, gradeCodes,
                schoolTypes, econDisadvCodes, ELPCodes,
                _clauseForCompareToSchoolsDistrict,
                useFullkeys,
                orderBy);

            this.sql = retention.SQL;
            return(ds);
        }
Ejemplo n.º 15
0
        //Notes for graph

        /* public override string GetViewByColumnName()
         * {
         *   //There is no RaceShortLabel column in this page, so we need to use the Full paramName
         *   if (ViewBy.Key == GroupKeys.Race)
         *   {
         *       return "RaceLabel";
         *   }
         *   else
         *   {
         *       return base.GetViewByColumnName();
         *   }
         * }*/

        //Notes for graph

        /* public override string GetCompareToColumnName()
         * {
         *   if (CompareTo == CompareToEnum.DISTSTATE)
         *   {
         *       return "District paramName";
         *   }
         *   else
         *   {
         *       return base.GetCompareToColumnName();
         *   }
         * }*/


        private List <string> MyGetFullKeysList(
            CompareTo compareTo,
            OrgLevel orgLevel, string origFullKey,
            List <string> compareToSchoolsOrDistrict)
        {
            List <string> retval = new List <string>();


            if (OrgLevel.Key == OrgLevelKeys.School)
            {
                newOrigFullKey    = FullKeyUtils.DistrictFullKey(origFullKey);
                newOrgLevel.Value = newOrgLevel.Range[OrgLevelKeys.District];
                //convert each school into a district fullkey
                foreach (string fullkey in compareToSchoolsOrDistrict)
                {
                    string maskedFullkey = FullKeyUtils.GetMaskedFullkey(fullkey, OrgLevelKeys.District);
                    newCompareToSchools.Add(maskedFullkey);
                }
            }

            if (orgLevel.Key == OrgLevelKeys.District)
            {
                newOrgLevel         = orgLevel;
                newOrigFullKey      = origFullKey;
                newCompareToSchools = compareToSchoolsOrDistrict;
            }

            else if (orgLevel.Key == OrgLevelKeys.State)
            {
                newOrgLevel    = orgLevel;
                newOrigFullKey = FullKeyUtils.StateFullKey(origFullKey);
            }

            retval = FullKeyUtils.GetFullKeysList(compareTo, newOrgLevel, newOrigFullKey, newCompareToSchools, S4orALL);

            return(retval);
        }