// get director ID based on director name public static int GetDID(string directorName) { int dID = -1; MediaDataSet.TabDirectorDataTable tabDirectorDataTable = new MediaDataSet.TabDirectorDataTable(); TabDirectorTableAdapter tabDirectorTableAdapter = new TabDirectorTableAdapter(); try { // retrieve data from database tabDirectorTableAdapter.SelectDirector(tabDirectorDataTable, directorName); // convert data into int dID = (int)tabDirectorDataTable.Rows[0]["DID"]; } catch (IndexOutOfRangeException e) { Console.WriteLine(directorName + " cannot be found in the database."); Console.WriteLine(e.Message); } catch (Exception e) { Console.WriteLine(e.Message); } return(dID); }
public MediaDAO() { mediaDataSet = new MediaDS(); tabMediaAdapter = new TabMediaTableAdapter(); viewMediaTableAdapter = new ViewMediaTableAdapter(); tabGenreTableAdapter = new TabGenreTableAdapter(); tabLanguageTableAdapter = new TabLanguageTableAdapter(); tabDirectorTableAdapter = new TabDirectorTableAdapter(); }
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(); mediaTableAdapter = new TabMediaTableAdapter(); directorTableAdapter = new TabDirectorTableAdapter(); reservedTableAdapter = new TabReservedTableAdapter(); borrowTableAdapter = new TabBorrowTableAdapter(); }
public int UpdateDirector(string directorName, int directorID) { var directorTable = new UserData.TabDirectorDataTable(); var directorAdapter = new TabDirectorTableAdapter(); int rowCount = 0; if (directorName != null) { rowCount = directorAdapter.UpdateDirector(directorName, directorID); } return(rowCount); }
public int InsertDirector(String directorName) { var directorTable = new UserData.TabDirectorDataTable(); var directorAdapter = new TabDirectorTableAdapter(); int rowCount = 0; if (directorName != null) { rowCount = directorAdapter.InsertDirector(directorName); return(rowCount); } return(rowCount); }
public List <Directors> getDirectors() { List <Directors> directors = new List <Directors>(); var directorsTable = new UserData.TabDirectorDataTable(); var directorsAdapater = new TabDirectorTableAdapter(); int rowCount = directorsAdapater.getDirectors(directorsTable); if (rowCount > 0) { foreach (DataRow dr in directorsTable) { Directors dir = new Directors(); dir.DID = int.Parse(dr["DID"].ToString()); dir.DirectorName = dr["DirectorName"].ToString(); directors.Add(dir); } } return(directors); }
public void DeleteDirector(int directorID) { var directorTable = new UserData.TabDirectorDataTable(); var directorAdapter = new TabDirectorTableAdapter(); int rowCount = directorAdapter.DeleteDirector(directorID); }