Example #1
0
        public StudentGrades OneStudentGradeOneCourse(string studentSsn, string courseName)
        {
            StudentGrades result = new StudentGrades();
            int           count;
            DbInfo        dbInfo     = new DbInfo();
            SqlConnection connection = dbInfo.OpenConnection();

            using (connection)
            {
                using (SqlCommand command = new SqlCommand())
                {
                    command.Connection  = connection;
                    command.CommandType = CommandType.Text;
                    command.CommandText = System.String.Format("select count(*) from Students " +
                                                               "join CoursesStudentsRelation on Students.id = CoursesStudentsRelation.id_student " +
                                                               "where SSN = '{0}' and title_course='{1}'", studentSsn, courseName);
                    count = (int)command.ExecuteScalar();
                }
            }
            if (count == 0)
            {
                result.course = "aa";
                result.grade  = -100;
            }
            else
            {
                result = ShowStudentGrades(studentSsn).Where(studentGrades => studentGrades.course == courseName).First();
            }
            return(result);
        }
Example #2
0
        public static void Main(string[] args)
        {
            //Console.ForegroundColor = ConsoleColor.Black;

            Console.WriteLine("BNU CO453 Applications Programming 2020-2021!");
            Console.WriteLine();
            Console.Beep();

            string[] choice = { "Distance Converter", "BMI Calculator",
                                "Student Marks",      "Social Network" };


            int choiceNo = ConsoleHelper.SelectChoices(choice);

            if (choiceNo == 1)
            {
                DistanceConverter converter = new DistanceConverter();
                converter.Run();
            }
            else if (choiceNo == 2)
            {
                BMI calculator = new BMI();
                calculator.Run();
            }
            else if (choiceNo == 3)
            {
                StudentGrades studentGrades = new StudentGrades();
                studentGrades.Run();
            }
            else if (choiceNo == 4)
            {
                app04.DisplayMenu();
            }
        }
        public StudentGrades GetGrade(string studentSsn, string courseName)
        {
            StudentGrades studentGrades = new StudentGrades();

            studentGrades.course = courseName;
            DbInfo        dbInfo     = new DbInfo();
            SqlConnection connection = dbInfo.OpenConnection();

            using (connection)
            {
                using (SqlCommand command = new SqlCommand(String.Format("select id from Students where SSN='{0}'", studentSsn), connection))
                {
                    string studentId = command.ExecuteScalar().ToString();
                    command.CommandText = String.Format("select grade from CoursesStudentsRelation where id_student='{0}' and title_course='{1}'", studentId, courseName);
                    using (SqlDataReader dataReader = command.ExecuteReader())
                    {
                        dataReader.Read();
                        if (dataReader.HasRows)
                        {
                            studentGrades.grade = dataReader.GetDouble(dataReader.GetOrdinal("grade"));
                        }
                        else
                        {
                            studentGrades.grade = null;
                        }
                    }
                }
            }
            return(studentGrades);
        }
Example #4
0
        private void button1_Click(object sender, EventArgs e)
        {
            StudentGrades frm = new StudentGrades();

            frm.Show();
            this.Hide();
        }
