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