public void Return_Commande_With_BadgeId()
{
var options = new DbContextOptionsBuilder <CommandeContext>()
.UseInMemoryDatabase(databaseName: "Return_Commande_With_BadgeId")
.Options;
using (var context = new CommandeContext(options))
{
var providerData = new ProviderData(context);
var commandes = new List <Commande>()
{
new Commande
{
Boisson = Boisson.Chocolat,
BadgeId = 111,
Mug = false
},
new Commande
{
Boisson = Boisson.The,
BadgeId = 222,
Mug = true
},
new Commande
{
Boisson = Boisson.Chocolat,
BadgeId = 333,
Mug = true
}
};
foreach (Commande cmd in commandes)
{
providerData.SaveCommande(cmd);
}
Check.That(context.Commandes.Count()).IsEqualTo(4);
var result = context.Commandes.FirstOrDefault(p => p.BadgeId == 222);
Check.That(result).IsNotNull();
result = context.Commandes.FirstOrDefault(p => p.BadgeId == 999);
Check.That(result).IsNull();
}
}
public void Add_Commande_To_Database()
{
var options = new DbContextOptionsBuilder <CommandeContext>()
.UseInMemoryDatabase(databaseName: "Add_Commande_To_Database")
.Options;
using (var context = new CommandeContext(options))
{
var providerData = new ProviderData(context);
Commande info = new Commande()
{
Boisson = Boisson.Cafe,
BadgeId = 456,
Mug = true
};
providerData.SaveCommande(info);
Check.That(context.Commandes).IsNotNull().And.CountIs(2);
}
}
public void Update_Last_Commande_For_BadgeId_In_Database()
{
var option = new DbContextOptionsBuilder <CommandeContext>()
.UseInMemoryDatabase(databaseName: "Add_Commande_To_Database")
.Options;
var context = new CommandeContext(option);
var providerData = new ProviderData(context);
providerData.SaveCommande(new Commande
{
Boisson = Boisson.Cafe,
Sucre = Quantite_Sucre.Elevee,
Mug = true,
BadgeId = 999
});
var resultat_1 = providerData.GetLastCommande(999);
Check.That(context.Commandes).CountIs(2);
Commande New_Commande = new Commande()
{
Boisson = Boisson.Chocolat,
Sucre = Quantite_Sucre.Sans_sucre,
Mug = false,
BadgeId = 999
};
providerData.SaveCommande(New_Commande);
Check.That(context.Commandes).CountIs(2);
var resultat_2 = providerData.GetLastCommande(999);
Check.That(context.Commandes).CountIs(2);
Check.That(resultat_2.Boisson).Equals(Boisson.Chocolat);
}
public PizzaRepository(CommandeContext context)
{
_Context = context;
}
