//private readonly IConfiguration configuration;
public IActionResult Index()
{
string connectionString = "datasource=localhost;port=3306;database=artdesign;username=root;password=admin"; /*configuration.GetConnectionString("Def");*/
var connection = new MySqlConnection(connectionString);
connection.Open();
using var command = new MySqlCommand("SELECT * FROM Artigos;", connection);
using var reader = command.ExecuteReader();
List <object> list = new List <object>();
while (reader.Read())
{
var art = new ArtigosModel()
{
Id = (int)reader.GetValue(0),
Descricao = (string)reader.GetValue(1),
Quantidade = (int)reader.GetValue(2)
};
list.Add(art);
}
ViewData["data"] = list.ToList();
return(View());
}
private ArtigosModel CrieArtigoParaAtualizacao()
{
var artigo = new ArtigosModel
{
Titulo = "Titulo Atualizacao",
Chamada = "Chamada Atualizacao",
Descricao = "Descricao Atualizacao"
};
return(artigo);
}
private ArtigosModel CrieArtigoParaCadastro()
{
var artigo = new ArtigosModel
{
Titulo = "Titulo Cadastro",
Chamada = "Chamada Cadastro",
Descricao = "Descricao Cadastro"
};
return(artigo);
}
public void FixtureSetUp()
{
var portalUI = new PortalUI(ComponenteDeTela);
portalUI.InicializarElementos();
var adminUI = new AdministracaoUI(ComponenteDeTela, portalUI);
adminUI.InicializarElementos();
_artigosInicioUI = new ArtigosInicioUI(ComponenteDeTela, adminUI);
_artigosInicioUI.AbrirFuncionalidade();
_modelParaCadastro = CrieArtigoParaCadastro();
_modelParaAtualizacao = CrieArtigoParaAtualizacao();
}
public ActionResult VerReservasUtilizador()
{
ViewBag.LoggedIn = IsLoggedIn();
var utilizador = (LoginModel)Session[SessionUtilizador];
var model = new SearchDestinosModel();
var listaReservas = new List <ReservasModel>();
var getReservasUser = $@"SELECT
rh.data_inicio,
rh.data_fim,
rh.nr_hospedes,
th.preco_unidade,
tp.designacao,
h.nome,
h.classificacao,
rh.preco_total,
CONCAT(h.morada, ', ', h.codigo_postal, ' - ', l.localizacao) as morada,
(STUFF((SELECT a.designacao
FROM reserva_servicos rs
left join artigos a on a.id_artigo = rs.id_artigo
WHERE rs.id_reserva_hotel = rh.id_reserva_hotel
FOR XML PATH ('')), 1, 2, '')) AS artigos,
rh.id_reserva_hotel,
rh.apagado
FROM reserva_hotel rh
left join tarifas_hotel th on th.id_tarifa = rh.id_tarifa_hotel
left join hotel h on h.id_hotel = th.id_hotel
left join localizacao l on l.id_localizacao = h.id_localizacao
left join tipo_quarto tp on tp.id_tipo_quarto = th.id_tipo_quarto
WHERE 1=1
AND rh.id_utilizador = {utilizador.IdUser}
ORDER BY rh.data_inicio DESC";
using (var connection = new SqlConnection(ConnectionString))
using (var command = new SqlCommand(getReservasUser, connection))
{
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var newReserva = new ReservasModel
{
IdReserva = Convert.ToInt32(reader["id_reserva_hotel"]),
DataInicio = Convert.ToDateTime(reader["data_inicio"]),
DataFim = Convert.ToDateTime(reader["data_fim"]),
NomeHotel = reader["nome"].ToString(),
MoradaCompleta = reader["morada"].ToString(),
Classificacao = reader["classificacao"].ToString(),
NrHospedes = reader["nr_hospedes"].ToString(),
TipoQuarto = reader["designacao"].ToString(),
Preco = reader["preco_total"].ToString(),
PrecoUnidade = reader["preco_unidade"].ToString(),
Apagado = Convert.ToBoolean(reader["apagado"])
};
var sqlGetArtigosreserva = $@"SELECT *
FROM reserva_servicos rs
left join artigos a on a.id_artigo = rs.id_artigo
WHERE rs.id_reserva_hotel = {newReserva.IdReserva}";
using (var conn = new SqlConnection(ConnectionString))
using (var cm = new SqlCommand(sqlGetArtigosreserva, conn))
{
conn.Open();
using (var read = cm.ExecuteReader())
{
while (read.Read())
{
var newArtigo = new ArtigosModel
{
IdArtigo = Convert.ToInt32(read["id_artigo"]),
Designacao = read["designacao"].ToString(),
PermitePreMarcacao = Convert.ToBoolean(read["permite_pre_marcacao"]),
Preco = Convert.ToDecimal(read["preco"])
};
newReserva.Artigos.Add(newArtigo);
}
}
conn.Close();
}
listaReservas.Add(newReserva);
}
}
connection.Close();
}
var sqlGetArtigos = "SELECT * FROM artigos;";
using (var connection = new SqlConnection(ConnectionString))
using (var command = new SqlCommand(sqlGetArtigos, connection))
{
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var newArtigo = new ArtigosModel
{
IdArtigo = Convert.ToInt32(reader["id_artigo"]),
Designacao = reader["designacao"].ToString(),
PermitePreMarcacao = Convert.ToBoolean(reader["permite_pre_marcacao"]),
Preco = Convert.ToDecimal(reader["preco"])
};
model.ListaArtigos.Add(newArtigo);
}
}
connection.Close();
}
model.ListaReservas = listaReservas;
return(View("ViewReservas", model));
}
