public string Saida_Cadastro(DataSaida Saida) { using (var connection = GetConnection()) { connection.Open(); string rpta = ""; try { command.Connection = connection; command.CommandText = "INSERT INTO tb_saida (data_saida, valor, observacao, id_tipo_saida, id_forma_pagamento) VALUES (@data_entrada, @valor, @observacao, @id_tipo_entrada, @id_forma_pagamento)"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@data_entrada", Saida.Data); command.Parameters.AddWithValue("@valor", Saida.Valor); command.Parameters.AddWithValue("@observacao", Saida.Observacao); command.Parameters.AddWithValue("@id_tipo_entrada", Saida.IdSaida); command.Parameters.AddWithValue("@id_forma_pagamento", Saida.IdPagamento); rpta = command.ExecuteNonQuery() == 1 ? "OK" : "Erro ao cadastrar"; } catch (Exception ex) { rpta = ex.Message; } return(rpta); } }
//delete public string Saida_Delete(DataSaida SAIDA) { using (var connection = GetConnection()) { connection.Open(); string rpta = ""; try { command.Connection = connection; command.CommandText = "delete from tb_saida Where id=@id_saida"; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@id_saida", SAIDA.IdSaida); rpta = command.ExecuteNonQuery() == 1 ? "OK" : "Erro ao deletar"; } catch (Exception ex) { rpta = ex.Message; } return(rpta); } }