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