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();
}
}
