private List <CampoAluguel> ConvertCampoAluguelToObject(MySqlDataReader reader)
{
var fields = new List <CampoAluguel>();
while (reader.Read())
{
var temObjeto = new CampoAluguel()
{
aluguelId = int.Parse(reader["idAluguel"].ToString()),
responsavelId = 0,
nomeCampo = reader["nomeCampo"].ToString(),
rua = reader["rua"].ToString(),
cep = reader["cep"].ToString(),
numero = int.Parse(reader["numero"].ToString()),
cidade = reader["cidade"].ToString(),
bar = bool.Parse(reader["bar"].ToString()),
horarioInicio = reader["horarioInicio"].ToString(),
horarioFim = reader["horarioFim"].ToString(),
valor = Double.Parse(reader["valor"].ToString())
};
fields.Add(temObjeto);
}
reader.Close();
return(fields);
}
public ActionResult ConfirmaReserva(int id)
{
var logged = TempData["UsuarioConsumidor"] as UsuarioConsumidor;
TempData.Keep();
var queryReserva = new QueryUsuarioConsumidor();
var reservaList = queryReserva.ListarCamposAlugueisPorId(id);
reservaList.First().responsavelId = logged.Id;
var campoAluguelTD = new CampoAluguel {
aluguelId = id
};
TempData["CampoAluguel"] = campoAluguelTD;
var pagamento = new Pagamento {
idConsumidor = reservaList.First().responsavelId,
horarioReservado = reservaList.First().horarioInicio,
idAdministrador = queryReserva.ListarIDAdmNPorNomeCampo(reservaList.First().nomeCampo)
};
return(View(pagamento));
}
public void ConfirmarAluguel(CampoAluguel campAluguel)
{
var strQuery = "";
strQuery += $"UPDATE aluguel SET (idCampo,horarioInicio, horarioFim, confirmado, valor)";
using (contexto = new Contexto())
{
contexto.ExecutaComando(strQuery);
}
}
public ActionResult Reservar(CampoAluguel campAluguel)
{
if (ModelState.IsValid)
{
var logged = TempData["UsuarioConsumidor"] as UsuarioConsumidor;
TempData.Keep();
ViewBag.userID = logged.Id;
var queryAluguel = new QueryUsuarioFornecedor();
var aluguel = queryAluguel.ListarAluguelPorId(campAluguel.aluguelId);
aluguel.First().reponsavelId = campAluguel.responsavelId;
queryAluguel.AlterarAluguel(aluguel.First());
return(View("SucessoReserva"));
}
return(View("Painel"));
}
