Example #1
0
        public void ChangeItemTest()
        {
            var repo = new MarksRepository(_context);
            var item = new Mark
            {
                Student      = _context.Students.FirstOrDefault(),
                TeachSubj    = _context.TeachSubjs.FirstOrDefault(),
                StudentsMark = 77
            };

            repo.AddItem(item);
            int Id = _context.Marks.FirstOrDefault(x => x.Student.Id == item.Student.Id &&
                                                   x.TeachSubj.Id == item.TeachSubj.Id &&
                                                   x.StudentsMark == item.StudentsMark).Id;
            var newitem = repo.GetItem(Id);

            newitem.StudentsMark = 83;
            repo.ChangeItem(newitem);
            var gotitem = repo.GetItem(Id);

            Assert.AreEqual(newitem.Student.Id, gotitem.Student.Id);
            Assert.AreEqual(newitem.StudentsMark, gotitem.StudentsMark);
            Assert.AreEqual(newitem.TeachSubj.TeacherId, gotitem.TeachSubj.TeacherId);
            Assert.AreEqual(newitem.TeachSubj.SubjId, gotitem.TeachSubj.SubjId);
            _context.Marks.Remove(newitem);
        }
Example #2
0
 public AkademineisScreen(Student student)//constructor, when going to this screen we can provide values/objects to this screen
 {
     InitializeComponent();
     this.student          = student;
     repository            = new MarksRepository();//initialize repository
     StudentNameLabel.Text = student.FirstName + " " + student.LastName;
 }
Example #3
0
        public StaffMainScreen(Staff staff)//when going to this screen you have to provide staff object
        {
            InitializeComponent();
            this.staff         = staff;
            repository         = new MarksRepository();
            subteachRepository = new SubjectsTeachersRepository();

            if (staff.TypeId == 2)//if staff is ADMIN then show these panels, otherwise dont
            {
                TvarkytiNaudotojusPanel.Visible = true;
                SubjectTeacherPanel.Visible     = true;
            }
            groupsList   = subteachRepository.GetGroupsOfStaff(staff.StaffId);
            subjectsList = subteachRepository.GetSubjectsOfStaff(staff.StaffId);
            for (int a = 0; a < subjectsList.Count; a++)
            {
                SubjectNameDisplaycomboBox.Items.Add(subjectsList[a].Title);
            }


            for (int a = 0; a < groupsList.Count; a++)
            {
                GroupNameDisplaycomboBox.Items.Add(groupsList[a].Name);
            }

            UserName.Text = staff.Username + "" + staff.Password;
        }
Example #4
0
 public StudentService()
 {
     _context           = new SchoolContext();
     _subjectRepository = new SubjectRepository(_context);
     _studentRepository = new StudentRepository(_context);
     _markRepository    = new MarksRepository(_context);
     _subjectService    = new SubjectService(_subjectRepository);
 }
Example #5
0
 public SubjectService(SubjectRepository subjectRepository)
 {
     _markRepository = new MarksRepository(new SchoolContext());
     _database       = new SchoolContext();
     //  _studentService = new StudentService();
     _subjectRepository = subjectRepository;
     _markService       = new MarkService();
 }
Example #6
0
 public override void InitParams()
 {
     dbSet  = _context.Marks;
     r      = new MarksRepository(_context);
     model1 = new Mark {
         MarkStud = 1, Student = _context.Students.FirstOrDefault(), TeachSubj = _context.TeachSubjs.FirstOrDefault()
     };
     model2 = new Mark {
         MarkStud = 2, Student = _context.Students.FirstOrDefault(), TeachSubj = _context.TeachSubjs.FirstOrDefault()
     };
 }
        private void AddMarkButton_Click(object sender, EventArgs e)
        {
            int     mark        = int.Parse(MarkComboBox.SelectedItem.ToString());
            Student student     = CurrentStudent();
            int     studentId   = StudentRepository.GetIdByJmbg(student.Jmbg);
            int     courseId    = CoursesRepository.GetIdByTitle(GetCurrentCourse());
            bool    isMarkAdded = MarksRepository.InsertMark(mark, studentId, courseId);

            if (isMarkAdded)
            {
                FillStudentMarks();
            }
        }
Example #8
0
 public WorksService(
     WorksRepository worksRepository,
     MarksRepository marksRepository,
     WorkTypesRepository workTypesRepository,
     PersonsRepository personsRepository,
     IMemoryCache memoryCache)
 {
     _worksRepository     = worksRepository;
     _marksRepository     = marksRepository;
     _workTypesRepository = workTypesRepository;
     _personsRepository   = personsRepository;
     _memoryCache         = memoryCache;
 }
