public List <Drank> GetAll()
{
try {
con.Open();
string sql = "select drank.drankID, drank.Naam, drank.Type, drank.Omschrijving, drank.AlcoholPercentage from drank order by AlcoholPercentage";
var cmd = new MySqlCommand(sql, con);
MySqlDataReader rdr = cmd.ExecuteReader();
List <Drank> DrankList = new List <Drank>();
while (rdr.Read())
{
Drank drank = new Drank();
drank.DrankID = rdr.GetInt16(0);
drank.Naam = rdr.GetString(1);
drank.Type = rdr.GetString(2);
drank.Omschrijving = rdr.GetString(3);
drank.AlcoholPecentage = rdr.GetDouble(4);
DrankList.Add(drank);
}
return(DrankList);
}
catch (Exception e)
{
Console.WriteLine(e);
return(null);
}
finally
{
con.Close();
}
}
public List <Drank> GetDrank()
{
try
{
List <Drank> Drank = Drank_db.Db_Get_All_Drank();
return(Drank);
}
catch (Exception e)
{
// something went wrong connecting to the database, so we will add a fake Drank to the list to make sure the rest of the application continues working!
List <Drank> Drank = new List <Drank>();
Drank a = new Drank();
a.Name = "Test Drank";
a.Number = 1;
a.Voorraad = 5;
a.Prijs = 3;
Drank.Add(a);
Drank b = new Drank();
b.Name = "Test Drank";
b.Number = 2;
b.Voorraad = 20;
b.Prijs = 2;
Drank.Add(b);
return(Drank);
//throw new Exception("Someren couldn't connect to the database");
}
}
public Drank GetDrankByID(int DrankID)
{
try {
con.Open();
string sql = "SELECT drank.drankID, drank.Naam, drank.Type, drank.Omschrijving, drank.AlcoholPercentage FROM drank WHERE DrankID = @ID";
var cmd = new MySqlCommand(sql, con);
cmd.Parameters.AddWithValue("@ID", DrankID);
MySqlDataReader rdr = cmd.ExecuteReader();
Drank drank = new Drank();
while (rdr.Read())
{
drank.DrankID = rdr.GetInt16(0);
drank.Naam = rdr.GetString(1);
drank.Type = rdr.GetString(2);
drank.Omschrijving = rdr.GetString(3);
drank.AlcoholPecentage = rdr.GetDouble(4);
}
return(drank);
}
catch (Exception e)
{
Console.WriteLine(e);
return(null);
}
finally
{
con.Close();
}
}
public List <Drank> GetNotInBucketlist(int BucketListID)
{
try
{
con.Open();
string sql = "SELECT drank.DrankID, drank.Naam , drank.Type, drank.Omschrijving, drank.AlcoholPercentage FROM Drank where drank.DrankID not in (select drank.DrankID FROM drank, buckelistentry WHERE buckelistentry.DrankID = drank.DrankID and buckelistentry.BucketListID = @bucketlistID) ";
var cmd = new MySqlCommand(sql, con);
cmd.Parameters.AddWithValue("@bucketlistID", BucketListID);
MySqlDataReader rdr = cmd.ExecuteReader();
List <Drank> DrankList = new List <Drank>();
while (rdr.Read())
{
Drank drank = new Drank();
drank.DrankID = rdr.GetInt16(0);
drank.Naam = rdr.GetString(1);
drank.Type = rdr.GetString(2);
drank.Omschrijving = rdr.GetString(3);
drank.AlcoholPecentage = rdr.GetDouble(4);
DrankList.Add(drank);
}
return(DrankList);
}
catch (Exception e)
{
Console.WriteLine(e);
return(null);
}
finally
{
con.Close();
}
}
public ViewResult Details(int?id)
{
Drank Model = _DrankRepository.GetDrank(id ?? 1);
ViewBag.PageTitle = "Employee Details";
return(View(Model));
}
public ViewResult Index()
{
Drank WMod = new Drank();
WMod.AllBooze = dbContext.Liquors.ToList();
WMod.NotBooze = dbContext.Mixers.ToList();
return(View("Index", WMod));
}
public IActionResult Create(Drank drank)
{
if (ModelState.IsValid)
{
Drank newDrank = _DrankRepository.Add(drank);
return(RedirectToAction("details", new { id = newDrank.Id }));
}
return(View());
}
public IActionResult CreateMixer(Drank FromForm)
{
if (ModelState.IsValid)
{
dbContext.Mixers.Add(FromForm.MixerForm);
dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
return(Index());
}
public string StockCheck(Drank d)
{
if (d.StockAmount >= 10)
{
return("Voldoende voorraad");
}
else
{
return("Voorraad bijna op!");
}
}
public IActionResult CreateDrank(Drank drank)
{
var Nieuwdrank = new Drank()
{
Naam = drank.Naam,
Type = drank.Type,
Omschrijving = drank.Omschrijving,
AlcoholPecentage = drank.AlcoholPecentage
};
_drankRepository.CreateDrank(Nieuwdrank);
return(RedirectToAction("Index"));
}
public Drank GetDrankById(int DrankId)
{
try
{
return(drank_db.GetById(DrankId));
}
catch (Exception)
{
Drank d = new Drank(3, "Nepdrank", 2, 3);
return(d);
}
}
private Drank ReadDrank(DataTable dataTable)
{
Drank drank = null;
foreach (DataRow dr in dataTable.Rows)
{
int Number = (int)dr["Dranknummer"];
string Name = (string)dr["dranknaam"];
int Amount = (int)dr["hoeveelheid"];
decimal Price = (decimal)dr["verkoopprijs"];
drank = new Drank(Number, Name, Amount, Price);
}
return(drank);
}
public List <Drank> GetDrinks()
{
try
{
return(drank_db.Db_Get_Some_Drinks());
}
catch (Exception)
{
List <Drank> neplijst = new List <Drank>();
Drank nietbestaandedrank1 = new Drank(1, "Screwdriver", 1000, 12);
neplijst.Add(nietbestaandedrank1);
return(neplijst);
}
}
public List <Drank> GetAllDrinks()
{
try
{
return(drank_db.Db_Get_All_Drinks());
}
catch (Exception)
{
List <Drank> nepdranken = new List <Drank>();
Drank nepdrank = new Drank(2, "Russian Roulette", 20, 4);
nepdranken.Add(nepdrank);
return(nepdranken);
}
}
private List <Drank> ReadTables(DataTable dataTable)
{
List <Drank> drinks = new List <Drank>();
foreach (DataRow dr in dataTable.Rows)
{
int Number = (int)dr["Dranknummer"];
string Name = (string)dr["dranknaam"];
int Amount = (int)dr["hoeveelheid"];
decimal Price = (decimal)dr["verkoopprijs"];
Drank drink = new Drank(Number, Name, Amount, Price);
drinks.Add(drink);
}
return(drinks);
}
public async Task <Drank> CreateDrank(CreateDrinkDTO viewModel)
{
//Zoeken naar type
var type = await _drankTypeRepo.FindByIdAsync(viewModel.TypeId);
if (type == null)
{
throw new EntityNotFoundException($"Dranktype met id {viewModel.TypeId} werd niet gevonden.");
}
var newDrank = Drank.Create(viewModel.Naam, viewModel.Prijs, type, viewModel.InStock);
await _drankRepository.AddAsync(newDrank);
await _drankRepository.SaveChangesAsync();
return(newDrank);
}
private List <Drank> ReadTables(DataTable dataTable)
{
List <Drank> dranken = new List <Drank>();
foreach (DataRow dr in dataTable.Rows)
{
Drank drank = new Drank()
{
Number = (int)dr["Drank_ID"],
Name = (String)(dr["Naam"].ToString()),
Voorraad = (int)dr["Voorraad"],
Prijs = (int)dr["Prijs"],
Voorraad_ID = (int)dr["Wordt_Bijgehouden"]
};
dranken.Add(drank);
}
return(dranken);
}
public List <Drank> GetDrankByAttribute(string Attribute, string data)
{
try {
con.Open();
string sql = "";
if (Attribute == "Type")
{
sql = "select drank.drankID, drank.Naam, drank.Type, drank.Omschrijving, drank.AlcoholPercentage from drank Where Type like @data";
}
if (Attribute == "Naam")
{
sql = "select drank.drankID, drank.Naam, drank.Type, drank.Omschrijving, drank.AlcoholPercentage from drank Where Naam like @data";
}
if (Attribute == "AlcoholPercentage")
{
sql = "select drank.drankID, drank.Naam, drank.Type, drank.Omschrijving, drank.AlcoholPercentage from drank Where AlcoholPercentage like @data";
}
var cmd = new MySqlCommand(sql, con);
cmd.Parameters.AddWithValue("@data", $"%{data}%");
MySqlDataReader rdr = cmd.ExecuteReader();
List <Drank> DrankList = new List <Drank>();
while (rdr.Read())
{
Drank drank = new Drank();
drank.DrankID = rdr.GetInt16(0);
drank.Naam = rdr.GetString(1);
drank.Type = rdr.GetString(2);
drank.Omschrijving = rdr.GetString(3);
drank.AlcoholPecentage = rdr.GetDouble(4);
DrankList.Add(drank);
}
return(DrankList);
}
catch (Exception e)
{
Console.WriteLine(e);
return(null);
}
finally
{
con.Close();
}
}
void IDrankRepository.CreateDrank(Drank drank)
{
try
{
con.Open();
string sql = "INSERT INTO `drank`(`Naam`, `Type`, `Omschrijving`, `AlcoholPercentage`) VALUES (@naam,@type,@omschrijving,@alcoholpercentage)";
var cmd = new MySqlCommand(sql, con);
cmd.Parameters.AddWithValue("@naam", drank.Naam);
cmd.Parameters.AddWithValue("@type", drank.Type);
cmd.Parameters.AddWithValue("@omschrijving", drank.Omschrijving);
cmd.Parameters.AddWithValue("@alcoholpercentage", drank.AlcoholPecentage);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine(e);
}
finally
{
con.Close();
}
}
public Task <Review> WriteReview(Drank drank, User user, string Text)
{
throw new NotImplementedException();
}
public ViewResult Edit(int id)
{
Drank drank = _DrankRepository.GetDrank(id);
return(View());
}
//code van de methode voor het klikken op de bereken omzet knop van de Omzetrapportage
private void OmzetBtn_Click(object sender, EventArgs e)
{
lblError.Text = "";
lv_Omzet.Items.Clear();
Bestelling_Kassa_Service bestellingService = new Bestelling_Kassa_Service();
Drank_Service dService = new Drank_Service();
Student_Service sService = new Student_Service();
StartCalendar.MaxSelectionCount = 1;
EindCalendar.MaxSelectionCount = 1;
DateTime startDate = StartCalendar.SelectionRange.Start; //hier stond eerst StartCalendar.SelectionStart;
DateTime endDate = EindCalendar.SelectionRange.Start;
if (!bestellingService.ValidDateRangeCheck(startDate, endDate))
{
lblError.Text = "Er is een ongeldige tijdsperiode opgegeven!";
}
else if (bestellingService.ValidDateRangeCheck(startDate, endDate))
{
List <Bestelling> bestellingsList = bestellingService.GetRangedOrders(startDate, endDate);
int aantaldranken = 0;
int aantalstudenten = 0;
decimal omzet = 0;
foreach (Bestelling b in bestellingsList)
{
Student student = sService.GetStudentById(b.Studentnummer);
if (student != null)
{
aantalstudenten++;
}
Drank drank = dService.GetDrankById(b.Dranknummer);
if (drank != null)
{
aantaldranken++;
}
decimal drankPrijs = drank.Price;
omzet += drankPrijs;
}
//decimal Omzettotaal = (aantaldranken * omzet);
ListViewItem Omzet = new ListViewItem(aantaldranken.ToString());
Omzet.SubItems.Add(omzet.ToString());
Omzet.SubItems.Add(aantalstudenten.ToString());
lv_Omzet.Items.Add(Omzet);
}
ShowPanel("Omzetrapportage");
}
// methode met de code voor het klikken op de bestellingsknop in het bestellingsmenu
private void OrderBtn_Click(object sender, EventArgs e)
{
Student_Service sService = new Student_Service();
Student student = sService.GetStudentById(cmb_Students.SelectedIndex + 1);
int studentNummer = student.Studentnumber;
Drank_Service dService = new Drank_Service();
Drank drank = dService.GetDrankById(cmb_Drinks.SelectedIndex + 1); //hier een + 1 vanwege het verschil in C# index tellen wat bij 0 begint, en de database entries die bij 1 beginnen...
int drankNummer = drank.DrankNumber;
studenttestlabel.Text = studentNummer.ToString(); //debugging test label voor studentnamen
dranktestlabel.Text = drankNummer.ToString(); //debugging test label voor dranken
Bestelling_Kassa_Service bestellingService = new Bestelling_Kassa_Service();
DateTime datum = DateTime.Now;
decimal Total = drank.Price;
bestellingService.PlaceOrder(datum, Total, drankNummer, studentNummer);
//dranktestlabel.Text = newOrderNumber.ToString();
//haal de lijst opnieuw op na het toevoegen van een bestelling
List <Bestelling> orderList = bestellingService.GetOrders();
//hier de listview van de bestellingen leegmaken om daarna weer te kunnen vullen
lv_Bestelling.Items.Clear();
foreach (Bestelling b in orderList)
{
//drankService.StockCheck(d);
ListViewItem Order = new ListViewItem(b.Bestellingsnummer.ToString());
Order.SubItems.Add(b.Datum.ToString());
Drank Ordereddrank = dService.GetDrankById(b.Dranknummer);
Order.SubItems.Add(Ordereddrank.DrankName.ToString());
Student OrderedStudent = sService.GetStudentById(b.Studentnummer);
Order.SubItems.Add(OrderedStudent.Studentname.ToString());
lv_Bestelling.Items.Add(Order);
}
Bestelling Kassaorder = orderList.Last();
Voorraad_Service vService = new Voorraad_Service();
Voorraad Kassavoorraad = vService.GetVoorraadByDrankId(Kassaorder.Dranknummer);
int stockNumber = Kassavoorraad.VoorraadNumber;
bestellingService.RegisterOrder(Kassaorder.Bestellingsnummer, stockNumber);
//attempt 1 to reset the screen
ShowPanel("Kassa");
}
private void ShowPanel(string panelName)
{
if (panelName == "Dashboard")
{
// hide all other panels
pnl_Students.Hide();
pnl_Lecturers.Hide();
pnl_Rooms.Hide();
pnl_Activiteitenlijst.Hide();
pnl_Drank.Hide();
pnl_Kassa.Hide();
pnl_Omzetrapportage.Hide();
pnl_Begeleiders.Hide();
// show dashboard
pnl_Dashboard.Show();
img_Dashboard.Show();
}
else if (panelName == "Students")
{
// hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Lecturers.Hide();
pnl_Rooms.Hide();
pnl_Activiteitenlijst.Hide();
pnl_Drank.Hide();
pnl_Kassa.Hide();
pnl_Omzetrapportage.Hide();
pnl_Begeleiders.Hide();
// show students
pnl_Students.Show();
// fill the students listview within the students panel with a list of students
SomerenLogic.Student_Service studService = new SomerenLogic.Student_Service();
List <Student> studentList = studService.GetStudents();
// clear the listview before filling it again
listViewStudents.Clear();
foreach (SomerenModel.Student s in studentList)
{
ListViewItem li = new ListViewItem(s.Studentname, s.Studentnumber);
listViewStudents.Items.Add(li);
}
}
else if (panelName == "Lecturers")
{
//hide all other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Rooms.Hide();
pnl_Activiteitenlijst.Hide();
pnl_Drank.Hide();
pnl_Kassa.Hide();
pnl_Omzetrapportage.Hide();
pnl_Begeleiders.Hide();
pnl_Lecturers.Show();
Teacher_Service teachService = new Teacher_Service();
List <Teacher> teacherList = teachService.GetTeachers();
listViewLecturers.Clear();
foreach (Teacher t in teacherList)
{
ListViewItem li = new ListViewItem(t.Teachername, t.Teachernumber);
listViewLecturers.Items.Add(li);
}
}
else if (panelName == "Rooms")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Lecturers.Hide();
pnl_Activiteitenlijst.Hide();
pnl_Drank.Hide();
pnl_Kassa.Hide();
pnl_Omzetrapportage.Hide();
pnl_Begeleiders.Hide();
pnl_Rooms.Show();
Room_Service roomService = new Room_Service();
List <Room> roomList = roomService.GetRooms();
ListRoomBox.Items.Clear();
foreach (Room r in roomList)
{
ListRoomBox.Items.Add(r.RoomToString());
}
}
else if (panelName == "Activities")
{
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Lecturers.Hide();
pnl_Rooms.Hide();
pnl_Drank.Hide();
pnl_Kassa.Hide();
pnl_Omzetrapportage.Hide();
pnl_Begeleiders.Hide();
pnl_Activiteitenlijst.Show();
Activity_Service activityService = new Activity_Service();
List <Activity> activityList = activityService.GetActivities();
lv_Activiteitenlijst.Items.Clear();
cmb_Activiteiten.Items.Clear();
foreach (Activity a in activityList)
{
ListViewItem li = new ListViewItem(a.Number.ToString());
li.SubItems.Add(a.Description.ToString());
li.SubItems.Add(a.StartTime.ToString());
li.SubItems.Add(a.NumberofStudents.ToString());
li.SubItems.Add(a.NumberofLecturers.ToString());
lv_Activiteitenlijst.Items.Add(li);
cmb_Activiteiten.Items.Add(a.ActiviteitcmbBoxToString());
}
cmb_Activiteiten.SelectedIndex = 0;
}
else if (panelName == "Drank")
{
//Hide all other panels (once again)
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Lecturers.Hide();
pnl_Rooms.Hide();
pnl_Activiteitenlijst.Hide();
pnl_Kassa.Hide();
pnl_Omzetrapportage.Hide();
pnl_Begeleiders.Hide();
//show the Drinks panel
pnl_Drank.Show();
Drank_Service drankService = new Drank_Service();
List <Drank> drankList = drankService.GetDrinks();
lv_Drank.Items.Clear();
foreach (Drank d in drankList)
{
//drankService.StockCheck(d);
ListViewItem li = new ListViewItem(d.DrankName.ToString());
li.SubItems.Add(d.StockAmount.ToString());
li.SubItems.Add(d.Price.ToString());
li.SubItems.Add(drankService.StockCheck(d));
lv_Drank.Items.Add(li);
}
}
else if (panelName == "Kassa")
{
//Hide all the other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Lecturers.Hide();
pnl_Rooms.Hide();
pnl_Activiteitenlijst.Hide();
pnl_Drank.Hide();
pnl_Omzetrapportage.Hide();
pnl_Begeleiders.Hide();
//show the Kassa panel
pnl_Kassa.Show();
cmb_Students.Items.Clear();
Student_Service studentService = new Student_Service();
List <Student> studentList = studentService.GetStudents();
foreach (Student s in studentList)
{
cmb_Students.Items.Add(s.Studentname);
}
//eerste student selecteren als standaard.
cmb_Students.SelectedIndex = 0;
cmb_Drinks.Items.Clear();
Drank_Service drinksService = new Drank_Service();
List <Drank> drankList = drinksService.GetAllDrinks();
foreach (Drank d in drankList)
{
cmb_Drinks.Items.Add(d.DrankName);
}
//eerste drank selecteren als standaard.
cmb_Drinks.SelectedIndex = 0;
Bestelling_Kassa_Service bestellingService = new Bestelling_Kassa_Service();
List <Bestelling> orderList = bestellingService.GetOrders();
//hier de listview van de bestellingen leegmaken om daarna weer te kunnen vullen
lv_Bestelling.Items.Clear();
foreach (Bestelling b in orderList)
{
//drankService.StockCheck(d);
ListViewItem Order = new ListViewItem(b.Bestellingsnummer.ToString());
Order.SubItems.Add(b.Datum.ToString());
Drank Ordereddrank = drinksService.GetDrankById(b.Dranknummer);
Order.SubItems.Add(Ordereddrank.DrankName.ToString());
Student OrderedStudent = studentService.GetStudentById(b.Studentnummer);
Order.SubItems.Add(OrderedStudent.Studentname.ToString());
lv_Bestelling.Items.Add(Order);
}
}
else if (panelName == "Omzetrapportage")
{
//Hide all the other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Lecturers.Hide();
pnl_Rooms.Hide();
pnl_Activiteitenlijst.Hide();
pnl_Drank.Hide();
pnl_Kassa.Hide();
pnl_Begeleiders.Hide();
//show this panel
pnl_Omzetrapportage.Show();
}
else if (panelName == "Begeleiders")
{
//Hide all the other panels
pnl_Dashboard.Hide();
img_Dashboard.Hide();
pnl_Students.Hide();
pnl_Lecturers.Hide();
pnl_Rooms.Hide();
pnl_Activiteitenlijst.Hide();
pnl_Drank.Hide();
pnl_Kassa.Hide();
pnl_Omzetrapportage.Hide();
//show this panel
pnl_Begeleiders.Show();
Begeleider_Service begeleiderService = new Begeleider_Service();
List <Begeleider> begeleiderList = begeleiderService.GetBegeleiders();
lv_Begeleiders.Items.Clear();
cmb_Begeleiders.Items.Clear();
foreach (Begeleider b in begeleiderList)
{
ListViewItem li = new ListViewItem(b.Begeleidernummer.ToString());
li.SubItems.Add(b.Teachernumber.ToString());
li.SubItems.Add(b.Teachername.ToString());
li.SubItems.Add(b.Subject.ToString());
li.SubItems.Add(b.Teacherroomnumber.ToString());
lv_Begeleiders.Items.Add(li);
cmb_Begeleiders.Items.Add(b.Begeleidernummer.ToString());
}
cmb_Begeleiders.SelectedIndex = 0;
Teacher_Service teacherService = new Teacher_Service();
List <Teacher> teacherList = teacherService.GetTeachers();
cmb_Docenten.Items.Clear();
foreach (Teacher t in teacherList)
{
cmb_Docenten.Items.Add(t.Teachernumber);
}
cmb_Docenten.SelectedIndex = 0;
}
}
public OrderServiceTest()
{
_defaultDrankType = new DrankType();
_defaultDrank = Drank.Create("Coca-Cola", 1, _defaultDrankType, true);
}
public DrankTest()
{
_drank = Drank.Create(_naam, _prijs, _type, _inStock);
}
public void UpdateDrank(Drank drank)
{
//"UPDATE `drank` SET `Naam`=[value-2],`Type`=[value-3],`Omschrijving`=[value-4],`AlcoholPercentage`=[value-5] WHERE DrankID = @drankID"
throw new NotImplementedException();
}
public OrderlineTest()
{
_drank = Drank.Create(_naam, _prijs, _type, _inStock);
_leiding = new Leiding();
_order = Order.Create(_leiding);
}
public List <Bestelling> GetBestellingen()
{
List <Bestelling> returnList = new List <Bestelling>();
using (SqlConnection connection = new SqlConnection(conn))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand("SELECT b.BestellingID, k.Adres, k.Naam, b.KlantID FROM Bestellingen b LEFT JOIN Klanten k ON b.KlantID = k.KlantID", connection))
{
cmd.Connection = connection;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (!reader.IsDBNull(2))
{
returnList.Add(new Bestelling()
{
ID = reader.GetInt32(0),
Klant = new Klant(reader.GetString(2), reader.GetString(1), reader.GetInt32(3))
});
}
else
{
returnList.Add(new Bestelling()
{
ID = reader.GetInt32(0)
});
}
}
}
}
}
foreach (Bestelling bestelling in returnList)
{
bestelling.Items = new List <Item>();
List <int> pizzaIDs = new List <int>();
List <int> saladeIDs = new List <int>();
List <int> drankenIDs = new List <int>();
using (SqlConnection connection = new SqlConnection(conn))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand("SELECT PizzaID FROM PizzaItems WHERE BestellingID = @bestellingID", connection))
{
cmd.Connection = connection;
cmd.Parameters.Add("@bestellingID", SqlDbType.Int).Value = bestelling.ID;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
pizzaIDs.Add(reader.GetInt32(0));
}
}
}
using (SqlCommand cmd = new SqlCommand("SELECT SaladeID FROM SaladeItems WHERE BestellingID = @bestellingID", connection))
{
cmd.Connection = connection;
cmd.Parameters.Add("@bestellingID", SqlDbType.Int).Value = bestelling.ID;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
saladeIDs.Add(reader.GetInt32(0));
}
}
}
using (SqlCommand cmd = new SqlCommand("SELECT DrankID FROM DrankItems WHERE BestellingID = @bestellingID", connection))
{
cmd.Connection = connection;
cmd.Parameters.Add("@bestellingID", SqlDbType.Int).Value = bestelling.ID;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
drankenIDs.Add(reader.GetInt32(0));
}
}
}
}
foreach (int id in pizzaIDs)
{
Pizza temp = itemRepo.GetPizzaByID(id);
if (temp != null)
{
bestelling.Items.Add(temp);
}
}
foreach (int id in saladeIDs)
{
Salade temp = itemRepo.GetSaladeByID(id);
if (temp != null)
{
bestelling.Items.Add(temp);
}
}
foreach (int id in drankenIDs)
{
Drank temp = itemRepo.GetDrankByID(id);
if (temp != null)
{
bestelling.Items.Add(temp);
}
}
}
return(returnList);
}
