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);
}
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 void DeleteLanguage(int languageID)
{
var languageTable = new UserData.TabLanguageDataTable();
var languageAdapter = new TabLanguageTableAdapter();
int rowCount = languageAdapter.DeleteLanguage(languageID);
}
