public static void UpdateCoursetracInformtion(clsCourseTrac CourseTrac)
{
string connectionString = DataManager.OraConnString();
string updateQuery = @"UPDATE [CourseTrac]
SET [TracId] = '" + CourseTrac.CourseTracId + "' WHERE [TracName] ='" + CourseTrac.CourseTraceName + "'";
DataManager.ExecuteNonQuery(connectionString, updateQuery);
}
public static void DeleteCourseTracInformtion(clsCourseTrac CourseTrac)
{
string connectionString = DataManager.OraConnString();
string deleteQuery = @"DELETE FROM [CourseTrac]
WHERE id='" + CourseTrac.ID + "' ";
DataManager.ExecuteNonQuery(connectionString, deleteQuery);
}
public void SaveCourseTracInformtion(clsCourseTrac Trac)
{
string connectionString = DataManager.OraConnString();
string insertQuery = @"INSERT INTO [CourseTrac]
([TracId] ,[TracName])
VALUES('" + Trac.CourseTracId + "','" + Trac.CourseTraceName + "')";
DataManager.ExecuteNonQuery(connectionString, insertQuery);
}
