Esempio n. 1
0
        private void Build_NameList(string year)
        {
            NameList.Items.Clear();
            if ((year == "14") || (year == ""))
            {
                Label_Year.Text = ((year == "14") ? "Past(Leaving year)" : "Current (Entry year)");
                //special case .. need leavers who are not therefore in a year group
                PastStudentList stlist = new PastStudentList(((year == "") ?"Expr13 = 1" :"Expr13 = 0")); //not on role
                foreach (SimplePupil sp in stlist._studentlist)
                {
                    ListItem Item = new ListItem(sp.m_GivenName + " " + sp.m_Surname + " (" + ((year == "14") ? sp.m_dol.Year.ToString() : sp.m_doa.Year.ToString()) + ")", sp.m_StudentId.ToString());
                    NameList.Items.Add(Item);
                }
            }
            else
            {
                DateTime d = new DateTime(); d = DateTime.Now;
                Label_Year.Text = "Year " + year;
                StudentYearList yl1 = new StudentYearList(NameList, year + "Year", d);
                if (NameList.Items.Count == 0)
                {
                    Label_Year.Text = "Year " + year + " (Next Year)";

                    yl1.StudentYearList_Load(NameList, year + "Year", d);
                }
            }
            if (NameList.Items.Count > 0)
            {
                NameList.Items[0].Selected = true;
            }
        }
Esempio n. 2
0
 public void SetUpYearList(string year)
 {
     //SimpleStudentList sl1 = new SimpleStudentList("GroupCode LIKE '"+year+"%'");
     StudentYearList yl1 = new StudentYearList(ListBox_Names, year + "Year", DateTime.Now);
     //ListBox_Names.Items.Clear();
     //foreach (SimplePupil p in sl1._studentlist)
     //{
     //   ListItem l = new ListItem(p.m_GivenName + " " + p.m_Surname, p.m_StudentId.ToString());
     //    ListBox_Names.Items.Add(l);
     // }
 }
Esempio n. 3
0
        protected void UpdateMessageList(string t)
        {
            Cerval_Globals cg1 = new Cerval_Globals();

            ListBox_staff.Items.Clear();
            string   s1    = DropDownList_Year.SelectedValue;
            DateTime date1 = new DateTime();

            date1 = DateTime.Now.AddMonths(0);

            if (t == "Group")
            {
                GroupList gl1;
                gl1 = new GroupList("", date1);
                //put the form groups first
                foreach (Group g in gl1._groups)
                {
                    if (g._GroupCode.StartsWith(s1))
                    {
                        if (g._CourseID == Cerval_Globals.RegistrationCse)//registration../
                        {
                            //only for year groups...
                            ListItem l1 = new ListItem(g._GroupCode, g._GroupID.ToString());
                            ListBox_staff.Items.Add(l1);
                        }
                    }
                }
                foreach (Group g in gl1._groups)
                {
                    if (g._GroupCode.StartsWith(s1))
                    {
                        if ((g._CourseID != Cerval_Globals.RegistrationCse) && (!Cerval_Globals.NewStructureCourses.Contains(g._CourseID)))
                        {
                            ListItem l1 = new ListItem(g._GroupCode, g._GroupID.ToString());
                            ListBox_staff.Items.Add(l1);
                        }
                    }
                }
            }


            if (t == "Student")
            {
                //StudentYearList yl1 = new StudentYearList(ListBox_staff, s1 + "Year", "{ fn NOW() }");
                StudentYearList yl1 = new StudentYearList(ListBox_staff, s1 + "Year", DateTime.Now);
                ListBox_staff.SelectionMode = ListSelectionMode.Multiple;
                TextBox_textTo.Visible      = true;
            }
        }
        private void Build_NameList(string year)
        {
            DateTime d = new DateTime(); d = DateTime.Now;

            Label_Year.Text = "Year " + year;
            StudentYearList yl1 = new StudentYearList(NameList, year + "Year", d);

            if (NameList.Items.Count == 0)
            {
                Label_Year.Text = "Year " + year + " (Next Year)";
                yl1.StudentYearList_Load(NameList, year + "Year", d);
            }
            if (NameList.Items.Count > 0)
            {
                NameList.Items[0].Selected = true;
            }
        }