Example #5
0
        /// <summary>
        /// This method will print the heading title.
        /// conrol the color of the text.
        /// And run both distance converter and BMI application.
        /// </summary>
        /// <param name="args"></param>
        public static void Main(string[] args)
        {
            Console.ForegroundColor = ConsoleColor.Yellow;

            Console.WriteLine("BNU CO453 Applications Programming 2020-2021!");
            Console.WriteLine();
            Console.Beep();

            string [] choices = { " Distance Converter", " BMI Calculator", " Student Grades",
                                  " Social Network",     " RPG Game" };

            int choice = ConsoleHelper.SelectChoice(choices);

            if (choice == 1)
            {
                DistanceConverter converter = new DistanceConverter();
                converter.ConvertDistance();
            }
            else if (choice == 2)
            {
                App02.BMI calculator = new App02.BMI();
                calculator.Run();
            }
            else if (choice == 3)
            {
                StudentGrades grader = new StudentGrades();
                grader.Run();
            }
            else if (choice == 4)
            {
                SocialNetwork social = new SocialNetwork();
                social.Run();
            }
        }
        public ActionResult DeleteConfirmed(int id)
        {
            StudentGrades studentGrades = db.StudentGrades.Find(id);

            db.StudentGrades.Remove(studentGrades);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Example #7
0
        public static void Main(string[] args)
        {
            while (true)
            {
                //Creating an object of the distance converter
                DistanceConverter converter = new DistanceConverter();

                //Creating an object of the BMI calculator
                BMI bmi = new BMI();

                //Creating an object of the student grades
                StudentGrades grades = new StudentGrades();

                NetworkApp app04 = new NetworkApp();

                Console.ForegroundColor = ConsoleColor.Yellow;

                ConsoleHelper.OutputHeading("BNU CO453 Applications Programming 2020-2021!\n");

                string[] choices = { "Distance Converter", "BMI Calculator", "Student Grades", "Social Network", "Quit" };

                int choiceNo = ConsoleHelper.SelectChoice(choices);

                /**
                 * Uses if statements and a while loop and list of strings to allow user to
                 * decide on which application they wish to use based upon their inputted number
                 * 1-4
                 * 5 Is a Quit choice which will break the loop and end the application
                 */

                if (choiceNo == 1)
                {
                    converter.ConvertingDistance();
                }

                else if (choiceNo == 2)
                {
                    bmi.BMICalculator();
                }

                else if (choiceNo == 3)
                {
                    grades.ChooseMethod();
                }
                else if (choiceNo == 4)
                {
                    app04.DisplayMenu();
                }
                else if (choiceNo == 5)
                {
                    break;
                }
                else
                {
                    Console.WriteLine("\nYou have entered an invalid choice");
                }
            }
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        ReportDocument crp = new ReportDocument();

        crp.Load(Server.MapPath("~/CrystalReportStudentGrades.rpt"));
        StudentGrades dsStu = GetData();

        crp.SetDataSource(dsStu);
        CrystalReportViewer1.ReportSource = crp;
    }
 public ActionResult Edit([Bind(Include = "Id,StudentId,Grade")] StudentGrades studentGrades)
 {
     if (ModelState.IsValid)
     {
         db.Entry(studentGrades).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.StudentId = new SelectList(db.StudentUserAccounts, "Id", "FullName", studentGrades.StudentId);
     return(View(studentGrades));
 }
Example #10
0
 public static void ShowGrades(StudentGrades grade)
 {
     if (grade == StudentGrades.Advanced)
     {
         Console.WriteLine("The grade is advanced");
     }
     else if (grade == StudentGrades.Intermdiate)
     {
         Console.WriteLine("The grade is intermediate");
     }
 }
        // GET: StudentGrades/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            StudentGrades studentGrades = db.StudentGrades.Find(id);

            if (studentGrades == null)
            {
                return(HttpNotFound());
            }
            return(View(studentGrades));
        }
Example #12
0
        public static void Main(string[] args)
        {
            Console.ForegroundColor = ConsoleColor.Yellow;

            Console.WriteLine("BNU CO453 Applications Programming 2020-2021!");
            Console.WriteLine();
            Console.Beep();

            DistanceConverter converter  = new DistanceConverter();
            BMI_Calculator    calculator = new BMI_Calculator();
            StudentGrades     grades     = new StudentGrades();
            NetworkApp        app        = new NetworkApp();

            // Ask the user which app they want to use

            string[] choices = new string[]
            {
                "App01 Distance Converter",
                "App02 BMI Calculator",
                "App03 Student Grades",
                "App04 Social Network"
            };

            int choiceNo = ConsoleHelper.SelectChoice(choices);

            if (choiceNo == 1)
            {
                converter.Run();
            }

            else if (choiceNo == 2)
            {
                calculator.OutputBmi();
            }

            else if (choiceNo == 3)
            {
                grades.UserSelect();
            }

            else if (choiceNo == 4)
            {
                app.DisplayMenu();
            }

            else
            {
                Console.WriteLine("Invalid choice");
            }
        }
        public void PickGrades_updateGrades()
        {
            double presnetgrade = 78;
            double pickgrade    = 78;
            //double expected = 77;
            StudentGrades randgrade = new StudentGrades("Mr.A", presnetgrade);

            randgrade.pick(pickgrade);


            //double actual = randgrade.Grades;
            //Assert.AreEqual(pickgrade, presnetgrade, "No improvement in the grade");
            //Console.WriteLine("The Grade is same as previous");
        }
Example #14
0
        public static void Main(string[] args)
        {
            Console.ForegroundColor = ConsoleColor.Yellow;

            Console.WriteLine("BNU CO453 Applications Programming 2020-2021!");
            Console.WriteLine();
            Console.WriteLine("1. Distance Converter");
            Console.WriteLine("2. BMI Calculator");
            Console.WriteLine("3. Student Grades");
            Console.WriteLine("4. Social Network");
            Console.WriteLine("5. RPG Game");
            Console.WriteLine(" ==================== ");
            Console.WriteLine(" Select your application > ");
            Console.WriteLine(" ==================== ");
            string choice = Console.ReadLine();


            if (choice == "1")
            {
                DistanceConverter converter = new DistanceConverter();
                converter.ConvertDistance();
            }
            else if (choice == "2")
            {
                BMICalculator converter = new BMICalculator();
                converter.Run();
            }

            else if (choice == "3")
            {
                StudentGrades converter = new StudentGrades();
                converter.UserSelect();
            }

            else if (choice == "4")
            {
                App04.DisplayMenu();
            }

            else if (choice == "5")
            {
                throw new Exception();
            }

            else
            {
                Console.WriteLine("Invalid choice");
            }
        }
        // GET: StudentGrades/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            StudentGrades studentGrades = db.StudentGrades.Find(id);

            if (studentGrades == null)
            {
                return(HttpNotFound());
            }
            ViewBag.StudentId = new SelectList(db.StudentUserAccounts, "Id", "FullName", studentGrades.StudentId);
            return(View(studentGrades));
        }
        public void TestMean()
        {
            StudentGrades grades = new StudentGrades();

            grades.MakeStudentTable();

            DataRow row = grades.students.NewRow();

            row["id"]             = 1;
            row["Name"]           = "Mohammed";
            row["Biology Mark"]   = 67;
            row["Physics Mark"]   = 78;
            row["Chemistry Mark"] = 70;
            row["Grade"]          = "First Class";
            grades.students.Rows.Add(row);
        }
