예제 #1
0
        private void cmdManageStudents_Click(object sender, EventArgs e)
        {
            ManageStudentsScreen manageStudent = new ManageStudentsScreen();

            this.Hide();
            manageStudent.Show();
        }
예제 #2
0
        private void cmdCancel_Click(object sender, EventArgs e)
        {
            try
            {
                foreach (Student Remove in Section.getInstance().ListofStudents())
                {
                    Section.getInstance().ListofStudents().Remove(Remove);
                }
            }
            catch (Exception p)
            {
                MessageBox.Show("error is " + p.ToString());
            }

            ManageStudentsScreen manageStudent = new ManageStudentsScreen();

            this.Hide();
            manageStudent.Show();
        }
예제 #3
0
        private void cmdSave_Click(object sender, EventArgs e)
        {
            bool invalidName = false, invalidReg = false, invalidDegree = false;

            lblNameError.Text = ""; lblRegNoError.Text = ""; lblDegreeError.Text = "";
            Student obj = new Student();

            if (obj.invalidName(txtName.Text))
            {
                lblNameError.Text = "Invalid Name";
                invalidName       = true;
            }
            if (obj.invalidRegisteration(txtRegNo.Text))
            {
                lblRegNoError.Text = "Invalid Registeration Number";
                invalidReg         = true;
            }
            if (obj.invalidDegree(cmbBoxDegree.Text))
            {
                lblDegreeError.Text = "Invalid Degree";
                invalidDegree       = true;
            }
            else
            {
                if (!invalidName && !invalidReg && !invalidDegree &&
                    Section.getInstance().ListofStudents().Count() > 0 && Section.getInstance().ListofStudents().Last().Courses2.Count() > 0)
                {
                    Student addStudent = new Student();
                    addStudent.Name1 = Section.getInstance().ListofStudents().Last().Name1;
                    addStudent.RegisterationNumber1 = Section.getInstance().ListofStudents().Last().RegisterationNumber1;
                    addStudent.Degree1  = Section.getInstance().ListofStudents().Last().Degree1;
                    addStudent.Courses2 = Section.getInstance().ListofStudents().Last().Courses2;

                    string studentInfo = string.Format("delete StudentData where RegNo='{0}'", addStudent.RegisterationNumber1);
                    DataBaseConnection.getInstance().executeQuery(studentInfo);
                    string deleteResult = string.Format("delete CourseDMC where StudentId='{0}'", addStudent.RegisterationNumber1);
                    DataBaseConnection.getInstance().executeQuery(deleteResult);


                    lblstudentExist.Text = "";
                    string storeStudent = string.Format("insert into StudentData(RegNo,Name,Degree,Courses) values('{0}','{1}','{2}','{3}')", txtRegNo.Text, txtName.Text,
                                                        cmbBoxDegree.Text, addStudent.Courses2.Count());

                    DataBaseConnection.getInstance().executeQuery(storeStudent);



                    foreach (CourseResult result in addStudent.Courses2)
                    {
                        string courseResult = string.Format("insert into CourseDMC(CourseId,CourseTitle,CreditHour,Marks,Semester,Grade,StudentId) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')",
                                                            result.CourseId1, result.CourseTitle1, result.CreditHours1, result.Marks1, result.Semester1, result.getGrade(), addStudent.RegisterationNumber1);
                        DataBaseConnection.getInstance().executeQuery(courseResult);
                    }



                    Section.getInstance().ListofStudents().RemoveRange(0, Section.getInstance().ListofStudents().Count());


                    ManageStudentsScreen studentScreen = new ManageStudentsScreen();
                    this.Hide();
                    studentScreen.Show();
                }
                else
                {
                    MessageBox.Show("Invalid Student info or course Result");
                }
            }

            //   }
        }