public HttpResponseMessage GetAll() { try { List <PedVendaLinhas> lstPedVendaLinhas = new List <PedVendaLinhas>(); using (MySqlConnection conn = new MySqlConnection(ConnectionString)) { conn.Open(); using (MySqlCommand command = new MySqlCommand()) { command.Connection = conn; command.CommandText = "select idPedLinhas, idPedCabecalho, idItem, valUnit, pedQtde from pedvenda_linhas"; MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { PedVendaLinhas pedVendaLinhas = new PedVendaLinhas() { idPedLinhas = reader["idPedLinhas"] == DBNull.Value ? 0 : Convert.ToInt32(reader["idPedLinhas"]), idPedCabecalho = reader["idPedCabecalho"] == DBNull.Value ? 0 : Convert.ToInt32(reader["idPedCabecalho"]), idItem = reader["idItem"] == DBNull.Value ? 0 : Convert.ToInt32(reader["idItem"]), valUnit = reader["valUnit"] == DBNull.Value ? 0 : Convert.ToDecimal(reader["valUnit"]), pedQtde = reader["pedQtde"] == DBNull.Value ? 0 : Convert.ToInt32(reader["pedQtde"]) }; lstPedVendaLinhas.Add(pedVendaLinhas); } } conn.Close(); } return(Request.CreateResponse(HttpStatusCode.OK, lstPedVendaLinhas.ToArray())); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }
public HttpResponseMessage GetById(int id) { try { PedVendaLinhas pedVendaLinhas = null; using (MySqlConnection conn = new MySqlConnection(ConnectionString)) { conn.Open(); using (MySqlCommand command = new MySqlCommand()) { command.Connection = conn; command.CommandText = "select idPedLinhas, idPedCabecalho, idItem, valUnit, pedQtde from pedvenda_linhas where idPedLinhas = @id"; command.Parameters.AddWithValue("id", id); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { pedVendaLinhas = new PedVendaLinhas() { idPedLinhas = reader["idPedLinhas"] == DBNull.Value ? 0 : Convert.ToInt32(reader["idPedLinhas"]), idPedCabecalho = reader["idPedCabecalho"] == DBNull.Value ? 0 : Convert.ToInt32(reader["idPedCabecalho"]), idItem = reader["idItem"] == DBNull.Value ? 0 : Convert.ToInt32(reader["idItem"]), valUnit = reader["valUnit"] == DBNull.Value ? 0 : Convert.ToDecimal(reader["valUnit"]), pedQtde = reader["pedQtde"] == DBNull.Value ? 0 : Convert.ToInt32(reader["pedQtde"]) }; } } conn.Close(); } return(Request.CreateResponse(HttpStatusCode.OK, pedVendaLinhas)); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message)); } }
public HttpResponseMessage Post(PedVendaLinhas pedVendaLinhas) { try { bool result = false; if (pedVendaLinhas == null) { throw new ArgumentNullException("pedvenda_linhas"); } using (MySqlConnection conn = new MySqlConnection(ConnectionString)) { conn.Open(); using (MySqlCommand command = new MySqlCommand()) { command.Connection = conn; command.CommandText = "insert into pedvenda_linhas(idPedLinhas, idPedCabecalho, idItem, valUnit, pedQtde) values(@idPedLinhas, @idPedCabecalho, @idItem, @valUnit, @pedQtde)"; command.Parameters.AddWithValue("idPedLinhas", pedVendaLinhas.idPedLinhas); command.Parameters.AddWithValue("idPedCabecalho", pedVendaLinhas.idPedCabecalho); command.Parameters.AddWithValue("idItem", pedVendaLinhas.idItem); command.Parameters.AddWithValue("valUnit", pedVendaLinhas.valUnit); command.Parameters.AddWithValue("pedQtde", pedVendaLinhas.pedQtde); 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)); } }