Example #17
0
        public static void Main(string[] args)
        {
            Console.Clear();
            Console.ForegroundColor = ConsoleColor.White;

            Console.WriteLine("BNU CO453 Applications Programming Jan start");
            Console.WriteLine("Evan Castro");
            Console.WriteLine();

            string[] choices = new string[]
            {
                "Distance Coverter",
                "BMI Calculator",
                "Student Grades",
                "Social Network",
                "RSP Game"
            };

            ConsoleHelper.OutputTitle("Please select the application you wish to use ");
            choice = ConsoleHelper.SelectChoice(choices);

            if (choice == 1)
            {
                DistanceConverter converter = new DistanceConverter();
                converter.Run();
            }
            else if (choice == 2)
            {
                BMICalculator calculator = new BMICalculator();
                calculator.Run();
            }
            else if (choice == 3)
            {
                StudentGrades grades = new StudentGrades();
                grades.Run();
            }
            else if (choice == 4)
            {
                NetworkApp App04 = new NetworkApp();
                App04.DisplayMenu();
            }
            else if (choice == 5)
            {
                RPSGame game = new RPSGame();
                game.Run();
            }
        }
        public async Task <IActionResult> AddStudent(string password, string userName, string firstName, string lastName, string homeAddress)
        {
            //register functionality



            var user = new AppUser
            {
                FirstName   = firstName,
                LastName    = lastName,
                HomeAddress = homeAddress,
                UserName    = userName,
                Role        = "Student"
            };

            var _password = password;

            var result = await _userManager.CreateAsync(user, _password);

            if (result.Succeeded)
            {
                user = await _userManager.FindByNameAsync(user.UserName);

                var prelim   = InitializeGrades("Prelim");
                var midterm  = InitializeGrades("Midterm");
                var preFinal = InitializeGrades("Prefinal");
                var final    = InitializeGrades("Final");
                await _appDbContext.AddRangeAsync(prelim, midterm, preFinal, final);

                await _appDbContext.SaveChangesAsync();

                var grade = new StudentGrades
                {
                    AppUserID  = user.Id,
                    PrelimID   = prelim.ID,
                    MidtermID  = midterm.ID,
                    PrefinalID = preFinal.ID,
                    FinalID    = final.ID
                };

                await _appDbContext.AddAsync(grade);

                await _appDbContext.SaveChangesAsync();
            }
            return(RedirectToAction("Index", "Admin", new { area = "" }));
        }
