Ejemplo n.º 1
0
        public ActionResult ShowStudents(string cid)
        {
            // cid = "1";
            //string cid = "1";
            LearnDal         learnDal   = new LearnDal();
            StudentDal       studentDal = new StudentDal();
            StudentViewModel viewModel  = new StudentViewModel();
            List <string>    usernames  = new List <string>();

            foreach (Learn learn in learnDal.learns)
            {
                if (learn.cid.Equals(cid))
                {
                    usernames.Add(learn.Susername);
                }
            }

            viewModel.students = new List <Student>();
            foreach (Student student in studentDal.Dalstudents)
            {
                if (usernames.Contains(student.username))
                {
                    viewModel.students.Add(student);
                }
            }
            return(View(viewModel.students));
        }
Ejemplo n.º 2
0
        // GET: Lecturer
        public ActionResult ShowSchedule()
        {
            // Session["username"] = "******";
            ScheduleDal       sheduleDal        = new ScheduleDal();
            LearnDal          learnDal          = new LearnDal();
            CourseDal         courseDal         = new CourseDal();
            ScheduleViewModel scheduleViewModel = new ScheduleViewModel();

            scheduleViewModel.learns  = new List <Learn>();
            scheduleViewModel.courses = new List <Course>();

            List <string> shids = new List <string>();
            List <string> cids  = new List <string>();

            foreach (Course course in courseDal.courses.ToList <Course>())
            {
                if (course.Lecturer.Equals(Session["username"].ToString()))
                {
                    cids.Add(course.cid);
                    scheduleViewModel.courses.Add(course);
                }
            }



            foreach (Learn learn in learnDal.learns.ToList <Learn>())
            {
                if (cids.Contains(learn.cid))
                {
                    shids.Add(learn.shid);
                    scheduleViewModel.learns.Add(learn);
                }
            }

            scheduleViewModel.schedules = new List <Shedule>();
            foreach (Shedule shedule in sheduleDal.schedules.ToList <Shedule>())
            {
                if (shids.Contains(shedule.shid))
                {
                    scheduleViewModel.schedules.Add(shedule);
                }
            }
            List <ScheduleViewModel> models = new List <ScheduleViewModel>();
            ScheduleViewModel        model;

            for (int i = 0; i < scheduleViewModel.courses.Count && i < scheduleViewModel.learns.Count && i < scheduleViewModel.schedules.Count; i++)
            {
                model          = new ScheduleViewModel();
                model.schedule = scheduleViewModel.schedules.ElementAt(i);
                model.Learn    = scheduleViewModel.learns.ElementAt(i);
                model.course   = scheduleViewModel.courses.ElementAt(i);
                models.Add(model);
            }
            return(View(models));
        }
Ejemplo n.º 3
0
        public ActionResult add()
        {
            string username = Request.Form["username"];
            string cid      = Request.Form["cid"];

            if (ModelState.IsValid)
            {
                CourseDal c      = new CourseDal();
                Course    course = c.courses.Find(cid);

                StudentDal s = new StudentDal();

                Student student = s.Dalstudents.Find(username);

                if (student == null)
                {
                    ModelState.AddModelError(string.Empty, "Student Name not exists.");
                    return(View("addStudent"));
                }
                if (course == null)
                {
                    ModelState.AddModelError(string.Empty, "Course cid not exists.");
                    return(View("addStudent"));
                }

                LearnDal learn = new LearnDal();
                Learn    l     = new Learn();
                l.cid       = course.cid;
                l.Susername = student.username;
                l.shid      = course.shid;
                learn.learns.Add(l);
                try
                {
                    learn.SaveChanges();
                }
                catch (Exception)
                {
                    ModelState.AddModelError(string.Empty, "this student already  not exists.");
                }
            }

            return(View("Homepage"));
        }
Ejemplo n.º 4
0
        public ActionResult ShowExams()
        {
            LearnDal  learnDal  = new LearnDal();
            CourseDal courseDal = new CourseDal();

            Session["username"] = "******";
            ScheduleViewModel scheduleViewModel = new ScheduleViewModel();

            scheduleViewModel.learns = new List <Learn>();
            foreach (Learn learn in learnDal.learns.ToList <Learn>())
            {
                if (learn.Susername.Equals(Session["username"]))
                {
                    scheduleViewModel.learns.Add(learn);
                }
            }
            List <string> cids = new List <string>();

            foreach (Learn learn in scheduleViewModel.learns)
            {
                if (!cids.Contains(learn.cid))
                {
                    cids.Add(learn.cid);
                }
            }

            //scheduleViewModel.schedules = sheduleDal.schedules.ToList<Shedule>();
            scheduleViewModel.courses = new List <Course>();
            foreach (Course course in courseDal.courses.ToList <Course>())
            {
                if (cids.Contains(course.cid))
                {
                    scheduleViewModel.courses.Add(course);
                }
            }


            return(View(scheduleViewModel.courses));
        }
Ejemplo n.º 5
0
        public ActionResult update()
        {
            //CourseDal c = new CourseDal();
            // StudentDal st = new StudentDal();
            LearnDal l = new LearnDal();

            Grade g = new Grade();

            g.cid      = Request.Form["cid"];
            g.username = Request.Form["username"];
            g.grade1   = Request.Form["grade"];


            string a1 = Request.Form["update"];

            if (a1 == null)
            {
                a1 = "i";
            }
            Gradedal     dal = new Gradedal();
            List <Grade> s   = dal.grade.ToList <Grade>();

            if (l.learns.Find(g.username, g.cid) == null)
            {
                ModelState.AddModelError(string.Empty, "Student Name not exists.");
                return(View("editGrade"));
            }



            if (a1.Equals("u"))
            {
                Grade a = dal.grade.Find(g.username, g.cid);
                if (a == null)
                {
                    ModelState.AddModelError(string.Empty, " this Student didnt have grade in this course to update.");
                    return(View("editGrade"));
                }

                a.grade1 = g.grade1;
                try
                {
                    dal.SaveChanges();
                }
                catch (SqlException)
                {
                    ModelState.AddModelError(string.Empty, "The Student have grade in this course you can do update.");
                }
            }


            if (a1.Equals("i"))
            {
                dal.grade.Add(g);
                dal.SaveChanges();
            }



            return(View("editGrade"));
        }