// get language ID based on language name
public static int GetLID(string languageName)
{
int lID = -1;
MediaDataSet.TabLanguageDataTable tabLanguageDataTable = new MediaDataSet.TabLanguageDataTable();
TabLanguageTableAdapter tabLanguageTableAdapter = new TabLanguageTableAdapter();
try
{
// retrieve data from database
tabLanguageTableAdapter.SelectLanguage(tabLanguageDataTable, languageName);
// convert data into int
lID = (int)tabLanguageDataTable.Rows[0]["LID"];
}
catch (IndexOutOfRangeException e)
{
Console.WriteLine(languageName + " cannot be found in the database.");
Console.WriteLine(e.Message);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(lID);
}
public List <Language> getLanguage()
{
List <Language> languages = new List <Language>();
var languageTable = new UserData.TabLanguageDataTable();
var languageAdapter = new TabLanguageTableAdapter();
int rowCount = languageAdapter.getLanguage(languageTable);
if (rowCount > 0)
{
foreach (DataRow dr in languageTable)
{
Language lan = new Language();
lan.LID = int.Parse(dr["LID"].ToString());
lan.LanguageName = dr["LanguageName"].ToString();
languages.Add(lan);
}
}
return(languages);
}
/// <summary>
/// Class Constructor
/// </summary>
public MasterDAO()
{
_masterDataSet = new MasterDS();
_tabAuthorTableAdapter = new TabAuthorTableAdapter();
_tabCategoryTableAdapter = new TabCategoryTableAdapter();
_tabLanguageTableAdapter = new TabLanguageTableAdapter();
}
public MediaDAO()
{
mediaDataSet = new MediaDS();
tabMediaAdapter = new TabMediaTableAdapter();
viewMediaTableAdapter = new ViewMediaTableAdapter();
tabGenreTableAdapter = new TabGenreTableAdapter();
tabLanguageTableAdapter = new TabLanguageTableAdapter();
tabDirectorTableAdapter = new TabDirectorTableAdapter();
}
public MediaDAO()
{
mediaDataSet = new MediaDS();
viewMediaAdapter = new ViewMediaTableAdapter();
languageTableAdapter = new TabLanguageTableAdapter();
genreTableAdapter = new TabGenreTableAdapter();
tabMediaTableAdapter = new TabMediaTableAdapter();
borrowTableAdapter = new TabBorrowTableAdapter();
reservedTableAdapter = new TabReservedTableAdapter();
}
public MediaDAO()
{
viewMediaAdapter = new ViewMediaTableAdapter();
genreTableAdapter = new TabGenreTableAdapter();
tabMediaTableAdapter = new TabMediaTableAdapter();
languageTableAdapter = new TabLanguageTableAdapter();
directorTableAdapter = new TabDirectorTableAdapter();
tabReserveTableAdapter = new TabReservedTableAdapter();
tabBorrowTableAdapter = new TabBorrowTableAdapter();
}
public MediaDAO()
{
mediaDataSet = new MediaDS();
viewMediaTableAdapter = new ViewMediaTableAdapter();
languageTableAdapter = new TabLanguageTableAdapter();
genreTableAdapter = new TabGenreTableAdapter();
directorTableAdapter = new TabDirectorTableAdapter();
MediaTableAdapter = new TabMediaTableAdapter();
reserveTableAdapter = new TabReservedTableAdapter();
borrowTableAdapter = new TabBorrowTableAdapter();
returnTableAdapter = new TabReturnTableAdapter();
}
//if we need TabMediaTableAdapter, we'll add it later :/
public MediaDAO()
{
mediaDataSet = new MediaDS();
viewMediaAdapter = new ViewMediaTableAdapter();
languageTableAdapter = new TabLanguageTableAdapter();
genreTableAdapter = new TabGenreTableAdapter();
mediaTableAdapter = new TabMediaTableAdapter();
directorTableAdapter = new TabDirectorTableAdapter();
reservedTableAdapter = new TabReservedTableAdapter();
borrowTableAdapter = new TabBorrowTableAdapter();
viewMediaAvailavleAdapter = new ViewMediaAvailableTableAdapter();
viewMediaBorrwedAdapter = new ViewMediaBorrowedTableAdapter();
}
public int UpdateLanguage(string languageName, int languageID)
{
var languageTable = new UserData.TabLanguageDataTable();
var languageAdapter = new TabLanguageTableAdapter();
int rowCount = 0;
if (languageID != 0)
{
rowCount = languageAdapter.UpdateLanguage(languageName, languageID);
return(rowCount);
}
return(rowCount);
}
public int InsertLanguage(String languageName)
{
var languageTable = new UserData.TabLanguageDataTable();
var languageAdapter = new TabLanguageTableAdapter();
int rowCount = 0;
if (languageName != null)
{
rowCount = languageAdapter.InsertLanguage(languageName);
return(rowCount);
}
return(rowCount);
}
public BookDAO()
{
_bookDataSet = new DataSet1();
_viewBookTableAdapter = new ViewBookTableAdapter();
_tabAuthorTableAdaptater = new TabAuthorTableAdapter();
_tabCategoryTableAdaptater = new TabCategoryTableAdapter();
_viewBookAvailableTableAdapter = new ViewBookAvailableTableAdapter();
_viewBookBorrowedTableAdapter = new ViewBookBorrowedTableAdapter();
_tabLanguageTableAdapter = new TabLanguageTableAdapter();
_tabBorrowTableAdapter = new TabBorrowTableAdapter();
_tabBookTableAdapter = new TabBookTableAdapter();
_tabReservedTableAdapter = new TabReservedTableAdapter();
}
public void DeleteLanguage(int languageID)
{
var languageTable = new UserData.TabLanguageDataTable();
var languageAdapter = new TabLanguageTableAdapter();
int rowCount = languageAdapter.DeleteLanguage(languageID);
}
