public static List <Item> GetAll() { DataTable table = new DataTable(); List <Item> Itens = new List <Item>(); OpenConn(); try { NpgsqlCommand command = new NpgsqlCommand(null, dbConn); command.CommandText = "SELECT * FROM Item"; NpgsqlDataAdapter Adpt = new NpgsqlDataAdapter(command); Adpt.Fill(table); if (table.Rows.Count > 0) { foreach (DataRow dr in table.Rows) { Itens.Add( new Item { ID = Convert.ToInt32(dr["id"]), Patrimonio = dr["patrimonio"].ToString(), Localidade = new Localidade { ID = Convert.ToInt32(dr["localidade"]) }, Categoria = new ItemCategoria { ID = Convert.ToInt32(dr["categoria"]) }, Observacao = dr["observacao"].ToString(), Status = new ItemStatus { Id = Convert.ToInt32(dr["status"]) } } ); } } foreach (Item item in Itens) { item.Categoria = ItemCategoriaDAO.GetByID(item.Categoria.ID); } foreach (Item item in Itens) { item.Localidade = LocalidadeDAO.GetByID(item.Localidade.ID); } foreach (Item item in Itens) { item.Status = ItemStatusDAO.GetByID(item.Status.Id); } dbConn.Close(); return(Itens); } catch (Exception e) { System.Diagnostics.Debug.WriteLine("INVENTARIO/ItemDAO/GetAll:: " + e); dbConn.Close(); return(null); } }
public static Item GetByID(int Id) { NpgsqlParameter param; DataTable table = new DataTable(); Item Item = null; OpenConn(); try { NpgsqlCommand command = new NpgsqlCommand(null, dbConn); command.CommandText = "SELECT * FROM Item WHERE id = @id"; param = new NpgsqlParameter("@id", NpgsqlTypes.NpgsqlDbType.Integer, 0); param.Value = Id; command.Parameters.Add(param); NpgsqlDataAdapter Adpt = new NpgsqlDataAdapter(command); Adpt.Fill(table); if (table.Rows.Count > 0) { foreach (DataRow dr in table.Rows) { Item = new Item { ID = Convert.ToInt32(dr["id"]), Patrimonio = dr["patrimonio"].ToString(), Localidade = new Localidade { ID = Convert.ToInt32(dr["localidade"]) }, Categoria = new ItemCategoria { ID = Convert.ToInt32(dr["categoria"]) }, Observacao = dr["observacao"].ToString(), Status = new ItemStatus { Id = Convert.ToInt32(dr["status"]) } }; Item.Categoria = ItemCategoriaDAO.GetByID(Item.Categoria.ID); Item.Status = ItemStatusDAO.GetByID(Item.Status.Id); Item.Localidade = LocalidadeDAO.GetByID(Item.Localidade.ID); return(Item); } } } catch (Exception e) { System.Diagnostics.Debug.WriteLine("INVENTARIO/ItemDAO/GetByID:: " + e); } dbConn.Close(); return(null); }