public static ListaOrcamento RetornaOrcamento()
{
try
{
con = ConnectionFactory.getConnection();
con.Open();
comando = "SELECT Orcamento.IdPedido, Orcamento.Tipo, DataEmissao,Observacoes, Vendedor, PrazoEntrega, CondicaoPag, Orcamento.ValorSoma, QtdItens FROM Orcamento INNER JOIN Pedido on Pedido.IdPedido = Orcamento.IdPedido WHERE Pedido.Status = 'ORCAMENTO' ORDER BY DataEmissao;";
XmlSerializer ser = new XmlSerializer(typeof(ListaOrcamento));
list = new ListaOrcamento();
using (var cmd = con.CreateCommand())
{
cmd.CommandText = comando.ToString();
using (var rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
list.Items.Add(new Orcamento
{
Pedido = rdr.GetInt32(0),
Tipo = rdr.GetString(1),
DataEmissao = rdr.GetDateTime(2).ToString("dd/MM/yyyy"),
Observacoes = rdr.GetString(3),
Vendedor = rdr.GetString(4),
PrazoEntrega = rdr.GetString(5),
CondicaoPag = rdr.GetString(6),
ValorTotal = rdr.GetDouble(7),
QtdItens = rdr.GetInt32(8)
});
}
}
}
return(list);
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
try
{
if (con != null)
{
con.Close();
}
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
try
{
if (rdr != null)
{
rdr.Close();
}
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
try
{
if (cmd != null)
{
cmd.Dispose();
}
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
}