public Boolean DeletePrerequisite(PrerequisiteVO inPrerequisite)
{
/* try
* {
* DBConnection.conn.Open();
* String query = "DELETE FROM dbo.Prerequisite where CourseCode=@CourseCode";
* SqlCommand cmd = new SqlCommand(query, DBConnection.conn);
* cmd.Parameters.AddWithValue("@CourseCode", inPrerequisite.CourseCode);
* cmd.ExecuteNonQuery();
* }
* catch (SqlException e)
* {
* ExceptionUtility.LogException(e, "Error Page");
* }
* catch (Exception e)
* {
* ExceptionUtility.LogException(e, "Error Page");
* }
* finally
* {
* if (DBConnection.conn != null)
* {
* DBConnection.conn.Close();
* }
* }*/
return(true);
}
public Boolean AddPrerequisite(PrerequisiteVO inPrerequisite)
{
/* try
* {
* DBConnection.conn.Open();
* String query = "INSERT INTO dbo.Prerequisite (CourseCode, PrerequisiteCode) VALUES (@CourseCode,@PrequisiteCode)";
* SqlCommand cmd = new SqlCommand(query, DBConnection.conn);
* cmd.Parameters.AddWithValue("@CourseCode", inPrerequisite.courseCode);
* cmd.Parameters.AddWithValue("@PrequisiteCode", inPrerequisite.prerequisiteCode);
* // Add other parameters here
* cmd.ExecuteNonQuery();
* }
* catch (SqlException e)
* {
* ExceptionUtility.LogException(e, "Error Page");
* }
* catch (Exception e)
* {
* ExceptionUtility.LogException(e, "Error Page");
* }
* finally
* {
* if (DBConnection.conn != null)
* {
* DBConnection.conn.Close();
* }
* }*/
return(true);
}
public Boolean DeletePrerequisite(PrerequisiteVO inPrerequisite)
{
Boolean prerequisiteCode = false;
try
{
prerequisiteCode = prerequisiteDao.DeletePrerequisite(inPrerequisite);
}
catch (CustomException e)
{
throw e;
}
return(true);
}
public Boolean UpdatePrerequisite(PrerequisiteVO inPrerequisite)
{
// Add business validations if any
Boolean prerequisiteCode = false;
try{
prerequisiteCode = prerequisiteDao.UpdatePrerequisite(inPrerequisite);
}
catch (CustomException e)
{
throw e;
}
return(true);
}
