public static List<Canal> SelectAll()
{
CanalDSTableAdapters.TblCanalTableAdapter adapter = new CanalDSTableAdapters.TblCanalTableAdapter();
CanalDS.TblCanalDataTable table = adapter.SelectAll();
List<Canal> listaCanals = new List<Canal>();
foreach (CanalDS.TblCanalRow row in table)
{
Canal objCanal = RowToDto(row);
listaCanals.Add(CargarInformacionCompleta(objCanal));
}
return listaCanals;
}
public static Canal Insert(Canal canal)
{
CanalDSTableAdapters.TblCanalTableAdapter adapter = new CanalDSTableAdapters.TblCanalTableAdapter();
CanalDS.TblCanalDataTable table = adapter.InsertCanal(canal.Nombre, canal.FechaCreacion, canal.UsuarioCreacionID);
if (table.Count() == 0)
{
return null;
}
Canal objCanal = RowToDto(table[0]);
return CargarInformacionCompleta(objCanal);
}
public static Canal SelectById(int id)
{
CanalDSTableAdapters.TblCanalTableAdapter adapter = new CanalDSTableAdapters.TblCanalTableAdapter();
CanalDS.TblCanalDataTable table = adapter.SelectById(id);
if (table.Count() == 0)
{
return null;
}
Canal objCanal = RowToDto(table[0]);
return CargarInformacionCompleta(objCanal);
}
public static void Update(Canal canal)
{
CanalDSTableAdapters.TblCanalTableAdapter adapter = new CanalDSTableAdapters.TblCanalTableAdapter();
adapter.Update(canal.Nombre, canal.FechaCreacion, canal.UsuarioCreacionID, canal.Id);
}
public static void Delete(int id)
{
CanalDSTableAdapters.TblCanalTableAdapter adapter = new CanalDSTableAdapters.TblCanalTableAdapter();
adapter.Delete(id);
}
