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();
}
public void AddCommande(Entity.Commande commande)
{
var query = "INSERT INTO Commande VALUES(\"" + null + "\"" + ",\"" + commande.PrixTotal + "\"" + ",\"" + commande.Date.ToString("yyyy-MM-dd") + "\"" + ",\"" + commande.MoyenDePaiement + "\"" + ",\"" + commande.MatriculeClient + "\"" + ",\"" + commande.IDCaissier + "\"" + ")";
var mySqlDataReader = _sQLService.Load(query);
mySqlDataReader.Close();
}
public List <Entity.Commande> GetAllCommandes()
{
var query = "SELECT * FROM Commande";
MySqlDataReader mySqlDataReader = _sQLService.Load(query);
try
{
List <Entity.Commande> list = new List <Entity.Commande>();
while (mySqlDataReader.Read())
{
Entity.Commande commande = new Entity.Commande(
(int)mySqlDataReader["idCaissier"],
mySqlDataReader["MoyenDePaiement"] as string,
(DateTime)mySqlDataReader["Date"],
(int)mySqlDataReader["MatriculeClient"],
(float)mySqlDataReader["PrixTotal"],
(int)mySqlDataReader["CodeCommande"]
);
list.Add(commande);
}
return(list);
}
catch
{
throw new Exception("Problème lors du chargement des commandes !");
}
finally
{
mySqlDataReader.Close();
}
}
public void SetMontantCommande(Entity.Commande commande, float montant)
{
var query = "UPDATE Commande SET PrixTotal=" + "\"" + montant + "\"" + " WHERE CodeCommande=" + "\"" + commande.CodeCommande + "\"";
var mySqlDataReader = _sQLService.Load(query);
mySqlDataReader.Close();
}
public Entity.Commande GetTheLastInsertedCommande()
{
var query = "SELECT * FROM Commande Where CodeCommande=(SELECT MAX(CodeCommande) FROM Commande)";
var mySqlDataReader = _sQLService.Load(query);
try
{
mySqlDataReader.Read();
Entity.Commande commande = new Entity.Commande(
(int)mySqlDataReader["idCaissier"],
mySqlDataReader["MoyenDePaiement"] as string,
(DateTime)mySqlDataReader["Date"],
(int)mySqlDataReader["MatriculeClient"],
(float)mySqlDataReader["PrixTotal"],
(int)mySqlDataReader["CodeCommande"]
);
return(commande);
}
catch
{
throw new Exception("Problème lors du chargement de la dernière commande !");
}
finally
{
mySqlDataReader.Close();
}
}
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.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 DeletePlatFromCommande(Entity.Commande commande, Entity.Plat plat)
{
try
{
_platDAL.DeletePlatFromCommande(commande, plat);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public List <Entity.Plat> GetPlatByCodeCommande(Entity.Commande commande)
{
try
{
return(_platDAL.GetPlatByCodeCommande(commande));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void SetMontantCommande(Entity.Commande commande, float montant)
{
try
{
_commandeDAL.SetMontantCommande(commande, montant);
}
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);
}
}
public void AddCommande(Entity.Commande commande)
{
try
{
_commandeDAL.AddCommande(commande);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
