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