private Recibo retornaRecibo() {
try {
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
SimulaLogin login = retornaDadosCadastrais();
cmd.CommandText = $"select Nome, Marca, Modelo, l.DtLocacao, l.DtDevolucao, l.ValLocacao from Locacoes as l " +
$"inner join Clientes as c on c.IdCliente = l.IdCliente " +
$"inner join Carros as cr on cr.IdCarro = l.IdCarro " +
$"where c.IdCliente = {login.IdCliente}";
SqlDataReader dtr = cmd.ExecuteReader();
Recibo recibo = new Recibo();
while (dtr.Read()) {
recibo.Nome = dtr["Nome"].ToString();
recibo.Marca = dtr["Marca"].ToString();
recibo.Modelo = dtr["Modelo"].ToString();
recibo.DtLocacao = DateTime.Parse(dtr["DtLocacao"].ToString());
recibo.DtDevolucao = DateTime.Parse(dtr["DtDevolucao"].ToString());
recibo.ValLocacao = decimal.Parse(dtr["ValLocacao"].ToString());
};
con.Close();
return recibo;
}
catch (Exception ex) {
throw new Exception(ex.Message);
}
}
private void logar()
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = $"select * from Clientes where Email='{txtBoxEmail.Text}'";
SqlDataReader dtr = cmd.ExecuteReader();
SimulaLogin smLog = new SimulaLogin();
while (dtr.Read())
{
smLog.IdCliente = int.Parse(dtr["IdCliente"].ToString());
smLog.Nome = dtr["Nome"].ToString();
smLog.CPF = dtr["CPF"].ToString();
smLog.Email = dtr["Email"].ToString();
}
;
Session["simulaLogin"] = smLog;
con.Close();
Response.Redirect("~/Catalogo.aspx");
}
private void geraNotaLocacao(int idCarro, decimal valSemanal)
{
try {
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
SimulaLogin dadosCadastrais = retornaDadosCadastrais();
DateTime dtLocacao = DateTime.Now;
DateTime dtDevolucao = (dtLocacao.AddDays(7));
cmd.CommandText = $"insert into Locacoes (IdCliente, IdCarro , DtLocacao, DtDevolucao, ValLocacao) values ('{dadosCadastrais.IdCliente}', '{idCarro}', '{dtLocacao}', '{dtDevolucao}', '{valSemanal.ToString("F2", CultureInfo.InvariantCulture)}')";
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex) {
throw new Exception(ex.Message);
}
}
