public static Inventario InsertWithReturn(string idUsuario, string tipo, string glosa) { InventarioDSTableAdapters.tbl_inventarioTableAdapter adapter = new InventarioDSTableAdapters.tbl_inventarioTableAdapter(); InventarioDS.tbl_inventarioDataTable table = adapter.InsertWithReturn(Convert.ToInt32(idUsuario), tipo, glosa, TimeSpan.Parse(DateTime.Now.ToString("hh:mm:ss")), DateTime.Now, 0, 0); if (table.Rows.Count == 0) { return(null); } return(RowToDto(table[0])); }
public static Inventario SelectById(int id) { InventarioDSTableAdapters.tbl_inventarioTableAdapter adapter = new InventarioDSTableAdapters.tbl_inventarioTableAdapter(); InventarioDS.tbl_inventarioDataTable table = adapter.selectById(id); if (table.Rows.Count == 0) { return(null); } return(RowToDto(table[0])); }
public static List <Inventario> SelectAll() { InventarioDSTableAdapters.tbl_inventarioTableAdapter adapter = new InventarioDSTableAdapters.tbl_inventarioTableAdapter(); InventarioDS.tbl_inventarioDataTable table = adapter.selectNoEliminados(); List <Inventario> listInventario = new List <Inventario>(); foreach (InventarioDS.tbl_inventarioRow row in table) { listInventario.Add(RowToDto(row)); } return(listInventario); }