Example #19
0
        private void AddGrade(List <int> grades, int subjectQuestionID, int week, int projId, int studentNumber)
        {
            int totalGrade = 0;

            foreach (int g in grades)
            {
                totalGrade += g;
            }
            int averageGrade = totalGrade / grades.Count();

            int currentUserNr = ((OAuth.CurrentUser)Session["currentUser"]).ID;

            //Pulling data out of the database, any information left stored is outdated and will be duplicated otherwise.

            var data1 = from sq in _db.SubjectQuestions
                        where sq.Id == subjectQuestionID
                        select sq;

            SubjectQuestions subjectQuestion = data1.ToList().First();

            var data2 = from rd in _db.ReviewDates
                        where rd.Project.Id == projId &&
                        rd.Weeknr == week
                        select rd;

            ReviewDates reviewDate = data2.ToList().First();

            var data3 = from p in _db.Projects
                        where p.Id == projId
                        select p;

            Project project = data3.ToList().First();

            StudentGrades studentGrade = new StudentGrades
            {
                Project         = project,
                Grade           = averageGrade,
                SubjectQuestion = subjectQuestion,
                Student         = _db.SearchStudentByStudentNumber(studentNumber),
                Reviewer        = _db.SearchStudentByStudentNumber(currentUserNr),
                ReviewDate      = reviewDate
            };

            _db.StudentGrades.Add(studentGrade);
        }
Example #20
0
        public static void Main(string[] args)
        {
            Console.ForegroundColor = ConsoleColor.Yellow;

            Console.WriteLine("BNU CO453 Applications Programming 2020-2021!");
            Console.WriteLine();

            // Using an extension method for each enumeration
            Console.WriteLine("Using MyEnum Extension Method!\n");
            Console.WriteLine("MyEnum Value = " + MyEnum.FirstValue);
            Console.WriteLine("MyEnum Friendly Value = " + MyEnum.FirstValue.EnumValue());
            Console.WriteLine();

            // Using an extension method for any enumeration
            StudentGrades grades = new StudentGrades();

            grades.TestGradesEnumeration();
        }
Example #21
0
        /// <summary>
        /// SAM 2016-03-20 added this thingy
        /// </summary>
        /// <returns></returns>
        public ActionResult ViewStudentGrades()
        {
            // I want a StudentGrades model, but I need a student and their grades in order to do this.
            List <StudentGrades> studentGrades = new List <StudentGrades>();
            // Get all the students
            List <Student> students = db.Students.ToList();
            // Get all the assignments
            List <Assignment> assignments = db.Assignments.ToList();

            foreach (Student student in students)
            {
                StudentGrades sg = new StudentGrades();
                sg.Student = student;
                sg.Grades  = db.Grades.Where(g => g.StudentID == student.StudentID).ToList();
                studentGrades.Add(sg);
            }

            return(View(new StudentGradesViewModel(assignments, studentGrades)));
        }
        private IEnumerable <StudentGrades> GetFromReader(DbDataReader reader)
        {
            IList <StudentGrades> studentsGrades = new List <StudentGrades>();

            while (reader?.Read() ?? false)
            {
                var grades = new StudentGrades
                {
                    Student = new Student {
                        FirstName = reader.GetString("Nome"), LastName = reader.GetString("Sobrenome")
                    },
                    Discipline_Grade = new Dictionary <string, double>()
                };
                _disciplines.ToList().ForEach(d => grades.Discipline_Grade.Add(d, Convert.ToDouble(reader[d])));

                studentsGrades.Add(grades);
            }

            return(studentsGrades);
        }
