public static Video Insert(Video video)
{
VideoDSTableAdapters.TblVideoTableAdapter adapter = new VideoDSTableAdapters.TblVideoTableAdapter();
VideoDS.TblVideoDataTable table = adapter.InsertVideo(video.CanalID, video.Nombre, video.Descripcion, video.FechaCreacion, video.NombreArchivo, video.FormatoArchivo);
Video objVideo = RowToDto(table[0]);
if (table.Count() == 0)
{
return null;
}
return CargarInformacionCompleta(objVideo);
}
public static List<Video> SelectByCanalID(int? canalID)
{
VideoDSTableAdapters.TblVideoTableAdapter adapter = new VideoDSTableAdapters.TblVideoTableAdapter();
VideoDS.TblVideoDataTable table = adapter.SelectByCanalID(canalID);
List<Video> listaVideos = new List<Video>();
foreach (VideoDS.TblVideoRow row in table)
{
Video objVideo = RowToDto(row);
listaVideos.Add(CargarInformacionCompleta(objVideo));
}
return listaVideos;
}
public static Video SelectRandomVideo()
{
VideoDSTableAdapters.TblVideoTableAdapter adapter = new VideoDSTableAdapters.TblVideoTableAdapter();
VideoDS.TblVideoDataTable table = adapter.SelectRandomVideo();
if (table.Count() == 0)
{
return null;
}
Video objVideo = RowToDto(table[0]);
return CargarInformacionCompleta(objVideo);
}
public static void Delete(int id)
{
VideoDSTableAdapters.TblVideoTableAdapter adapter = new VideoDSTableAdapters.TblVideoTableAdapter();
adapter.Delete(id);
}
public static void Update(Video video)
{
VideoDSTableAdapters.TblVideoTableAdapter adapter = new VideoDSTableAdapters.TblVideoTableAdapter();
adapter.Update(video.CanalID, video.Nombre, video.Descripcion, video.FechaCreacion, video.NombreArchivo, video.FormatoArchivo, video.Id);
}