public static CategoriaAcademia SelectById(int id)
{
CategoriaAcademiaDSTableAdapters.tbl_categoriaAcademiaTableAdapter adapter = new CategoriaAcademiaDSTableAdapters.tbl_categoriaAcademiaTableAdapter();
CategoriaAcademiaDS.tbl_categoriaAcademiaDataTable table = adapter.SelectById(id);
if (table.Rows.Count == 0)
{
return(null);
}
return(RowToDto(table[0]));
}
public static CategoriaAcademia InsertWithReturn(string nombre, string descripcion, string precio)
{
CategoriaAcademiaDSTableAdapters.tbl_categoriaAcademiaTableAdapter adapter = new CategoriaAcademiaDSTableAdapters.tbl_categoriaAcademiaTableAdapter();
CategoriaAcademiaDS.tbl_categoriaAcademiaDataTable table
= adapter.InsertWithReturn(nombre, descripcion, Convert.ToDouble(precio), 0);
if (table.Rows.Count == 0)
{
return(null);
}
return(RowToDto(table[0]));
}
public static List <CategoriaAcademia> SelectAll()
{
CategoriaAcademiaDSTableAdapters.tbl_categoriaAcademiaTableAdapter adapter = new CategoriaAcademiaDSTableAdapters.tbl_categoriaAcademiaTableAdapter();
CategoriaAcademiaDS.tbl_categoriaAcademiaDataTable table = adapter.SelectNoEliminados();
List <CategoriaAcademia> listCategoria = new List <CategoriaAcademia>();
foreach (CategoriaAcademiaDS.tbl_categoriaAcademiaRow row in table)
{
listCategoria.Add(RowToDto(row));
}
return(listCategoria);
}
public static void Delete(int id)
{
CategoriaAcademiaDSTableAdapters.tbl_categoriaAcademiaTableAdapter adapter = new CategoriaAcademiaDSTableAdapters.tbl_categoriaAcademiaTableAdapter();
adapter.DeleteRow(id);
}
public static void Update(string nombre, string descripcion, string precio, int id)
{
CategoriaAcademiaDSTableAdapters.tbl_categoriaAcademiaTableAdapter adapter = new CategoriaAcademiaDSTableAdapters.tbl_categoriaAcademiaTableAdapter();
adapter.UpdateRow(nombre, descripcion,
Convert.ToDouble(precio), 0, id, id);
}
