public HttpResponseMessage GetAll()
{
try
{
List <PedVendaCabecalho> lstPedVendaCabecalho = new List <PedVendaCabecalho>();
using (MySqlConnection conn = new MySqlConnection(ConnectionString))
{
conn.Open();
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = conn;
command.CommandText = "select idPedCabecalho, idCliente, dtPedido, dtEntrega, desconto, valTotal from pedvenda_cabecalho";
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
PedVendaCabecalho pedVendaCabecalho = new PedVendaCabecalho()
{
idPedCabecalho = reader["idPedCabecalho"] == DBNull.Value ? 0 : Convert.ToInt32(reader["idPedCabecalho"]),
idCliente = reader["idCliente"] == DBNull.Value ? 0 : Convert.ToInt32(reader["idCliente"]),
dtPedido = reader["dtPedido"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(reader["dtPedido"]),
dtEntrega = reader["dtEntrega"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(reader["dtEntrega"]),
desconto = reader["desconto"] == DBNull.Value ? 0 : Convert.ToDecimal(reader["desconto"]),
valTotal = reader["valTotal"] == DBNull.Value ? 0 : Convert.ToDecimal(reader["valTotal"])
};
lstPedVendaCabecalho.Add(pedVendaCabecalho);
}
}
conn.Close();
}
return(Request.CreateResponse(HttpStatusCode.OK, lstPedVendaCabecalho.ToArray()));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public HttpResponseMessage Post(PedVendaCabecalho pedVendaCabecalho)
{
try
{
bool result = false;
if (pedVendaCabecalho == null)
{
throw new ArgumentNullException("pedVendaCabecalho");
}
using (MySqlConnection conn = new MySqlConnection(ConnectionString))
{
conn.Open();
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = conn;
command.CommandText = "insert into pedvenda_cabecalho(idCliente, dtPedido, dtEntrega, desconto, valTotal) values(@idCliente, @dtPedido, @dtEntrega, @desconto, @valTotal)";
command.Parameters.AddWithValue("idCliente", pedVendaCabecalho.idCliente);
command.Parameters.AddWithValue("dtPedido", pedVendaCabecalho.dtPedido);
command.Parameters.AddWithValue("dtEntrega", pedVendaCabecalho.dtEntrega);
command.Parameters.AddWithValue("desconto", pedVendaCabecalho.desconto);
command.Parameters.AddWithValue("valTotal", pedVendaCabecalho.valTotal);
int i = command.ExecuteNonQuery();
result = i > 0;
}
conn.Close();
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