Example #9
0
 static Unit()
 {
     _context = new MyAppDbContext("MyAppConnStr");
     DepartmentsRepository  = new DepartmentsRepository(_context);
     TeachersRepository     = new TeachersRepository(_context);
     SubjectsRepository     = new SubjectsRepository(_context);
     SpecialitiesRepository = new SpecialitiesRepository(_context);
     GroupsRepository       = new GroupsRepository(_context);
     PhonesRepository       = new PhonesRepository(_context);
     StudentsRepository     = new StudentsRepository(_context);
     AudiencesRepository    = new AudiencesRepository(_context);
     AudLectRepository      = new AudLectRepository(_context);
     LectionsRepository     = new LectionsRepository(_context);
     MarksRepository        = new MarksRepository(_context);
     TeachSubjRepository    = new TeachSubjRepository(_context);
 }
Example #10
0
        public void AllItemsTest()
        {
            var repo = new MarksRepository(_context);

            Assert.AreEqual(_context.Marks.Count(), repo.AllItems.Count());
            var item1 = new Mark
            {
                Student      = _context.Students.FirstOrDefault(),
                TeachSubj    = _context.TeachSubjs.FirstOrDefault(),
                StudentsMark = 55
            };

            repo.AddItem(item1);
            Assert.AreEqual(_context.Marks.Count(), repo.AllItems.Count());
            _context.Marks.Remove(item1);
        }
Example #11
0
 static Unit()
 {
     _context                  = new MyAppDbContext("MyAppConnStr");
     AddressesRepository       = new AddressesRepository(_context);
     ClassroomsRepository      = new ClassroomsRepository(_context);
     DepartmentsRepository     = new DepartmentsRepository(_context);
     GroupsRepository          = new GroupsRepository(_context);
     GroupTimetablesRepository = new GroupTimetablesRepository(_context);
     MarksRepository           = new MarksRepository(_context);
     PairTimetablesRepository  = new PairTimetablesRepository(_context);
     PhonesRepository          = new PhonesRepository(_context);
     SpecialitiesRepository    = new SpecialitiesRepository(_context);
     StudentsRepository        = new StudentsRepository(_context);
     SubjectsRepository        = new SubjectsRepository(_context);
     TeachSubjsRepository      = new TeachSubjsRepository(_context);
     TeachersRepository        = new TeachersRepository(_context);
     TimetablesRepository      = new TimetablesRepository(_context);
 }
Example #12
0
 private void FillStudentMarks()
 {
     try
     {
         Student student   = CurrentStudent();
         int     studentId = StudentRepository.GetIdByJmbg(student.Jmbg);
         int     courseId  = CoursesRepository.GetIdByTitle(GetCurrentCourse());
         string  marks     = MarksRepository.GetMarks(studentId, courseId);
         MarksLabel.Text = marks;
         string[] parts = marks.Split(',');
         if (parts.Length > 0)
         {
             AverageMarkLabel.Text = CalculateAverageGrade(parts);
         }
     }
     catch (Exception e)
     {
         MessageBox.Show(e.Message);
     }
 }
Example #13
0
        public void AddItemTest()
        {
            var repo = new MarksRepository(_context);
            var item = new Mark
            {
                Student      = _context.Students.FirstOrDefault(),
                TeachSubj    = _context.TeachSubjs.FirstOrDefault(),
                StudentsMark = 55
            };

            repo.AddItem(item);
            var newitem = _context.Marks.FirstOrDefault(x => x.Student.Id == item.Student.Id &&
                                                        x.TeachSubj.Id == item.TeachSubj.Id &&
                                                        x.StudentsMark == item.StudentsMark);

            Assert.AreEqual(item.Student.Id, newitem.Student.Id);
            Assert.AreEqual(item.StudentsMark, newitem.StudentsMark);
            Assert.AreEqual(item.TeachSubj.TeacherId, newitem.TeachSubj.TeacherId);
            Assert.AreEqual(item.TeachSubj.SubjId, newitem.TeachSubj.SubjId);
            _context.Marks.Remove(item);
        }
Example #14
0
        public void AddItemsTest()
        {
            var repo  = new MarksRepository(_context);
            var item1 = new Mark
            {
                Student      = _context.Students.FirstOrDefault(),
                TeachSubj    = _context.TeachSubjs.FirstOrDefault(x => x.Subject.Id == 1),
                StudentsMark = 55
            };
            var item2 = new Mark
            {
                Student      = _context.Students.FirstOrDefault(),
                TeachSubj    = _context.TeachSubjs.FirstOrDefault(x => x.Subject.Id == 2),
                StudentsMark = 55
            };

            Mark[] items = new Mark[] { item1, item2 };

            repo.AddItems(items);
            var newitem1 = _context.Marks.FirstOrDefault(x => x.Student.Id == item1.Student.Id &&
                                                         x.TeachSubj.Id == item1.TeachSubj.Id &&
                                                         x.StudentsMark == item1.StudentsMark);
            var newitem2 = _context.Marks.FirstOrDefault(x => x.Student.Id == item2.Student.Id &&
                                                         x.TeachSubj.Id == item2.TeachSubj.Id &&
                                                         x.StudentsMark == item2.StudentsMark);

            Assert.AreEqual(items[0].StudentsMark, newitem1.StudentsMark);
            Assert.AreEqual(items[0].Student.Id, newitem1.Student.Id);
            Assert.AreEqual(items[0].TeachSubj.TeacherId, newitem1.TeachSubj.TeacherId);
            Assert.AreEqual(items[0].TeachSubj.SubjId, newitem1.TeachSubj.SubjId);
            Assert.AreEqual(items[1].StudentsMark, newitem2.StudentsMark);
            Assert.AreEqual(items[1].Student.Id, newitem2.Student.Id);
            Assert.AreEqual(items[1].TeachSubj.TeacherId, newitem2.TeachSubj.TeacherId);
            Assert.AreEqual(items[1].TeachSubj.SubjId, newitem2.TeachSubj.SubjId);
            _context.Marks.Remove(item1);
            _context.Marks.Remove(item2);
        }
