public static List <ReportPeriod> loadReportPeriodsFromThisSchool(SqlConnection connection, School school)
        {
            List <ReportPeriod> returnMe = new List <ReportPeriod>();

            SqlCommand sqlCommand = new SqlCommand();

            sqlCommand.Connection  = connection;
            sqlCommand.CommandType = CommandType.Text;
            sqlCommand.CommandText = "SELECT * FROM ReportPeriod WHERE iSchoolID=" + school.getSchoolLogicID() + "";
            sqlCommand.Connection.Open();
            SqlDataReader dataReader = sqlCommand.ExecuteReader();

            if (dataReader.HasRows)
            {
                while (dataReader.Read())
                {
                    returnMe.Add(new ReportPeriod(
                                     int.Parse(dataReader["iReportPeriodID"].ToString().Trim()),
                                     dataReader["cName"].ToString().Trim(),
                                     DateTime.Parse(dataReader["dStartDate"].ToString()),
                                     DateTime.Parse(dataReader["dEndDate"].ToString()),
                                     int.Parse(dataReader["iSchoolID"].ToString().Trim()),
                                     int.Parse(dataReader["iTermID"].ToString().Trim())
                                     ));
                }
            }

            sqlCommand.Connection.Close();
            foreach (ReportPeriod rp in returnMe)
            {
                rp.loadReportPeriodSettings(connection);
            }
            return(returnMe);
        }
Ejemplo n.º 2
0
        public static List <Student> loadReserveStudentsFromThisSchool(SqlConnection connection, School school)
        {
            List <Student> returnMe = new List <Student>();

            SqlCommand sqlCommand = new SqlCommand();

            sqlCommand.Connection  = connection;
            sqlCommand.CommandType = CommandType.Text;
            sqlCommand.CommandText = "SELECT * FROM LSKY_ActiveStudents WHERE ResideOnReserve=1 AND SchoolID=@SchoolID ORDER BY SchoolID ASC, Grade ASC;";
            sqlCommand.Parameters.AddWithValue("@SchoolID", school.getGovIDAsString());
            sqlCommand.Connection.Open();
            SqlDataReader dataReader = sqlCommand.ExecuteReader();

            if (dataReader.HasRows)
            {
                while (dataReader.Read())
                {
                    string HomeRoom  = dataReader["HomeRoom"].ToString().Trim();
                    string HRT_Title = dataReader["HomeRoomTeacherTitle"].ToString().Trim();
                    string HRT_First = dataReader["HomeRoomTeacherFirstName"].ToString().Trim();
                    string HRT_Last  = dataReader["HomeRoomTeacherLastName"].ToString().Trim();
                    if ((!string.IsNullOrEmpty(HRT_First)) && (!string.IsNullOrEmpty(HRT_Last)))
                    {
                        HomeRoom = HomeRoom + " (";
                        if ((!string.IsNullOrEmpty(HRT_Title)))
                        {
                            HomeRoom = HomeRoom + HRT_Title;
                        }
                        else
                        {
                            HomeRoom = HomeRoom + HRT_First;
                        }

                        HomeRoom = HomeRoom + " " + HRT_Last + ")";
                    }
                    bool hasPhoto = false;
                    if (!string.IsNullOrEmpty(dataReader["PhotoType"].ToString()))
                    {
                        hasPhoto = true;
                    }

                    int credits = 0;
                    int.TryParse(dataReader["Credits"].ToString(), out credits);

                    Student newStudent = new Student(
                        dataReader["FirstName"].ToString().Trim(),
                        dataReader["LastName"].ToString().Trim(),
                        dataReader["LegalFirstName"].ToString().Trim(),
                        dataReader["LegalLastName"].ToString().Trim(),
                        dataReader["LegalMiddleName"].ToString(),
                        dataReader["StudentNumber"].ToString().Trim(),
                        dataReader["GovernmentIDNumber"].ToString().Trim(),
                        dataReader["School"].ToString().Trim(),
                        dataReader["SchoolID"].ToString().Trim(),
                        dataReader["Grade"].ToString().Trim(),
                        dataReader["Region"].ToString().Trim(),
                        dataReader["City"].ToString().Trim(),
                        dataReader["Street"].ToString().Trim(),
                        dataReader["HouseNo"].ToString().Trim(),
                        dataReader["ApartmentNo"].ToString().Trim(),
                        dataReader["PostalCode"].ToString().Trim(),
                        dataReader["Phone"].ToString().Trim(),
                        dataReader["Gender"].ToString().Trim(),
                        dataReader["InStatus"].ToString().Trim(),
                        dataReader["InStatusCode"].ToString().Trim(),
                        dataReader["HomeRoom"].ToString().Trim(),
                        DateTime.Parse(dataReader["InDate"].ToString()),
                        DateTime.Parse(dataReader["DateOfBirth"].ToString()),
                        dataReader["BandNo"].ToString().Trim(),
                        dataReader["BandName"].ToString().Trim(),
                        dataReader["ReserveName"].ToString().Trim(),
                        dataReader["ReserveHouse"].ToString().Trim(),
                        dataReader["StatusNo"].ToString().Trim(),
                        bool.Parse(dataReader["ResideOnReserve"].ToString()),
                        int.Parse(dataReader["TrackID"].ToString()),
                        hasPhoto,
                        dataReader["cUserName"].ToString().Trim(),
                        credits,
                        int.Parse(dataReader["iActive_StudentStatusID"].ToString()),
                        dataReader["AboriginalStatus"].ToString().Trim(),
                        dataReader["LanguageHome"].ToString().Trim(),
                        dataReader["ParkingPermit"].ToString().Trim(),
                        dataReader["cLockerNumber"].ToString().Trim(),
                        dataReader["cLockerCombination"].ToString().Trim()
                        );
                    returnMe.Add(newStudent);
                }
            }

            sqlCommand.Connection.Close();
            return(returnMe);
        }