Esempio n. 5
0
        protected void UpdateMessageList(string t)
        {
            Cerval_Globals cg1 = new Cerval_Globals();

            ListBox_staff.Items.Clear();
            string   s1    = DropDownList_Year.SelectedValue;
            DateTime date1 = new DateTime();

            date1 = DateTime.Now.AddMonths(0);

            if (t == "Group")
            {
                GroupList gl1;
                if (s1 == "My Groups")
                {
                    gl1 = new GroupList();
                    Utility u          = new Utility();
                    string  staff_code = u.GetsStaffCodefromRequest(Request);
                    gl1.LoadList_StaffPrivateGroups(staff_code.Trim(), GroupList.GroupListOrder.GroupName);
                    foreach (Group g in gl1._groups)
                    {
                        ListItem l1 = new ListItem(g._GroupName, g._GroupID.ToString());
                        ListBox_staff.Items.Add(l1);
                    }
                    return;
                }
                else
                {
                    gl1 = new GroupList("", date1);
                }
                //put the form groups first
                foreach (Group g in gl1._groups)
                {
                    if (g._GroupCode.StartsWith(s1))
                    {
                        if (g._CourseID == Cerval_Globals.RegistrationCse)//registration../
                        {
                            //only for year groups...
                            ListItem l1 = new ListItem(g._GroupCode, g._GroupID.ToString());
                            ListBox_staff.Items.Add(l1);
                        }
                    }
                }
                foreach (Group g in gl1._groups)
                {
                    if (g._GroupCode.StartsWith(s1))
                    {
                        if ((g._CourseID != Cerval_Globals.RegistrationCse) && (!Cerval_Globals.NewStructureCourses.Contains(g._CourseID)))
                        {
                            ListItem l1 = new ListItem(g._GroupCode, g._GroupID.ToString());
                            ListBox_staff.Items.Add(l1);
                        }
                    }
                    if (s1.ToUpper() == "14")
                    {
                        if (g._GroupCode.StartsWith("1") || g._GroupCode.StartsWith("7") || g._GroupCode.StartsWith("8") || g._GroupCode.StartsWith("9"))
                        {
                        }
                        else
                        {
                            ListItem l1 = new ListItem(g._GroupCode, g._GroupID.ToString());
                            ListBox_staff.Items.Add(l1);
                        }
                    }
                }
            }


            if (t == "Student")
            {
                //StudentYearList yl1 = new StudentYearList(ListBox_staff, s1 + "Year", "{ fn NOW() }");
                StudentYearList yl1 = new StudentYearList(ListBox_staff, s1 + "Year", DateTime.Now);
                ListBox_staff.SelectionMode = System.Web.UI.WebControls.ListSelectionMode.Multiple;
                TextBox_textTo.Visible      = true;
            }
        }
Esempio n. 6
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                GetMasterValues();
                DropDownList1.Visible = false;
                GridView2.Visible     = false;
                GridView1.Visible     = false;
                ListBox1.Visible      = false;
                TextBox1.Visible      = false;
                Label_Select3.Text    = "";
                if (Request.QueryString.Count >= 1)
                {
                    DisplayType = Request.QueryString["Type"];
                }
                switch (DisplayType)
                {
                case "Student":
                    Label_Select1.Text    = "Select Year:";
                    Label_Select3.Text    = "OR type Admission Number:";
                    DropDownList1.Visible = true;
                    DropDownList1.Items.Add("14");
                    DropDownList1.Items.Add("13");
                    DropDownList1.Items.Add("12");
                    DropDownList1.Items.Add("11");
                    DropDownList1.Items.Add("10");
                    DropDownList1.SelectedIndex = 1;
                    DropDownList1.Visible       = true;
                    ListBox1.Visible            = true;
                    TextBox1.Visible            = true;
                    GridView2.Visible           = true;

                    StudentYearList styl1 = new StudentYearList(ListBox1, DropDownList1.SelectedValue + "Year", DateTime.Now);

                    break;

                case "Option":
                    Label_Select1.Text    = "Select Option:";
                    DropDownList1.Visible = true;
                    GridView1.Visible     = true;
                    DropDownList1.Items.Clear();
                    ExamOption_List exol1 = new ExamOption_List(); exol1.Load(YearCode.ToString(), SeasonCode.ToString());
                    foreach (ExamOption exo in exol1.m_list)
                    {
                        DropDownList1.Items.Add(new ListItem(exo.m_OptionCode, exo.m_OptionID.ToString()));
                    }
                    DropDownList1.SelectedIndex = -1;
                    break;

                case "Subject":
                    Label_Select1.Text    = "Select Subject:";
                    DropDownList1.Visible = true;
                    GridView1.Visible     = true;
                    ListItem l1 = new ListItem("All", "0");
                    DropDownList1.Items.Add(l1);
                    CourseList cl1 = new CourseList(0);
                    foreach (Course c in cl1._courses)
                    {
                        if (c.KeyStage == 5)
                        {
                            ListItem l = new ListItem(c.CourseName + "( A-level)", c._CourseID.ToString());
                            DropDownList1.Items.Add(l);
                        }
                        if (c.KeyStage == 4)
                        {
                            ListItem l = new ListItem(c.CourseName + "( GCSE)", c._CourseID.ToString());
                            DropDownList1.Items.Add(l);
                        }
                    }
                    DropDownList1.SelectedIndex = -1;
                    break;

                case "Status":
                    Label_Select1.Text    = "Select Status:";
                    DropDownList1.Visible = true;
                    GridView1.Visible     = true;
                    Exam_Entry_Status_List el1 = new Exam_Entry_Status_List();
                    foreach (Exam_Entry_Status e1 in el1.m_list)
                    {
                        ListItem l2 = new ListItem(e1.m_EntryStatusDescription, e1.m_EntryStatusCode);
                        DropDownList1.Items.Add(l2);
                    }
                    //going to add extra line for Student resits...
                    ListItem l3 = new ListItem("Resit Request waiting to be processed", "RESITS");
                    DropDownList1.Items.Add(l3);
                    DropDownList1.SelectedIndex = -1;

                    break;

                default:
                    break;
                }
            }
        }
