public static Plat GetPlat(long platId)
{
if (platId <= 0)
{
return(new Plat());
}
try
{
using (ContextDB context = new ContextDB())
{
using (var connexio = context.Database.GetDbConnection())
{
connexio.Open();
using (var consulta = connexio.CreateCommand())
{
consulta.CommandText =
$@" SELECT * FROM `plats` WHERE PLAT_ID = @id ";
BD_Utils.CreateParameter(consulta, "id", platId, DbType.Int32);
var reader = consulta.ExecuteReader();
Plat p = new Plat();
if (reader.Read())
{
BD_Utils.Llegeix(reader, out p.id, "PLAT_ID");
BD_Utils.Llegeix(reader, out p.nom, "NOM");
BD_Utils.Llegeix(reader, out p.descripcio, "DESCRIPCIO_MD", null);
BD_Utils.Llegeix(reader, out p.preu, "PREU");
BD_Utils.Llegeix(reader, out p.fotoBytes, "FOTO");
BD_Utils.Llegeix(reader, out p.disponible, "DISPONIBLE");
long categoriaId = 0;
BD_Utils.Llegeix(reader, out categoriaId, "CATEGORIA");
Categoria c = CategoriaBD.GetCategoria(categoriaId);
p.Categoria = c;
}
return(p);
}
}
}
}
catch (Exception ex)
{
return(new Plat());
}
}
public static ObservableCollection <Plat> GetLlistaPlats()
{
try
{
using (ContextDB context = new ContextDB())
{
using (var connexio = context.Database.GetDbConnection())
{
connexio.Open();
using (var consulta = connexio.CreateCommand())
{
consulta.CommandText =
$@" SELECT * FROM `plats` ORDER BY `CATEGORIA` ";
var reader = consulta.ExecuteReader();
ObservableCollection <Plat> plats = new ObservableCollection <Plat>();
while (reader.Read())
{
Plat p = new Plat();
BD_Utils.Llegeix(reader, out p.id, "PLAT_ID");
BD_Utils.Llegeix(reader, out p.nom, "NOM");
BD_Utils.Llegeix(reader, out p.descripcio, "DESCRIPCIO_MD", null);
BD_Utils.Llegeix(reader, out p.preu, "PREU");
BD_Utils.Llegeix(reader, out p.fotoBytes, "FOTO");
BD_Utils.Llegeix(reader, out p.disponible, "DISPONIBLE");
long categoriaId = 0;
BD_Utils.Llegeix(reader, out categoriaId, "CATEGORIA");
Categoria c = CategoriaBD.GetCategoria(categoriaId);
p.Categoria = c;
plats.Add(p);
}
return(plats);
}
}
}
}
catch (Exception ex)
{
return(new ObservableCollection <Plat>());
}
}