public decimal CarregarTicket(ModelSaida modelSaida) { try { string instrucao = string.Format(@"SELECT Ticket FROM tbPedido WHERE Vendedor = @Vendedor AND dataVenda = @dataVenda"); SqlCommand command = new SqlCommand(instrucao, controllerConfiguracaoSQL.Conectar()); command.Parameters.AddWithValue("@Vendedor", modelSaida.Vendedor); command.Parameters.AddWithValue("@dataVenda", modelSaida.DataSaida); SqlDataReader sqlDataReader = command.ExecuteReader(); decimal valorTotal = 0; while (sqlDataReader.Read()) { valorTotal += Convert.ToDecimal(sqlDataReader["Ticket"].ToString().Replace("R$ ", "")); } return(valorTotal); } catch { throw; } finally { controllerConfiguracaoSQL.Fechar(); } }
public bool InserirSaida(ModelSaida modelSaida) { try { string instrucao = string.Format(@"INSERT INTO tbSaida (Vendedor, DataSaida, Valor) VALUES (@Vendedor, @DataSaida, @Valor)"); SqlCommand command = new SqlCommand(instrucao, controllerConfiguracaoSQL.Conectar()); command.Parameters.AddWithValue("@Vendedor", modelSaida.Vendedor); command.Parameters.AddWithValue("@DataSaida", modelSaida.DataSaida); command.Parameters.AddWithValue("@Valor", modelSaida.Valor); return(Convert.ToBoolean(command.ExecuteNonQuery())); } catch { throw; } finally { controllerConfiguracaoSQL.Fechar(); } }