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); }
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); }
private void button1_Click(object sender, EventArgs e) { StudentGrades frm = new StudentGrades(); frm.Show(); this.Hide(); }
/// <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")); }
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)); }
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)); }
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"); }
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); }
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 = "" })); }
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); }
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(); }
/// <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); }
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.")); } }
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)); }
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(); } }
// 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)); }
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"); } }
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(); } }
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); }
private static Student[] CalculateAverageGradeAndSort(StudentGrades[] catalogue) { Student[] studentsGrades = CalculateGradesForAllStudents(catalogue); InsertionSortGeneralGrades(ref studentsGrades); return studentsGrades; }
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); }
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); }
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; }
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; }
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; }
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; }