コード例 #1
0
        public ActionResult registerUser(string firstName,
                                         string lastName,
                                         string nickName,
                                         string dateOfBirth,
                                         string role,
                                         string userName,
                                         string password)
        {
            int valid = 1;
            var Jcon = new JsonContainer();
            var objUserAccountHelper = new UserAccountHelper();

            if (objUserAccountHelper.VerifyUserName(userName))
            {
                Jcon.Result = -1;
                return Json(Jcon);
            }

            DateTime date;

            if (!DateTime.TryParse(dateOfBirth, out date))
            {
                Jcon.Result = 0;
                return Json(Jcon);
            }

            var userDetails = new UserAccount
            {
                firstName = firstName,
                lastName = lastName,
                nickName = nickName,
                dateOfBirth = date,
                role = role,
                userName = userName,
                password = password
            };

            try
            {
                objUserAccountHelper.InsertUserDetails(userDetails);
            }
            catch (Exception ex)
            {
                valid = 0;
            }

            Jcon.Result = valid;
            return Json(Jcon);
        }
コード例 #2
0
        public ActionResult mainLogin(string loginName, string loginPassword)
        {
            var Jcon = new JsonContainer();
            var objUserAccountHelper = new UserAccountHelper();
            var dt = objUserAccountHelper.SelectUserByLoginDetails(loginName, loginPassword);

            if (dt.Rows.Count <= 0)
            {
                Jcon.Result = -1;
                return Json(Jcon);
            }

            Session["userId"] = long.Parse(dt.Rows[0]["userId"].ToString());

            Jcon.Result = 1;
            return Json(Jcon);
        }
コード例 #3
0
        public ActionResult updateUserDetails(string firstName,
                                        string lastName,
                                        string nickName,
                                        string dateOfBirth)
        {
            int valid = 1;
            var Jcon = new JsonContainer();
            var objUserAccountHelper = new UserAccountHelper();

            DateTime date;

            if (!DateTime.TryParse(dateOfBirth, out date))
            {
                Jcon.Result = 0;
                return Json(Jcon);
            }

            var userDetails = new UserAccount
            {
                userId = long.Parse(Session["userId"].ToString()),
                firstName = firstName,
                lastName = lastName,
                nickName = nickName,
                dateOfBirth = date
            };

            try
            {
                objUserAccountHelper.UpdateUserDetails(userDetails);
            }
            catch (Exception ex)
            {
                valid = 0;
            }

            Jcon.Result = valid;
            return Json(Jcon);
        }
コード例 #4
0
        public ActionResult loadCourses(string courseName)
        {
            var Jcon = new JsonContainer();
            var objCourseHelper = new CourseHelper();

            var courseDetails = new Course
            {
                userId = 0,
                courseName = string.Empty,
                startTime = string.Empty,
                endTime = string.Empty
            };

            var dtCourse = objCourseHelper.SearchCourse(courseDetails);
            List<Course> courseList = new List<Course>();

            foreach (DataRow dr in dtCourse.Rows)
            {
                Course course = new Course { courseName = dr["courseName"].ToString() };
                courseList.Add(course);
            }

            Jcon.Result = courseList.Distinct().OrderBy(x => x.courseName).ToList();
            return Json(Jcon);
        }
コード例 #5
0
        public ActionResult addCourse(string courseName,
                                         string courseDesc,
                                         string courseCategory,
                                         string startTime,
                                         string endTime,
                                         long noOfStudents)
        {
            int valid = 1;
            var Jcon = new JsonContainer();
            var objCourseHelper = new CourseHelper();

            var courseDetails = new Course
            {
                userId = long.Parse(Session["userId"].ToString()),
                courseName = string.Empty,
                startTime = string.Empty,
                endTime = string.Empty
            };

            try
            {
                var dtCourse = objCourseHelper.SearchCourse(courseDetails);

                courseDetails.courseName = courseName;
                courseDetails.courseDescription = courseDesc;
                courseDetails.courseCategory = courseCategory;
                courseDetails.startTime = startTime;
                courseDetails.endTime = endTime;
                courseDetails.numberOfStudent = noOfStudents;

                if (dtCourse.Rows.Count <= 0)
                    objCourseHelper.InsertCourse(courseDetails);
                else
                {
                    var isValid = true;
                    var dummyStartTime = DateTime.Parse(startTime);
                    var dummyEndTime = DateTime.Parse(endTime);

                    //check condition for valid timing
                    foreach(DataRow row in dtCourse.Rows)
                    {
                        var rowStartTime = DateTime.Parse(row["startTime"].ToString());
                        var rowEndTime = DateTime.Parse(row["endTime"].ToString());

                        if (dummyStartTime < rowStartTime && dummyEndTime > rowEndTime)
                            isValid = false;
                        else if (dummyStartTime > rowStartTime && dummyStartTime < rowEndTime)
                            isValid = false;
                        else if (dummyEndTime > rowStartTime && dummyEndTime < rowEndTime)
                            isValid = false;

                        if (!isValid)
                        {
                            Jcon.Result = -1;
                            return Json(Jcon);
                        }
                    }

                    if (isValid)
                        objCourseHelper.InsertCourse(courseDetails);
                }
            }
            catch (Exception ex)
            {
                valid = 0;
            }

            Jcon.Result = valid;
            return Json(Jcon);
        }
コード例 #6
0
        public ActionResult searchResults(string courseName, string courseTiming)
        {
            string startTime = string.Empty, endTime = string.Empty;

            courseName = string.IsNullOrEmpty(courseName) ? "-SELECT-" : courseName;
            courseTiming = string.IsNullOrEmpty(courseTiming) ? "-SELECT-" : courseTiming;

            if (courseName.ToUpper() == "-SELECT-")
                courseName = string.Empty;

            if (courseTiming.ToUpper() == "-SELECT-")
                courseTiming = string.Empty;
            else
            {
                var substrings = courseTiming.Split('-');
                startTime = substrings[0].Trim(' ');
                endTime = substrings[1].Trim(' ');
            }

            var Jcon = new JsonContainer();
            var objCourseHelper = new CourseHelper();

            var courseDetails = new Course
            {
                userId = 0,
                courseName = courseName,
                startTime = startTime,
                endTime = endTime
            };

            var dtCourse = objCourseHelper.SearchCourse(courseDetails);
            List<Course> courseList = new List<Course>();

            foreach (DataRow dr in dtCourse.Rows)
            {
                var course = new Course
                {
                    courseName = dr["courseName"].ToString(),
                    courseDescription = dr["courseDescription"].ToString(),
                    courseCategory = dr["courseCategory"].ToString(),
                    startTime = dr["startTime"].ToString(),
                    endTime = dr["endTime"].ToString(),
                    numberOfStudent = long.Parse(dr["numberOfStudent"].ToString()),
                    instructorName = dr["instructorName"].ToString()

                };
                courseList.Add(course);
            }

            Jcon.Result = courseList.Distinct().OrderBy(x => x.courseName).ToList();
            return Json(Jcon);
        }