public void DeletePlatFromCommande(Entity.Commande commande, Entity.Plat plat)
{
var query = "DELETE FROM PlatCommande WHERE CodePlat=" + "\"" + plat.CodePlat + "\"" + "AND CodeCommande=" + "\"" + commande.CodeCommande + "\"";
MySqlDataReader mySqlDataReader = _sQLService.Load(query);
mySqlDataReader.Close();
}
public List <Entity.Produit> GetProduitsByPlat(Entity.Plat plat)
{
var query = "SELECT pr.CodeProduit, pr.DateEffet, pr.DateFin, pr.Categorie, pr.Nom, pr.Observation " +
"FROM Produit pr, Plat pl, CompositionPlat cpp " +
"WHERE pl.CodePlat =" + "\"" + plat.CodePlat + "\"" + "and pl.CodePlat = cpp.CodePlat and pr.CodeProduit = cpp.CodeProduit";
MySqlDataReader mySqlDataReader = _sQLService.Load(query);
try
{
List <Entity.Produit> list = new List <Entity.Produit>();
while (mySqlDataReader.Read())
{
Entity.Produit produit = new Entity.Produit(
(int)mySqlDataReader["CodeProduit"],
(DateTime)mySqlDataReader["DateEffet"],
(DateTime)mySqlDataReader["DateFin"],
mySqlDataReader["Categorie"] as string,
mySqlDataReader["Nom"] as string,
mySqlDataReader["Observation"] as string);
list.Add(produit);
}
return(list);
}
catch (MySqlException ex)
{
throw new Exception("Problème lors du chargement des plats !" + "\n" + ex.Message);
}
finally
{
mySqlDataReader.Close();
}
}
public void AddProduitToPlat(Entity.Plat plat, Entity.Produit produit)
{
var query = "INSERT INTO CompositionPlat VALUES(\"" + plat.CodePlat + "\"" + ",\"" + produit.CodeProduit + "\"" + ")";
MySqlDataReader mySqlDataReader = _sQLService.Load(query);
mySqlDataReader.Close();
}
public void AddPlatToCommande(Entity.Plat plat, Entity.Commande commande)
{
var query = "INSERT INTO PlatCommande VALUES(\"" + plat.CodePlat + "\"" + "," + "\"" + commande.CodeCommande + "\"" + ")";
var mySqlDataReader = _sQLService.Load(query);
mySqlDataReader.Close();
}
/// <summary>
/// Get List of Plat by Menu ID
/// </summary>
/// <param name="menuID"></param>
/// <returns></returns>
public List <Entity.Plat> GetPlatByMenu(Entity.Menu menu)
{
var query = "SELECT pl.CodePlat, pl.Prix, pl.DateEffet, pl.DateFin, pl.Categorie, pl.Nom " +
"FROM Plat pl, Menu m, CompositionMenu cpm " +
"WHERE m.CodeMenu =" + "\"" + menu.CodeMenu + "\"" + "and pl.CodePlat = cpm.CodePlat and m.CodeMenu = cpm.CodeMenu";
MySqlDataReader mySqlDataReader = _sQLService.Load(query);
try
{
List <Entity.Plat> list = new List <Entity.Plat>();
while (mySqlDataReader.Read())
{
Entity.Plat plat = new Entity.Plat((int)mySqlDataReader["CodePlat"],
(DateTime)mySqlDataReader["DateEffet"],
(DateTime)mySqlDataReader["DateFin"],
mySqlDataReader["Categorie"] as string,
mySqlDataReader["Nom"] as string,
(float)mySqlDataReader["Prix"]);
list.Add(plat);
}
return(list);
}
catch
{
throw new Exception("Pas de plats !");
}
finally
{
mySqlDataReader.Close();
}
}
public List <Entity.Plat> GetPlatByCodeCommande(Entity.Commande commande)
{
var query = "SELECT pl.CodePlat, pl.Prix, pl.DateEffet, pl.DateFin, pl.Categorie, pl.Nom " +
"FROM Plat pl, Commande c, PlatCommande pcm " +
"WHERE c.CodeCommande =" + "\"" + commande.CodeCommande + "\"" + "AND pl.CodePlat = pcm.CodePlat And c.CodeCommande = pcm.CodeCommande";
MySqlDataReader mySqlDataReader = _sQLService.Load(query);
try
{
List <Entity.Plat> list = new List <Entity.Plat>();
while (mySqlDataReader.Read())
{
Entity.Plat plat = new Entity.Plat((int)mySqlDataReader["CodePlat"],
(DateTime)mySqlDataReader["DateEffet"],
(DateTime)mySqlDataReader["DateFin"],
mySqlDataReader["Categorie"] as string,
mySqlDataReader["Nom"] as string,
(float)mySqlDataReader["Prix"]);
list.Add(plat);
}
return(list);
}
catch
{
throw new Exception("Pas de plats !");
}
finally
{
mySqlDataReader.Close();
}
}
public void DeleteAllProduitOfPlat(Entity.Plat plat)
{
var query = "DELETE FROM CompositionPlat WHERE CodePlat=" + "\"" + plat.CodePlat + "\"";
MySqlDataReader mySqlDataReader = _sQLService.Load(query);
mySqlDataReader.Close();
}
public void AddPlat(Entity.Plat plat)
{
var query = "INSERT INTO Plat VALUES(\"" + null + "\"" + ",\"" + plat.DateEffet.ToString("yyyy-MM-dd") + "\"" + ",\"" + plat.DateFin + "\"" + ",\"" + plat.Categorie + "\"" + ",\"" + plat.Nom + "\"" + ",\"" + plat.Prix + "\"" + ")";
MySqlDataReader mySqlDataReader = _sQLService.Load(query);
mySqlDataReader.Close();
}
public void AddPlatToMenu(Entity.Plat plat, Entity.Menu menu)
{
var query = "INSERT INTO CompositionMenu VALUES(\"" + plat.CodePlat + "\"" + ",\"" + menu.CodeMenu + "\"" + ",\"" + menu.DateElaboration + "\"" + ")";
MySqlDataReader mySqlDataReader = _sQLService.Load(query);
mySqlDataReader.Close();
}
/// <summary>
/// Get all avalaible Plat
/// </summary>
/// <returns></returns>
public List <Entity.Plat> GetAllPlat()
{
var query = "SELECT * FROM Plat";
MySqlDataReader mySqlDataReader = _sQLService.Load(query);
try
{
List <Entity.Plat> list = new List <Entity.Plat>();
while (mySqlDataReader.Read())
{
Entity.Plat plat = new Entity.Plat((int)mySqlDataReader["CodePlat"],
(DateTime)mySqlDataReader["DateEffet"],
(DateTime)mySqlDataReader["DateFin"],
mySqlDataReader["Categorie"] as string,
mySqlDataReader["Nom"] as string,
(float)mySqlDataReader["Prix"]);
list.Add(plat);
}
return(list);
}
catch
{
throw new Exception("Pas de plats !");
}
finally
{
mySqlDataReader.Close();
}
}
public void DeletePlatfromMenu(Entity.Menu menu, Entity.Plat plat)
{
var query = "DELETE FROM CompositionMenu WHERE CodePlat=" + "\"" + plat.CodePlat + "\"" + " AND CodeMenu=" + "\"" + menu.CodeMenu + "\"";
Debug.Write(query);
MySqlDataReader mySqlDataReader = _sQLService.Load(query);
mySqlDataReader.Close();
}
/// <summary>
/// Modify an existing Plat
/// </summary>
/// <param name="plat"></param>
public void ModifyPlat(Entity.Plat plat)
{
var query = " UPDATE Plat SET DateEffet=" + "\"" + plat.DateEffet.ToString("yyyy-MM-dd") + "\"" + ", DateFin=" + "\"" + plat.DateFin.ToString("yyyy-MM-dd") + "\"" + ", Categorie=" + "\"" + plat.Categorie + "\"" + ", Nom=" + "\"" + plat.Nom + "\"" + ", Prix =" + "\"" + plat.Prix + "\"" + " WHERE CodePlat= " + "\"" + plat.CodePlat + "\"";
Debug.Write(query);
MySqlDataReader mySqlDataReader = _sQLService.Load(query);
mySqlDataReader.Close();
}
public List <Entity.Produit> GetProduitsByPlatId(Entity.Plat plat)
{
try
{
return(_productDAL.GetProduitsByPlat(plat));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void DeletePlat(Entity.Plat plat)
{
try
{
_platDAL.DeletePlat(plat);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void DeletePlatFromCommande(Entity.Commande commande, Entity.Plat plat)
{
try
{
_platDAL.DeletePlatFromCommande(commande, plat);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void AddProduitToPlat(Entity.Plat plat, Entity.Produit produit)
{
try
{
_platDAL.AddProduitToPlat(plat, produit);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void AddPlatToMenu(Entity.Plat plat, Entity.Menu menu)
{
try
{
_menuDAL.AddPlatToMenu(plat, menu);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void DeletePlatfromMenu(Entity.Menu menu, Entity.Plat plat)
{
try
{
_menuDAL.DeletePlatfromMenu(menu, plat);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void AddPlatToCommande(Entity.Plat plat, Entity.Commande commande)
{
try
{
_commandeDAL.AddPlatToCommande(plat, commande);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