Example #15
0
 public void GetItemExceptionTest()
 {
     var repo  = new MarksRepository(_context);
     var item1 = repo.GetItem(-1).StudentsMark;
 }
Example #16
0
 public MarksController()
 {
     dbContext = new StudentsEntities();
     this.repository = new MarksRepository(dbContext);
 }
Example #17
0
        private void PrintStatisticTeacherRoundedButton_Click(object sender, EventArgs e)
        {
            int       columnNumber = 6;
            PdfPTable table        = new PdfPTable(columnNumber)
            {
                //actual width of table in points
                TotalWidth = 400f,
                //fix the absolute width of the table
                LockedWidth = true
            };

            //relative col widths in proportions - 1/3 and 2/3
            float[] widths = new float[] { 1f, 1f, 1f, 1f, 1f, 1f };
            table.SetWidths(widths);
            table.HorizontalAlignment = 0;
            //leave a gap before and after the table
            table.SpacingBefore = 20f;
            table.SpacingAfter  = 30f;
            PdfPCell cell = new PdfPCell(new Phrase("Ucenici"))
            {
                Colspan             = columnNumber,
                Border              = 0,
                HorizontalAlignment = 1
            };

            table.AddCell(cell);

            table.AddCell("Ime");
            table.AddCell("Prezime");
            table.AddCell("Odsustva(U)");
            table.AddCell("Odsustva(O)");
            table.AddCell("Odsustva(N)");
            table.AddCell("Prosjek");



            int    TeacherId     = CurrentTeacher.Id;
            int    DepartmentId  = DepartmentsRepository.GetIdByTeacherId(TeacherId);
            string StudentsQuery = StudentRepository.GetQuery(DepartmentId);

            SqlCeCommand    cmd    = new SqlCeCommand(StudentsQuery, Connection);
            SqlCeDataReader reader = cmd.ExecuteReader();


            try
            {
                while (reader.Read())
                {
                    int justifiedAbsents   = AbsentsRepository.GetAbsents((int)reader["Id"], 1);
                    int unJustifiedAbsents = AbsentsRepository.GetAbsents((int)reader["Id"], 0);
                    int sum = justifiedAbsents + unJustifiedAbsents;

                    string   CoursesId = CoursesRepository.GetCoursesId();
                    string[] parts     = CoursesId.Split(',');
                    int      suum      = 0;
                    for (int i = 0; i < parts.Length; i++)
                    {
                        string   marks     = MarksRepository.GetMarks((int)reader["Id"]);
                        string[] particles = marks.Split(',');
                        double   mark      = Math.Round(float.Parse(CalculateAverageGrade(particles)), MidpointRounding.AwayFromZero);

                        suum += (int)mark;
                    }

                    float average = suum / (parts.Length);

                    string averageMark = average.ToString("0.00") + "(" + Math.Round(average, MidpointRounding.AwayFromZero) + ")";

                    table.AddCell(reader["Name"].ToString());
                    table.AddCell(reader["Surname"].ToString());
                    table.AddCell(sum.ToString());
                    table.AddCell(justifiedAbsents.ToString());
                    table.AddCell(unJustifiedAbsents.ToString());
                    table.AddCell(averageMark);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            LoginForm logf = new LoginForm();
            string    Dir  = logf.GetHomeDirectory();

            FileStream fs = new FileStream("report.pdf", FileMode.Create);

            Document  doc       = new Document(PageSize.A4);
            PdfWriter pdfWriter = PdfWriter.GetInstance(doc, fs);

            doc.Open();
            doc.Add(table);
            while (reader.Read())
            {
                doc.Add(new Paragraph(reader[0].ToString() + reader[1].ToString() + reader[2].ToString()));
            }

            pdfWriter.CloseStream = true;
            doc.Close();


            Process.Start("report.pdf");
        }
Example #18
0
 public MarksController(MarksRepository marksRepository, CourseRepository courseRepository, StudentRepository studentRepository)
 {
     this.marksRepository   = marksRepository;
     this.courseRepository  = courseRepository;
     this.studentRepository = studentRepository;
 }
Example #19
0
 public MarkService()
 {
     _database       = new SchoolContext();
     _markRepository = new MarksRepository(new SchoolContext());
 }
 public StudentMarkManagement()
 {
     repository = new MarksRepository();
 }