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);
}