Example #23
0
        public ActionResult <StudentGradesAPI> GetStudentCourseGrade([Required] string studentSsn, [Required] string courseName)
        {
            StudentGrades getStudentCourseGrade = viewStudent.OneStudentGradeOneCourse(studentSsn, courseName);

            try
            {
                if (getStudentCourseGrade.grade == -100)
                {
                    return(StatusCode(400, System.String.Format("{0} SSN Student didn't enrol {1} course or {0} SSN student isn't exist or {1} isn't exist.", studentSsn, courseName)));
                }
                else
                {
                    return(Ok(mapper.Map <StudentGradesAPI>(getStudentCourseGrade)));
                }
            }
            catch
            {
                return(StatusCode(500, "Server Error."));
            }
        }
Example #24
0
        public static void Main(string[] args)
        {
            Console.Clear();
            Console.ForegroundColor = ConsoleColor.White;

            Console.WriteLine("BNU CO453 Applications Programming 2020-2021!");
            Console.WriteLine("Isabelle Thorpe");
            Console.WriteLine();

            string[] choices = new string[]
            {
                "Distance Coverter",
                "BMI Calculator",
                "Student Grades",
                "Network App"
            };

            ConsoleHelper.OutputTitle("Please select the application you wish to use ");
            choice = ConsoleHelper.SelectChoice(choices);

            if (choice == 1)
            {
                DistanceConverter converter = new DistanceConverter();
                converter.Run();
            }
            else if (choice == 2)
            {
                BMI_Calculator calculator = new BMI_Calculator();
                calculator.Run();
            }
            else if (choice == 3)
            {
                StudentGrades studentGrades = new StudentGrades();
                studentGrades.Run();
            }
            else if (choice == 4)
            {
                NetworkApp network = new NetworkApp();
                network.Run();
            }
        }
        public async Task <IActionResult> Grades(CreateStudentGradeDto Input)
        {
            var x = await _context.Grades.AddAsync(new Grade
            {
                Degree    = Input.Degree,
                LectureId = Input.LectureId,
                StudentId = Input.StudentId
            });

            await _context.SaveChangesAsync();

            var y = new StudentGrades
            {
                GradeId     = x.Entity.Id,
                Degree      = x.Entity.Degree,
                LectureName = await _context.Lectures.Where(l => l.Id == x.Entity.LectureId).Select(l => l.Name).FirstOrDefaultAsync(),
                IsSuccessed = x.Entity.Degree >= 50
            };

            return(Ok(y));
        }
Example #26
0
        public static void Main()
        {
            UserLib.OutputHeading(" C# Console Applications 2020");

            string [] choices =
            {
                "App01: Distance Converter", "App02: BMI Calculator",
                "App03: Student Grades",     "App04: Network",
                "App05: RPS Game",           "Quit"
            };

            int choiceNo = UserLib.SelectChoice(choices);

            if (choiceNo == 1)
            {
                DistanceConverter15 converter = new DistanceConverter15();
                converter.ConvertDistance();
            }
            else if (choiceNo == 2)
            {
                BMI bmi = new BMI();
                bmi.CalculateIndex();
            }
            else if (choiceNo == 3)
            {
                StudentGrades app = new StudentGrades();
                app.OutputMenu();
            }
            else if (choiceNo == 4)
            {
                NetworkUI network = new NetworkUI();
                network.DisplayMenu();
            }
            else if (choiceNo == 5)
            {
                GameView view = new GameView();

                view.PlayGame();
            }
        }
Example #27
0
        // GET: Students
        public async Task <IActionResult> Analyse()
        {
            var students = await _context.Students.ToListAsync();

            StudentGrades grades = new StudentGrades();

            grades.Students = new string[students.Count];
            grades.Marks    = new int[students.Count];

            int index = 0;

            foreach (Student student in students)
            {
                grades.Students[index] = student.Name;
                grades.Marks[index]    = student.Mark;
                index++;
            }

            grades.CalculateStats();
            grades.CalculateGradeProfile();
            return(View(grades));
        }
