// add new language row into Language table public bool IsLanguageInserted(LanguageDTO newLanguage) { try { // insert row using query tabLanguageTableAdapter.InsertLanguage(newLanguage.LanguageName); return(true); } catch (Exception e) { Console.WriteLine(e.Message); return(false); } }
// update a language row public bool IsLanguageUpdated(LanguageDTO updatedLanguage) { try { // update row using query tabLanguageTableAdapter.UpdateLanguage(updatedLanguage.LanguageName, updatedLanguage.LID); return(true); } catch (Exception e) { Console.WriteLine(e.Message); return(false); } }
// get all language records public List <LanguageDTO> GetAllLanguage() { List <LanguageDTO> LanguageList = new List <LanguageDTO>(); try { // get all rows in the table using query tabLanguageTableAdapter.Fill(tabLanguageDataTable); foreach (DataRow Row in tabLanguageDataTable.Rows) { LanguageDTO Language = new LanguageDTO { LID = (int)Row[0], LanguageName = (string)Row[1] }; LanguageList.Add(Language); } } catch (Exception e) { Console.WriteLine(e.Message); } return(LanguageList); }