public bool SalvarMensagemContato(Contato contato)
{
ConnectionDataBase conn = new ConnectionDataBase();
string sqlCmd = $"insert into tbContato (nome,email,telefone,mensagem) values ('{contato.Nome.Trim()}', '{contato.Email.Trim()}', '{contato.Telefone}', '{contato.Mensagem}');";
return(conn.SqlExecuteNonQuery(sqlCmd));
}
public List <Abastecimento> ListaAbastecimento(DateTime?minDate, DateTime?maxDate)
{
DateTime dataInicial = (DateTime)minDate;
string data1 = dataInicial.ToShortDateString();
DateTime dataFinal = (DateTime)maxDate;
string data2 = dataFinal.ToShortDateString();
ConnectionDataBase conn = new ConnectionDataBase();
string sqlCmd = "SELECT FORMAT (ta.data, 'dd/MM/yyyy') as 'Data' , tc.razaoSocial AS 'Razão Social',tv.placa AS 'Placa', tmv.modelo AS 'Modelo', tmv2.marca AS 'Marca', " +
"tf.razaoSocial AS 'Fornecedor',tc2.combustivel AS 'Combustivel' ,convert(decimal(10, 2), (ta.valorTotal / ta.valorLitro)) AS 'Litros',ta.valorLitro AS 'Valor/Litro', ta.valorTotal AS 'Valor Total' " +
"FROM dbo.tbAbastecimento ta, dbo.tbVeiculo tv, dbo.tbCliente tc, dbo.tbMarcaModelo tmm, dbo.tbModeloVeiculo tmv, dbo.tbMarcaVeiculo tmv2, dbo.tbFornecedor tf, dbo.tbCombustivel tc2 " +
$"WHERE ta.idVeiculo = tv.idVeiculo AND tv.idVeiculo = tmm.idVeiculo AND tmm.idModeloVeiculo = tmv.idModeloVeiculo AND tmm.idMarcaVeiculo = tmv2.idMarcaVeiculo AND tv.idCliente = tc.idCliente AND tf.idFornecedor = ta.idFornecedor AND tc2.idCombustivel = ta.idCombustivel AND (ta.data) BETWEEN ('{data1}') AND ('{data2}') ; ";
return(conn.DataReaderSQL(sqlCmd));
}
