static void Main(string[] args)
{
Console.WriteLine("Johny's Bierwinkel");
Bier b1 = new Bier(1.05, "palm", Bierkleur.bruin, "palm", 25, 5.2, Setgrootte.zes);
Inventaris inventaris = new Inventaris();
inventaris.VoegBierToe(1.05, "palm", Bierkleur.bruin, "palm", 25, 5.2, Setgrootte.zes);
inventaris.VoegBierToe(1.25, "rodenbach classic", Bierkleur.amber, "palm", 25, 5.2, Setgrootte.zes);
inventaris.VoegBierToe(1.6, "leffe bruin", Bierkleur.bruin, "leffe", 33, 6.2, Setgrootte.zes);
inventaris.VoegBierToe(1.8, "duvel", Bierkleur.blond, "duvel moortgat", 33, 8.5, Setgrootte.vier);
Console.WriteLine("");
Console.WriteLine("1ste Bier:");
Bier x = inventaris.SelecteerBier("palm");
Console.WriteLine($"{x}");
Console.WriteLine("");
Console.WriteLine("2de Bier:");
Bier y = inventaris.ZoekBier(b1);
Console.WriteLine($"{y}");
Console.ReadLine();
}
public void save(Inventaris dbitem, int id)
{
if (dbitem.Id == 0) //create
{
context.Inventaris.Add(dbitem);
var query = "INSERT INTO dbo.\"Inventaris\" (\"TanggalPemberian\", \"TanggalPengembalian\", \"IdNamaBarang\", \"Keterangan\", \"DriverId\") VALUES (" + dbitem.TanggalPemberian + ", " +
dbitem.TanggalPengembalian + ", " + dbitem.IdNamaBarang + ", " + dbitem.Keterangan + ", " + dbitem.DriverId + ");";
var auditrail = new Auditrail {
Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Inventaris", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
}
else //edit
{
context.Inventaris.Attach(dbitem);
var query = "UPDATE dbo.\"Inventaris\" SET \"TanggalPemberian\" = " + dbitem.TanggalPemberian + ", \"TanggalPengembalian\" = " + dbitem.TanggalPengembalian + ", \"IdNamaBarang\" = " + dbitem.IdNamaBarang +
", \"Keterangan\" = " + dbitem.Keterangan + ", \"DriverId\" = " + dbitem.DriverId + " WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Inventaris", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
var entry = context.Entry(dbitem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
public void delete(Inventaris dbitem, int id)
{
context.Inventaris.Remove(dbitem);
var query = "DELETE FROM dbo.\"Inventaris\" WHERE \"Id\" = " + dbitem.Id + ";";
var auditrail = new Auditrail {
Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Inventaris", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id
};
context.Auditrail.Add(auditrail);
context.SaveChanges();
}
