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); }
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); }
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); }
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); }
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); }
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); }