Esempio n. 7
0
        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {
            Encode en = new Encode();

            switch (DisplayType)
            {
            case "Student":
                StudentYearList styl1 = new StudentYearList(ListBox1, DropDownList1.SelectedValue + "Year", DateTime.Now);
                if (DropDownList1.SelectedValue == "14")
                {
                    styl1.Load_NotOnRole_ExamEntries(ListBox1, Year.ToString(), SeasonCode.ToString());
                }
                ListBox1.SelectedIndex = -1;
                break;

            case "Option":
                SqlDataSource1.SelectCommand    = GetQueryString();
                SqlDataSource1.ConnectionString = en.GetDbConnection();
                SqlDataSource1.DataBind();
                string s = "SELECT COUNT (ExamEntryID)  FROM dbo.qry_Cerval_Exams_Entries " + GetWhereString();
                Label_Grid.Text = "Entries for " + DropDownList1.SelectedItem.Text + "  Total Number =" + en.Execute_one_SQL(s);
                break;

            case "Subject":
                CourseId = DropDownList1.SelectedValue;
                SqlDataSource1.SelectCommand    = GetQueryString();
                SqlDataSource1.ConnectionString = en.GetDbConnection();
                SqlDataSource1.DataBind();
                Label_Grid.Text = "";
                if (SqlDataSource1.SelectCommand.Contains("ZZZZZZ"))
                {
                    Label_Grid.Text = "None found";
                }
                //the other option for none is that there are options found for this seasonby no entries... have to run the querry...
                int n = 0;
                using (SqlConnection cn = new SqlConnection(en.GetDbConnection()))
                {
                    cn.Open();
                    using (SqlCommand cm = new SqlCommand(SqlDataSource1.SelectCommand, cn))
                    {
                        using (SqlDataReader dr = cm.ExecuteReader())
                        {
                            while (dr.Read())
                            {
                                n++;
                            }
                            dr.Close();
                        }
                    }
                    cn.Close();
                }
                if (n == 0)
                {
                    Label_Grid.Text = "None found";
                }
                break;

            case "Status":
                SqlDataSource1.SelectCommand    = GetQueryString();
                SqlDataSource1.ConnectionString = en.GetDbConnection();
                SqlDataSource1.DataBind();
                if (DropDownList1.SelectedValue == "RESITS")
                {
                    string s1 = "SELECT COUNT (OptionCode)  FROM qry_Cerval_Exams_ResitEntries ";
                    Label_Grid.Text = "Entries for Status =  " + DropDownList1.SelectedItem.Text + "  Total Number =" + en.Execute_one_SQL(s1);
                }
                else
                {
                    string s1 = "SELECT COUNT (ExamEntryID)  FROM dbo.qry_Cerval_Exams_Entries " + GetWhereString();
                    Label_Grid.Text = "Entries for Status =  " + DropDownList1.SelectedItem.Text + "  Total Number =" + en.Execute_one_SQL(s1);
                }
                break;
            }
        }