public bool CreateCourseSurveySchedule(SurveyCourseSchedule schedule) { try { return(_repository.CreateCourseSurveySchedule(schedule)); } catch (SqlException sqlEx) { throw new Exception(EnumUtils.GetStringValue(ErrorMessage.UserDefinedMessage), sqlEx); } catch (Exception ex) { throw new Exception(EnumUtils.GetStringValue(ErrorMessage.UserDefinedMessage), ex); } }
public bool CreateCourseSurveySchedule(SurveyCourseSchedule schedule) { StringBuilder querySelect = new StringBuilder(); querySelect.AppendFormat("SELECT COUNT(*) FROM SurveyCourseSchedule WHERE CourseNo = {0} AND [Session] = '{1}' ", schedule.CourseInfo.CourseNo, schedule.SessionInfo.SessionInfo); int?noOfRecords; noOfRecords = (int?)this.ExecuteScalar(CommandType.Text, querySelect.ToString()); if (noOfRecords.HasValue && noOfRecords.Value == 0) { StringBuilder queryInsert = new StringBuilder(); queryInsert.AppendFormat( "INSERT INTO SurveyCourseSchedule(CourseNo, Session, DaysToStart, DaysOpen, StudentStatusIds, QuestionGroupID,Active) ") .AppendFormat(" VALUES({0},'{1}',{2},{3},'{4}', {5},'{6}')", schedule.CourseInfo.CourseNo, schedule.SessionInfo.SessionInfo, schedule.DaysToOpen, schedule.DaysOpen, schedule.StudentStatusesString, schedule.QuestionGroupInfo.QuestionGroupID, schedule.Active?'Y':'N'); int rowsAffected = this.ExecuteNonQuery(CommandType.Text, queryInsert.ToString()); if (rowsAffected != 0) { return(true); } else { return(false); } } else { throw new Exception("There is already a survey against this Course ('" + schedule.CourseInfo.Code + "') and Session ('" + schedule.SessionInfo.SessionInfo + "')"); } }
public ActionResult CourseSurveySchedule(FormCollection collection) { int DaysToOpen = 0, DaysOpen = 0; int? CourseId = null, QuestionGroupId = null; char? Session = null; string StatusIdsString; bool Active = false; if (collection["Course"] != null) { CourseId = Convert.ToInt32(collection["Course"].ToString()); } else { prepareCourseSurveySchedualViewData("Course could not be empty"); return(View()); } if (collection["Session"] != null) { Session = Convert.ToChar(collection["Session"]); } else { prepareCourseSurveySchedualViewData("Session could not be empty"); return(View()); } int.TryParse(collection["DaysToOpen"], out DaysToOpen); int.TryParse(collection["DaysOpen"], out DaysOpen); StatusIdsString = collection["inputSelectStudentStatuses"] as string; if (collection["Question Group"] != null) { QuestionGroupId = Convert.ToInt32(collection["Question Group"]); } if (collection["chkBoxActive"] != null && collection["chkBoxActive"].ToString().Contains("true")) { Active = true; } SurveyCourseSchedule scs = new SurveyCourseSchedule() { CourseInfo = new Course() { CourseNo = CourseId }, SessionInfo = new Session() { SessionInfo = Session + "" }, DaysToOpen = DaysToOpen, DaysOpen = DaysOpen, StudentStatusesString = StatusIdsString, QuestionGroupInfo = new QuestionGroup() { QuestionGroupID = QuestionGroupId.Value }, Active = Active }; try { service.CreateCourseSurveySchedule(scs); prepareCourseSurveySchedualViewData("Saved Successfully"); return(View()); } catch (Exception error) { prepareCourseSurveySchedualViewData(error.Message); return(View()); } }