示例#1
0
 public ViewResult RsvpForm(GuestResponsecs guestResponsecs)
 {
     //Todo: store response from guest
     if (ModelState.IsValid)
     {
         Repository.AddResponse(guestResponsecs);
         var AllClasses = new List <ClassesModel>
         {
             new ClassesModel("physical_database_design_&_opt", "Fall", 5),
             new ClassesModel("comp_system_principles_2", "Fall", 3),
             new ClassesModel("fund_of_software_engineerring", "Spring", 3),
             new ClassesModel("data_structures_and_algorithms", "Spring", 5),
             new ClassesModel("security_in_computing", "Winter", 3),
             new ClassesModel("sw_architecture_and_design_1", "Winter", 3)
         };
         var viewModel = new StudentClassesViewModel
         {
             Student          = guestResponsecs,
             ClassesAvailable = AllClasses
         };
         return(View("Thanks", viewModel));
     }
     else
     {
         //there is a validation error
         return(View());
     }
 }
        public async Task <StudentClassesViewModel> GetAllClasses(string user)
        {
            var classes = await _db.Classes.ToListAsync();

            var student = await _db.Students.FirstOrDefaultAsync(x => x.Mail == user);

            var studentClassesViewModel = new StudentClassesViewModel
            {
                StudentClasses = classes,
                Student        = student
            };

            return(studentClassesViewModel);
        }
示例#3
0
        //GET: Students/StudentClasses/5
        //Use the StudentClassesViewModel to create a view for the Student's classes
        public async Task <IActionResult> StudentClasses(int id)
        {
            string           connectionString = @"Data Source=/Users/toby/g45/capstone/bin/Debug/netcoreapp1.1/findAMentor.db;";
            SqliteConnection conn;



            List <StudentClassesViewModel> modelList = new List <StudentClassesViewModel>();

            string sql = "select sub.ID subjectID, sub.name, sub.category,  studSubs.studentID, studSubs.status, " +
                         "stud.first_name, stud.last_name, stud.email, stud.phone " +
                         "from subject sub " +
                         "inner join studentSubjects studSubs " +
                         "on sub.ID = studSubs.subjectID " +
                         "inner join Student stud " +
                         "on stud.ID = studSubs.studentID " +
                         "where stud.ID = " + id;

            try
            {
                conn = new SqliteConnection(connectionString);
                conn.Open();
                SqliteCommand    command = new SqliteCommand(sql, conn);
                SqliteDataReader reader  = command.ExecuteReader();


                while (reader.Read())
                {
                    StudentClassesViewModel scvm = new StudentClassesViewModel();
                    //student = MapStudent(reader, student);
                    scvm.first_name = reader["first_name"].ToString();
                    scvm.last_name  = reader["last_name"].ToString();
                    scvm.category   = reader["category"].ToString();
                    scvm.name       = reader["name"].ToString();
                    scvm.status     = reader["status"].ToString();

                    ViewBag.studentName = scvm.first_name;

                    modelList.Add(scvm);
                }
                ViewBag.Categories = new SelectList(GetCategories(conn));
                command.Dispose();
            }
            catch (Exception e)
            {
                Console.WriteLine("Exception = " + e.Message);
            }
            return(View(modelList));
        }
示例#4
0
        public ActionResult Classes()
        {
            UnitOfWork uow = new UnitOfWork();
            //List<StudentClasses> sc = uow.StudentRepository.GetClasses(Session["UserId"].ToString(), (int)ClassJoinStatus.Approved);
            List <StudentClasses>   sc    = uow.StudentRepository.GetClasses(Session["UserId"].ToString());
            StudentClassesViewModel model = new StudentClassesViewModel();

            //model.Pending = sc.Where(e => e.ClassDate > DateTime.Now && (e.RequestStatus == (int)ClassJoinStatus.Pending || e.RequestStatus == (int)ClassJoinStatus.Rejected)).ToList();
            model.Pending   = sc.Where(e => (e.RequestStatus == (int)ClassJoinStatus.Pending || e.RequestStatus == (int)ClassJoinStatus.Invited || e.RequestStatus == (int)ClassJoinStatus.Rejected)).ToList();
            model.Upcoming  = sc.Where(e => e.ClassDate > DateTime.Now && (e.RequestStatus == (int)ClassStatus.Approved || e.ClassStatus == (int)ClassStatus.OfferAccepted)).ToList();
            model.Past      = sc.Where(e => e.ClassDate < DateTime.Now && e.RequestStatus != (int)ClassJoinStatus.Rejected).ToList();
            model.Cancelled = sc.Where(e => e.ClassStatus == (int)ClassStatus.Cancelled).ToList();
            //model.Recorded = sc.Where(e => e.ClassDate < DateTime.Now && e.ClassStatus != (int)ClassStatus.Cancelled && e.Record == true).ToList();
            return(View(model));
        }
        public ActionResult Classes(int id)
        {
            var viewModel = new StudentClassesViewModel(id);

            return(View(viewModel));
        }