Example #28
0
        public static void Main(string[] args)
        {
            Console.ForegroundColor = ConsoleColor.Blue;

            ConsoleHelper.OutputHeading("CO453 C# Programming - MAIN MENU", 0.2);
            string[] choices =
            {
                "APP01: Distance Converter",
                "APP02: BMI Calculator",
                "APP03: Student Grades System",
                "APP04: Social Network"
            };
            int choice = ConsoleHelper.SelectChoice(choices);

            if (choice == 1)
            {
                DistanceConverter converter = new DistanceConverter();
                converter.ConvertDistance();
            }
            if (choice == 2)
            {
                BMI bmi = new BMI();
                bmi.MainMenu();
            }
            if (choice == 3)
            {
                StudentGrades studentGrades = new StudentGrades();
                studentGrades.OutputHeading();
            }
            if (choice == 4)
            {
                NetworkApp networkApp = new NetworkApp();
                networkApp.DisplayMenu();
            }
            else
            {
                Console.WriteLine("Please make your choice");
            }
        }
Example #29
0
        public static void Main(string[] args)
        {
            Console.ForegroundColor = ConsoleColor.Yellow;

            Console.WriteLine("BNU CO453 Applications Programming 2020-2021!");
            Console.WriteLine();

            Console.WriteLine();
            Console.WriteLine($" 1. App01 Distance Converter");
            Console.WriteLine($" 2. App02 BMI");
            Console.WriteLine($" 3. App03 Student Grades");
            Console.WriteLine($" 4. App04 Social Network");

            Console.Write("Please select an app > ");
            string choice = Console.ReadLine();


            if (choice.Equals("1"))
            {
                DistanceConverter converter = new DistanceConverter();
                converter.CalculatetoDistance();
            }
            else if (choice == "2")
            {
                BMI bmi = new BMI();
                bmi.Run();
            }
            else if (choice.Equals("3"))
            {
                StudentGrades studentGrades = new StudentGrades();
                studentGrades.Run();
            }
            else if (choice.Equals("4"))
            {
                NetworkApp app04 = new NetworkApp();
                app04.DisplayMenu();
            }
        }
Example #30
0
        public List <StudentGrades> ShowStudentGrades(string ssnStudent)
        {
            List <StudentGrades> result = new List <StudentGrades>();
            DbInfo        dbInfo        = new DbInfo();
            SqlConnection connection    = dbInfo.OpenConnection();

            using (connection)
            {
                using (SqlCommand command = new SqlCommand(String.Format("select title_course,grade from Students " +
                                                                         "join CoursesStudentsRelation on Students.id = CoursesStudentsRelation.id_student " +
                                                                         "where SSN = '{0}'", ssnStudent), connection))
                {
                    using (SqlDataReader dataReader = command.ExecuteReader())
                    {
                        if (dataReader.HasRows)
                        {
                            int course = dataReader.GetOrdinal("title_course");
                            int grade  = dataReader.GetOrdinal("grade");
                            while (dataReader.Read())
                            {
                                StudentGrades studentGrades = new StudentGrades();
                                studentGrades.course = dataReader.GetString(course);
                                if (dataReader.IsDBNull(grade))
                                {
                                    studentGrades.grade = null;
                                }
                                else
                                {
                                    studentGrades.grade = dataReader.GetDouble(grade);
                                }
                                result.Add(studentGrades);
                            }
                        }
                    }
                }
            }
            return(result);
        }
Example #31
0
 private static Student[] CalculateAverageGradeAndSort(StudentGrades[] catalogue)
 {
     Student[] studentsGrades = CalculateGradesForAllStudents(catalogue);
     InsertionSortGeneralGrades(ref studentsGrades);
     return studentsGrades;
 }
