Esempio n. 1
0
        public void DeleteStudent()
        {
            int idToBeDeleted = idInput("of the student to be deleted");


            using (StudentiEntities studentiEntities = new StudentiEntities())
            {
                Studenti studentToBeDeleted = studentiEntities.Studenti.FirstOrDefault(s => s.Id == idToBeDeleted);

                if (studentToBeDeleted != null)
                {
                    IEnumerable <Predmeti> predmetis =
                        from Predmeti in studentiEntities.Predmeti
                        select Predmeti;

                    foreach (Predmeti predmet in predmetis)
                    {
                        if (predmet.Studenti.Contains(studentToBeDeleted))
                        {
                            predmet.Studenti.Remove(studentToBeDeleted);
                        }
                    }
                    studentiEntities.Studenti.Remove(studentToBeDeleted);
                    studentiEntities.SaveChanges();
                }
                else if (studentToBeDeleted == null)
                {
                    Console.WriteLine("Student with given id does not exist!");
                }
            }
        }
Esempio n. 2
0
        public void updateStudentInfo()
        {
            int    idToBeUpdated = idInput("of the student to be updated");
            string firstNameUpdated, LastNameUpdated;


            using (StudentiEntities studentiEntities = new StudentiEntities())
            {
                Studenti studentToBeUpdated = studentiEntities.Studenti.FirstOrDefault(s => s.Id == idToBeUpdated);

                if (studentToBeUpdated != null)
                {
                    Console.WriteLine("Please insert the student's new name");
                    firstNameUpdated = Console.ReadLine().Trim();
                    Console.WriteLine("Please insert the student's new last name");
                    LastNameUpdated = Console.ReadLine().Trim();

                    studentToBeUpdated.Ime     = firstNameUpdated;
                    studentToBeUpdated.Prezime = LastNameUpdated;

                    studentiEntities.SaveChanges();
                }
                else if (studentToBeUpdated == null)
                {
                    Console.WriteLine("Student with given id does not exist!");
                }
            }
        }
Esempio n. 3
0
        public void updateStudentCourses()
        {
            int    studentId, subjectId;
            string addOrRemoveCourses;

            studentId = idInput("of the student to be updated");


            while (true)
            {
                Console.WriteLine("Enter 1 to remove courses, enter 2 to add courses");
                addOrRemoveCourses = Console.ReadLine().Trim();

                if (addOrRemoveCourses == "1" || addOrRemoveCourses == "2")
                {
                    break;
                }
            }
            subjectId = idInput("of the subject");


            using (StudentiEntities studentiEntities = new StudentiEntities())
            {
                bool idExists = false;

                Studenti studentToBeUpdated        = studentiEntities.Studenti.FirstOrDefault(s => s.Id == studentId);
                Predmeti subjectToBeAddedOrRemoved = studentiEntities.Predmeti.FirstOrDefault(p => p.Id == subjectId);

                if (studentToBeUpdated != null && subjectToBeAddedOrRemoved != null)
                {
                    idExists = true;
                }

                if (addOrRemoveCourses == "1" && idExists)
                {
                    studentToBeUpdated.Predmeti.Remove(subjectToBeAddedOrRemoved);
                    subjectToBeAddedOrRemoved.Studenti.Remove(studentToBeUpdated);
                    studentiEntities.SaveChanges();
                }
                else if (addOrRemoveCourses == "2" && idExists)
                {
                    studentToBeUpdated.Predmeti.Add(subjectToBeAddedOrRemoved);
                    subjectToBeAddedOrRemoved.Studenti.Add(studentToBeUpdated);
                    studentiEntities.SaveChanges();
                }

                if (!idExists)
                {
                    Console.WriteLine("Invalid IDs!");
                }
            }
        }
Esempio n. 4
0
        public void AddNewStudent()
        {
            Studenti newStudent = new Studenti();

            Console.WriteLine("Please insert the new student's name");
            newStudent.Ime = Console.ReadLine().Trim();
            Console.WriteLine("Please insert the new student's last name");
            newStudent.Prezime = Console.ReadLine().Trim();

            using (StudentiEntities studentiEntities = new StudentiEntities())
            {
                studentiEntities.Studenti.Add(newStudent);
                studentiEntities.SaveChanges();
            }
        }