public tb_visor_video_Info get_info(string Cod_video)
{
try
{
tb_visor_video_Info info = new tb_visor_video_Info();
using (Entities_general Context = new Entities_general())
{
tb_visor_video Entity = Context.tb_visor_video.FirstOrDefault(q => q.Cod_video == Cod_video);
if (Entity == null)
{
return(null);
}
info = new tb_visor_video_Info
{
Cod_video = Entity.Cod_video,
Nombre_video = Entity.Nombre_video
};
}
return(info);
}
catch (Exception)
{
throw;
}
}
public bool anularDB(tb_visor_video_Info info)
{
try
{
using (Entities_general Context = new Entities_general())
{
tb_visor_video Entity = Context.tb_visor_video.FirstOrDefault(q => q.Cod_video == info.Cod_video);
if (Entity == null)
{
return(false);
}
Entity.Estado = false;
Entity.IdUsuarioAnulacion = info.IdUsuarioAnulacion;
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public bool modificarDB(tb_visor_video_Info info)
{
try
{
using (Entities_general Context = new Entities_general())
{
tb_visor_video Entity = Context.tb_visor_video.FirstOrDefault(q => q.Cod_video == info.Cod_video);
if (Entity == null)
{
return(false);
}
Entity.Nombre_video = info.Nombre_video;
Entity.IdUsuarioModifica = info.IdUsuarioModifica;
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public bool si_existe(string Cod_video)
{
try
{
tb_visor_video_Info info = new tb_visor_video_Info();
using (Entities_general Context = new Entities_general())
{
tb_visor_video Entity = Context.tb_visor_video.FirstOrDefault(q => q.Cod_video == Cod_video);
if (Entity == null)
{
return(false);
}
else
{
return(true);
}
}
}
catch (Exception)
{
throw;
}
}
public bool guardarDB(tb_visor_video_Info info)
{
try
{
using (Entities_general Context = new Entities_general())
{
tb_visor_video Entity = new tb_visor_video
{
Cod_video = info.Cod_video,
Nombre_video = info.Nombre_video,
IdUsuario = info.IdUsuario,
Estado = true
};
Context.tb_visor_video.Add(Entity);
Context.SaveChanges();
}
return(true);
}
catch (Exception)
{
throw;
}
}