Example #32
0
        private void AddGrade(List<int> grades, int subjectQuestionID, int week, int projId, int studentNumber)
        {
            int totalGrade = 0;
            foreach (int g in grades)
            {
                totalGrade += g;
            }
            int averageGrade = totalGrade / grades.Count();

            int currentUserNr = ((OAuth.CurrentUser)Session["currentUser"]).ID;

            //Pulling data out of the database, any information left stored is outdated and will be duplicated otherwise.

            var data1 = from sq in _db.SubjectQuestions
                        where sq.Id == subjectQuestionID
                        select sq;

            SubjectQuestions subjectQuestion = data1.ToList().First();

            var data2 = from rd in _db.ReviewDates
                        where rd.Project.Id == projId
                        && rd.Weeknr == week
                        select rd;

            ReviewDates reviewDate = data2.ToList().First();

            var data3 = from p in _db.Projects
                        where p.Id == projId
                        select p;

            Project project = data3.ToList().First();

            StudentGrades studentGrade = new StudentGrades
            {
                Project = project,
                Grade = averageGrade,
                SubjectQuestion = subjectQuestion,
                Student = _db.SearchStudentByStudentNumber(studentNumber),
                Reviewer = _db.SearchStudentByStudentNumber(currentUserNr),
                ReviewDate = reviewDate
            };

            _db.StudentGrades.Add(studentGrade);
        }
Example #33
0
 private static void CalculateGradeForAStudent(StudentGrades[] catalogue, int i, ref Student[] studentsGrades)
 {
     studentsGrades[i].name = catalogue[i].name;
     decimal generalGrade = (CalculateGrade(catalogue[i].course1Grades) + CalculateGrade(catalogue[i].course2Grades) + CalculateGrade(catalogue[i].course3Grades)) / 3;
     studentsGrades[i].averageGrade = Math.Round(generalGrade, 2);
 }
Example #34
0
 private static Student[] CalculateGradesForAllStudents(StudentGrades[] catalogue)
 {
     Student[] studentsGrades = new Student[catalogue.Length];
     for (int i = 0; i < catalogue.Length; i++)
     {
         CalculateGradeForAStudent(catalogue, i, ref studentsGrades);
     }
     return studentsGrades;
 }
Example #35
0
 private static int CountGrade(StudentGrades studentGrades, int grade)
 {
     var number1 = studentGrades.course1Grades;
     int foundGrade1 = CountGradeForADiscipline(number1, grade);
     var number2 = studentGrades.course2Grades;
     int foundGrade2 = CountGradeForADiscipline(number2, grade);
     var number3 = studentGrades.course3Grades;
     int foundGrade3 = CountGradeForADiscipline(number3, grade);
     return foundGrade1 + foundGrade2 + foundGrade3;
 }
Example #36
0
        private static Student[] FindTheBestStudents(StudentGrades[] catalogue, int Grade)
        {
            Student[] allTheBestStudents = new Student[0];
            int max = 0;
            for (int i = 0; i < catalogue.Length; i++)
            {
                int numberOfSpecialGrade = CountGrade(catalogue[i], Grade);
                if (numberOfSpecialGrade > max)
                {
                    max = numberOfSpecialGrade;
                    Student student = new Student();
                    student.name = catalogue[i].name;
                    student.averageGrade = numberOfSpecialGrade;
                    AddStudentInResultList(ref allTheBestStudents, 0, student);

                }
                else
                {
                    if ((numberOfSpecialGrade == max) && (max != 0))
                    {
                        Student student = new Student();
                        student.name = catalogue[i].name;
                        student.averageGrade = numberOfSpecialGrade;
                        AddStudentInResultList(ref allTheBestStudents, allTheBestStudents.Length, student);
                    }
                }

            }
            return allTheBestStudents;
        }
Example #37
0
 private Student[] FindTheLowestGrade(StudentGrades[] catalogue)
 {
     Student[] studentsGrades = new Student[catalogue.Length];
     Student[] minimGrades = new Student[0];
     decimal minimGrade = 11;
     for (int i = 0; i < catalogue.Length; i++)
     {
         CalculateGradeForAStudent(catalogue, i, ref studentsGrades);
         if (studentsGrades[i].averageGrade < minimGrade)
         {
             minimGrade = studentsGrades[i].averageGrade;
             AddStudentInResultList(ref minimGrades, 0, studentsGrades[i]);
         }
         else
         {
             if (studentsGrades[i].averageGrade == minimGrade)
             {
                 AddStudentInResultList(ref minimGrades, minimGrades.Length, studentsGrades[i]);
             }
         }
     }
     return minimGrades;
 }