public Student Add(Student student)
 {
     string sqlQuery;
     if (student.Address != null)
     {
         var address = dbRepoAddress.Add(student.Address);
         student.Address = address;
         student.AddressId = address.Id;
     }
     sqlQuery = "INSERT INTO Student" +
                 "(FirstName, " +
                 "LastName, " +
                 "Email, " +
                 "CellPhone, " +
                 "HomePhone, " +
                 "AddressId, " +
                 "DateOfBirth) VALUES" +
                 "(@FirstName, " +
                 "@LastName, " +
                 "@Email, " +
                 "@CellPhone, " +
                 "@HomePhone, " +
                 "@AddressId, " +
                 "@DateOfBirth )" +
                 "SELECT CAST(SCOPE_IDENTITY() as int)";
     var userId = this._db.Query<int>(sqlQuery, student).Single();
     student.Id = userId;
     return student;
 }
        public async Task <IActionResult> Create([Bind("ID, Name, SpyAlias, CourseId")] StudentEnrollment.Models.Student student)
        {
            _context.Students.Add(student);
            await _context.SaveChangesAsync();

            return(RedirectToAction("Index", "Home"));
        }
Exemple #3
0
        public ActionResult TestApi(string function, string parameters, string proxyType)
        {
            if (Session["user"] == null)
            {
                return(RedirectToAction("Index", "Login", new { redirectAction = "TestApi", redirectController = "Home" }));
            }

            Models.Student    s  = new StudentEnrollment.Models.Student(1, "rs4296", "*****@*****.**", "Rob", "Stone", 5, float.Parse("3.5"));
            Models.Instructor i  = new StudentEnrollment.Models.Instructor(1, "gj888", "*****@*****.**", "Bob", "Smith");
            Models.Course     c1 = new StudentEnrollment.Models.Course(1, "SWEN-344", "Web Engineering", 3, 2, false);
            Models.Course     c2 = new StudentEnrollment.Models.Course(2, "CS-420", "Data Mining", 3, 3, false);
            Models.Course     c3 = new StudentEnrollment.Models.Course(3, "SWEN-261", "Intro to SE", 3, 1, false);
            Models.Course     c4 = new StudentEnrollment.Models.Course(4, "CS-262", "Engineering of Software Subsystems", 3, 1, false);
            List <StudentEnrollment.Models.Course> courses = new List <Models.Course> {
                c1, c2, c3, c4
            };

            ViewData["Function"]   = function;
            ViewData["Parameters"] = parameters;
            ViewData["ProxyType"]  = proxyType;
            IProxy p;

            if (proxyType == "Local")
            {
                p = new LocalProxy(new ServerPathData());
            }
            else
            {
                p = new APIProxy();
            }
            dynamic result = "The function returned void.";

            if (function != null)
            {
                try
                {
                    switch (function)
                    {
                    case "getStudent": result = p.getStudent(Int32.Parse(parameters)); break;

                    case "getInstructor": result = p.getInstructor(Int32.Parse(parameters)); break;

                    case "getAdmin": result = p.getAdmin(Int32.Parse(parameters)); break;

                    case "getCourse": result = p.getCourse(Int32.Parse(parameters)); break;

                    case "getCourseList": result = p.getCourseList(); break;

                    case "getSection": result = p.getSection(Int32.Parse(parameters)); break;

                    case "getCourseSections":
                        Course course = (Course)ModelFactory.createModelFromJson("course", parameters);
                        result = p.getCourseSections(course);
                        break;

                    case "getStudentSections":
                        Student student = (Student)ModelFactory.createModelFromJson("student", parameters);
                        result = p.getStudentSections(student);
                        break;

                    //result = p.getStudentSections((Student)Convert.ChangeType(parameters, typeof(Student))); break;
                    case "getSectionStudents":
                        Section section = (Section)ModelFactory.createModelFromJson("section", parameters);
                        result = p.getSectionStudents(section);
                        //result = p.getSectionStudents((Section)Convert.ChangeType(parameters, typeof(Section)));
                        break;

                    case "getInstructorSections":
                        Instructor instructor = (Instructor)ModelFactory.createModelFromJson("instructor", parameters);
                        result = p.getInstructorSections(instructor);
                        //result = p.getInstructorSections((Instructor)Convert.ChangeType(parameters, typeof(Instructor)));
                        break;

                    case "getBook": result = p.getBook(Int32.Parse(parameters)); break;

                    case "getSectionBooks":
                        section = (Section)ModelFactory.createModelFromJson("section", parameters);
                        result  = p.getSectionBooks(section);
                        //result = p.getSectionBooks((Section)Convert.ChangeType(parameters, typeof(Section)));
                        break;

                    case "getLocation": result = p.getLocation(Int32.Parse(parameters)); break;

                    case "getCurrentTerm": result = p.getCurrentTerm(); break;

                    case "getTerm": result = p.getTerm(parameters); break;

                    case "getTerms": result = p.getTerms(); break;

                    case "createTerm":
                        Term term = (Term)ModelFactory.createModelFromJson("term", parameters);
                        p.createTerm(term);
                        result = "Call the getTerms method for the result of this operation.";
                        break;

                    case "createCourse":
                        course = (Course)ModelFactory.createModelFromJson("course", parameters);
                        p.createCourse(course);
                        result = "Check the course list for the result of that operation.";
                        break;
                    }
                }
                catch (FormatException fex)
                {
                    ViewData["Result"] = "The input needs to be an integer.";
                    System.Diagnostics.Debug.WriteLine("Function: " + function + " Parameter: " + parameters + " " + fex);
                    return(View());
                }
                catch (InvalidCastException icex)
                {
                    ViewData["Result"] = "Your input was not properly formatted for that object type.";
                    System.Diagnostics.Debug.WriteLine("Function: " + function + " Parameter: " + parameters + " " + icex);
                    return(View());
                }
                catch (NotImplementedException niex)
                {
                    ViewData["Result"] = "This function is currently not implemented by this proxy.";
                    System.Diagnostics.Debug.WriteLine("Function: " + function + " Parameter: " + parameters + " " + niex);
                    return(View());
                }
                catch (Exception ex)
                {
                    ViewData["Result"] = "An unkown error occured.";
                    System.Diagnostics.Debug.WriteLine("Function: " + function + " Parameter: " + parameters + " " + ex);
                    return(View());
                }
            }
            if (result == null)
            {
                ViewData["Result"] = result;
                return(View());
            }

            // The function returned an object or a list of objects
            if (result.GetType().IsArray)
            {
                ViewData["Result"] = string.Join("\n", (object[])result);
            }
            else
            {
                var json = Newtonsoft.Json.JsonConvert.SerializeObject(result);
                ViewData["Result"] = json;
            }
            return(View());
        }
        public Student Update(Student student)
        {
            var address = dbRepoAddress.Find(student.AddressId);
            if (address != null)
                address = dbRepoAddress.Update(student.Address);
            else
                address = dbRepoAddress.Add(student.Address);

            student.Address = address;
            student.AddressId = address.Id;

            var sqlQuery =
                "UPDATE Student " +
                "SET FirstName = @FirstName, " +
                "    LastName  = @LastName, " +
                "    Email     = @Email, " +
                "    CellPhone = @CellPhone, " +
                "    HomePhone = @HomePhone, " +
                "    AddressId = @AddressId, " +
                "    DateOfBirth = @DateOfBirth " +
                "WHERE Id = @Id";
            this._db.Execute(sqlQuery, student);
            return student;
        }