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