// 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 <PairModel> GetLanguages()
{
List <PairModel> pairList = new List <PairModel>();
MediaDataSet.TabLanguageDataTable languageTable = mediaDAO.GetLanguages();
if (languageTable != null)
{
foreach (MediaDataSet.TabLanguageRow row in languageTable.Rows)
{
PairModel pair = PairModel.Parse(row);
pairList.Add(pair);
}
return(pairList);
}
else
{
return(null);
}
}
