public List <MediaDataTransferObjects> ViewMedia() { int rowCount = tabMediaTableAdapter.MediaView(tabMedias); if (rowCount > 0) { tabMediaTableAdapter.MediaView(tabMedias); foreach (DataRow dr in tabMedias.Rows) { MediaDataTransferObjects mediaDTO = new MediaDataTransferObjects(); try { mediaDTO.MediaID = Int32.Parse(dr["MediaID"].ToString()); mediaDTO.Title = dr["Title"].ToString(); mediaDTO.Genere = dr["GenreName"].ToString(); mediaDTO.Language = dr["LanguageName"].ToString(); mediaDTO.Budget = decimal.Parse(dr["Budget"].ToString()); mediaDTO.PublishYear = Int32.Parse(dr["PublishYear"].ToString()); mediaDTO.Director = dr["DirectorName"].ToString(); } catch { } mediaDTOs.Add(mediaDTO); } } return(mediaDTOs); }
public List <MediaDataTransferObjects> viewMediaByValue(string value, string column) { List <MediaDataTransferObjects> allBooks = new List <MediaDataTransferObjects>(); int rowCount = 0; if (column == "Title") { rowCount = tabMediaTableAdapter.TitleBrowse(tabMedias, value); } else if (column == "DirectorName") { rowCount = tabMediaTableAdapter.DirectorBrowse(tabMedias, value); } else if (column == "Genre") { rowCount = tabMediaTableAdapter.GenreBrowse(tabMedias, value); } else { rowCount = tabMediaTableAdapter.MediaView(tabMedias); } if (rowCount > 0) { foreach (DataRow r in tabMedias) { MediaDataTransferObjects book = new MediaDataTransferObjects(); book.MediaID = int.Parse(r["MediaID"].ToString()); book.Title = r["Title"].ToString(); book.PublishYear = int.Parse(r["PublishYear"].ToString()); book.Language = r["LanguageName"].ToString(); book.Budget = decimal.Parse(r["Budget"].ToString()); book.Director = r["DirectorName"].ToString(); book.Genere = r["GenreName"].ToString(); allBooks.Add(book); } } return(allBooks); }