public Hoteis Buscar(int id) { try { Hoteis hotel = null; DBSession session = new DBSession(); Query quey = session.CreateQuery("SELECT * FROM hoteis WHERE idhotel = @idhotel"); quey.SetParameter("idhotel", id); IDataReader reader = quey.ExecuteQuery(); if (reader.Read()) { hotel = new Hoteis(Convert.ToInt32(reader["idhotel"]), Convert.ToString(reader["txhotel"]), Convert.ToString(reader["txendereco"]), Convert.ToString(reader["txemail"]), Convert.ToString(reader["txtelefone"]), Convert.ToString(reader["txlink"]), Convert.ToInt32(reader["fllocalaula"]), Convert.ToInt32(reader["flhospedagem"])); } reader.Close(); session.Close(); return(hotel); } catch (Exception error) { throw error; } }
void SelecionarHotel(object h) { string hotel = (string)h; Hotel hot = Hoteis.Find(x => string.Equals(x.Nome, hotel)); App.Current.MainPage.Navigation.PushAsync(new HotelView(hot)); }
public async Task <IActionResult> Create([Bind("HoteisId,Nome,DescricaoCurta,HotelUrl,Local")] Hoteis hoteis, IFormFile photoFile) { if (ModelState.IsValid) { if (photoFile != null && photoFile.Length > 0) { using (var memFile = new MemoryStream()) { photoFile.CopyTo(memFile); hoteis.Photo = memFile.ToArray(); } } // todo: additional validations _context.Add(hoteis); await _context.SaveChangesAsync(); ViewBag.title = "Hotel adicionado com sucesso"; ViewBag.type = "alert-sucess"; ViewBag.redirect = "/hoteis/Index"; //vai para pagInicial // todo: inform the user that the author was successfully created return(View("Confirmacao")); } return(View(hoteis)); }
public async Task <IActionResult> Edit(long id, [Bind("Idhotel,NomeHotel,NumEstrelas,Morada,Localidade,CodPostal,Pais,QuantidadeQuartos,Descricao")] Hoteis hoteis) { if (id != hoteis.Idhotel) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(hoteis); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!HoteisExists(hoteis.Idhotel)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(hoteis)); }
/// <summary> /// Adiciona hotel validando as condiçoes /// </summary> /// <param name="hotel"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public bool AddHotel(HotelBO hotel) { if (hotel.MaxQuartos != 0 && hotel.MaxQuartos <= 100) { return(Hoteis.AddHotel(hotel)); } return(false); }
public async Task <IActionResult> Create([Bind("Idhotel,NomeHotel,NumEstrelas,Morada,Localidade,CodPostal,Pais,QuantidadeQuartos,Descricao")] Hoteis hoteis) { if (ModelState.IsValid) { _context.Add(hoteis); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(hoteis)); }
public void Excluir(Hoteis variavel) { try { DBSession session = new DBSession(); Query query = session.CreateQuery("DELETE FROM hoteis WHERE idhotel = @idhotel"); query.SetParameter("idhotel", variavel.idhotel); query.ExecuteUpdate(); session.Close(); } catch (Exception error) { throw error; } }
public void Salvar(Hoteis variavel) { try { DBSession session = new DBSession(); Query query = session.CreateQuery("INSERT INTO hoteis (txhotel, txendereco, txemail, txtelefone, txlink, fllocalaula, flhospedagem) VALUES (@txhotel, @txendereco, @txemail, @txtelefone, @txlink, @fllocalaula, @flhospedagem) "); query.SetParameter("txhotel", variavel.txhotel) .SetParameter("txendereco", variavel.txendereco) .SetParameter("txemail", variavel.txemail) .SetParameter("txtelefone", variavel.txtelefone) .SetParameter("txlink", variavel.txlink) .SetParameter("fllocalaula", variavel.fllocalaula) .SetParameter("flhospedagem", variavel.flhospedagem); query.ExecuteUpdate(); session.Close(); } catch (Exception error) { throw error; } }
public void Alterar(Hoteis variavel) { try { DBSession session = new DBSession(); Query query = session.CreateQuery("UPDATE hoteis SET txhotel = @txhotel, txendereco = @txendereco, txemail = @txemail, txtelefone = @txtelefone, txlink = @txlink, fllocalaula = @fllocalaula, flhospedagem = @flhospedagem WHERE idhotel = @idhotel"); query.SetParameter("idhotel", variavel.idhotel) .SetParameter("txhotel", variavel.txhotel) .SetParameter("txendereco", variavel.txendereco) .SetParameter("txemail", variavel.txemail) .SetParameter("txtelefone", variavel.txtelefone) .SetParameter("txlink", variavel.txlink) .SetParameter("fllocalaula", variavel.fllocalaula) .SetParameter("flhospedagem", variavel.flhospedagem); query.ExecuteUpdate(); session.Close(); } catch (Exception error) { throw error; } }
public Hoteis Buscar(string nomehotel) { try { Hoteis hotel = null; DBSession session = new DBSession(); Query quey = session.CreateQuery("SELECT * FROM hoteis WHERE txhotel like '%" + nomehotel.Replace(" ", "%") + "%'"); IDataReader reader = quey.ExecuteQuery(); if (reader.Read()) { hotel = new Hoteis(Convert.ToInt32(reader["idhotel"]), Convert.ToString(reader["txhotel"]), Convert.ToString(reader["txendereco"]), Convert.ToString(reader["txemail"]), Convert.ToString(reader["txtelefone"]), Convert.ToString(reader["txlink"]), Convert.ToInt32(reader["fllocalaula"]), Convert.ToInt32(reader["flhospedagem"])); } reader.Close(); session.Close(); return(hotel); } catch (Exception error) { throw error; } }
public async Task <IActionResult> Edit(int id, [Bind("HoteisId,Nome,DescricaoCurta,HotelUrl,Local")] Hoteis hoteis) { if (id != hoteis.HoteisId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(hoteis); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!HoteisExists(hoteis.HoteisId)) { // todo: Maybe someone delete it. // Inform user and allow to insert new with same data return(NotFound()); } else { // todo: show error and allow to try again throw; } } ViewBag.title = "Hotel editado com sucesso"; ViewBag.type = "alert-sucess"; ViewBag.redirect = "/hoteis/Index"; //vai para pagInicial // todo: inform the user that the author was successfully edited return(View("editado")); } return(View(hoteis)); }
/// <summary>s /// Carrega ficheiro à priori gravado em binario /// </summary> /// <param name="nomFicheiro"></param> /// <returns></returns> static public bool Load(string nomFicheiro) { return(Hoteis.Load(nomFicheiro)); }
/// <summary> /// Guarda hotel em ficheiro binario /// </summary> /// <param name="nomFicheiro"></param> /// <returns></returns> static public bool Save(string nomFicheiro) { return(Hoteis.Save(nomFicheiro)); }
/// <summary> /// Devolve informaçao do codigo validando login /// </summary> /// <param name="cod"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public HotelBO InfoHotel(int cod) { return(Hoteis.InfoHotel(cod)); }
/// <summary> /// Devolve numero de quartos livres no Hotel q escolhe /// </summary> /// <param name="cod"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public List <int> NumQuartosLivres(int cod) { return(Hoteis.NumQuartosLivres(cod)); }
/// <summary> /// Remove o hotel pelo codigo /// </summary> /// <param name="cod"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public bool RemoveHotel(int cod) { return(Hoteis.RemoveHotel(cod)); }
/// <summary> /// Efetua checkin verificando login /// </summary> /// <param name="c"></param> /// <param name="check"></param> /// <param name="numQ"></param> /// <param name="cod"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public bool EfetuarCheckIn(Cliente c, DateTime check, int numQ, int cod) { return(Hoteis.EfetuarCheckIn(c, check, numQ, cod)); }
/// <summary> /// Devolve informaçao do utilizador validando o login /// </summary> /// <param name="numC"></param> /// <param name="cod"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public List <Cliente> RegistoCliente(int numC, int cod) { return(Hoteis.InfoCliente(numC, cod)); }
/// <summary> /// devolve info quarto validando login /// </summary> /// <param name="numQ"></param> /// <param name="cod"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public Quarto InfoQuarto(int numQ, int cod) { return(Hoteis.InfoQuarto(numQ, cod)); }
/// <summary> /// Remove Quarto validando login /// </summary> /// <param name="q"></param> /// <param name="numQ"></param> /// <param name="cod"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public Registo RemoveQuarto(int numQ, int cod) { return(Hoteis.RemoveQuarto(numQ, cod)); }
/// <summary> /// Devolve informaçao do Empregado validando o login /// </summary> /// <param name="numE"></param> /// <param name="cod"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public List <Empregado> RegistoEmpregado(int numE, int cod) { return(Hoteis.InfoEmpregado(numE, cod)); }
/// <summary> /// Adiciona utilizador validando o login /// </summary> /// <param name="c"></param> /// <param name="cod"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public bool AddCliente(Cliente c, int cod) { return(Hoteis.AddCliente(c, cod)); }
/// <summary> /// Procura cliente validando login /// </summary> /// <param name="numC"></param> /// <param name="cod"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public Cliente GetCliente(int numC, int cod) { return(Hoteis.GetCliente(numC, cod)); }
/// <summary> /// Adiciona empregado validando o login /// </summary> /// <param name="e"></param> /// <param name="cod"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public bool AddEmpregado(Empregado e, int cod) { return(Hoteis.AddEmpregado(e, cod)); }
/// <summary> /// /// </summary> /// <param name="numQ"></param> /// <param name="precoDia"></param> /// <param name="cod"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public double EfetuaPagamento(int numQ, double precoDia, int cod) { return(Hoteis.EfetuarPagamento(numQ, precoDia, cod)); }
/// <summary> /// Remove empregado validando o login /// </summary> /// <param name="numE"></param> /// <param name="cod"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public bool RemoveEmpregado(int numE, int cod) { return(Hoteis.RemoveEmpregado(numE, cod)); }
/// <summary> /// Remove utilizador validando o login /// </summary> /// <param name="numC"></param> /// <param name="cod"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public bool RemoveCliente(int numC, int cod) { return(Hoteis.RemoveCliente(numC, cod)); }
/// <summary> /// Procura empregado validando login /// </summary> /// <param name="numC"></param> /// <param name="cod"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public Empregado GetEmpregado(int numE, int cod) { return(Hoteis.GetEmpregado(numE, cod)); }
/// <summary> /// Adiciona Quarto validando login /// </summary> /// <param name="q"></param> /// <param name="numQ"></param> /// <param name="cod"></param> /// <param name="user"></param> /// <param name="pw"></param> /// <returns></returns> static public bool AddQuarto(Quarto q, int numQ, int cod) { return(Hoteis.AddQuarto(q, numQ, cod)); }