Public Member Functions | |
PapaganDAO () | |
Static Public Member Functions | |
static OleDbConnection | connectToDB () |
static void | insertItemToDB (String name, String animationPath) |
static int | getInitialFromList (char initial) |
static string | getNameOfAWord (int itemid) |
static String | getAnimationPathOfAWord (int itemid) |
static ArrayList | getCategoryNames () |
static ArrayList | getCategoryListOfAWord (int id) |
static ArrayList | getPictureListOfAWord (int id) |
static ArrayList | getVideoListOfAWord (int id) |
static void | addPictureToItem (int itemid, string path) |
static void | addVideoToItem (int itemid, string path) |
static ArrayList | getWordByCategory (int categoryId) |
static WordDTO | getWordFromDB (int itemid) |
static void | deleteVideoFromItem (int itemid, string videoPath) |
static void | deleteCategoryFromItem (int itemid, int categoryid) |
static void | deletePictureFromItem (int itemid, string picturePath) |
static void | addCategoryToItem (int itemid, int categoryid) |
static ArrayList | getAllWords () |
static void | addCategoryToDB (string newc) |
static void | addAnimationToItem (int id, string path) |
static void | deleteWord (int id) |
Static Private Attributes | |
static string | connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+System.Windows.Forms.Application.StartupPath+"\\papagan.mdb;User Id=admin;Password=;" |
The class is a general abstraction of SQL queries which access the Papagan Database. This class provides reusability for SQL queries
|
Default Constructor.
|
|
Method that adds animation to an item.
|
|
Method that adds new category to database.
|
|
Method that adds category to an item.
|
|
Method that adds picture to an item.
|
|
Method that adds video to an item.
|
|
opens the connection to a database opens connection to the Papagan.mdb
|
|
Method that deletes the category from that item.
|
|
Method that deletes the picture from that item.
|
|
Method that deletes the video from that item.
|
|
Method that deletes the item.
|
|
Method that adds new category to database.
|
|
Retrieves the animation path of a word with the given id.
|
|
Returns the category list regarding to a word in the db.
|
|
Method that returns the list of categories.
|
|
This function gives the ID of a word, which starts with the desired initial letter.
|
|
Retrieves the name of the word with the given id.
|
|
Returns the picture list regarding to a word in the db.
|
|
Returns the video list regarding to a word in the db.
|
|
Method that fetches the words regarding to one category.
|
|
Method that retrieves the word from db.
|
|
Inserts an item to the dictionary with its animation path.
|
|
|