public async Task <List <OrderLine> > GetOrderLines(string orderid) { List <OrderLine> OrderLineList = new List <OrderLine>(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = await OpenConnection(); cmd.CommandText = "SELECT * FROM bestelregel WHERE OrderID = @orderid"; cmd.Prepare(); cmd.Parameters.AddWithValue("@orderid", orderid); MySqlDataReader myReader = (await cmd.ExecuteReaderAsync() as MySqlDataReader); while (await myReader.ReadAsync()) { string OrderId = myReader.GetString("OrderID"); int Amount = myReader.GetInt32("Aantal"); int ProductId = myReader.GetInt32("DrankID"); OrderLine orderline = new OrderLine(OrderId, ProductId, Amount); OrderLineList.Add(orderline); } await myReader.CloseAsync(); await CloseConnection(); return(OrderLineList); }
public async Task <List <Order> > GetOrders(string userid) { List <Order> OrderList = new List <Order>(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = await OpenConnection(); cmd.CommandText = "SELECT * FROM bestelling WHERE UserID = @userid"; cmd.Prepare(); cmd.Parameters.AddWithValue("@userid", userid); MySqlDataReader myReader = (await cmd.ExecuteReaderAsync() as MySqlDataReader); while (await myReader.ReadAsync()) { string Message = myReader.GetString("Comment"); int Table = myReader.GetInt32("TableID"); string OrderId = myReader.GetString("OrderID"); DateTime OrderDate = myReader.GetDateTime("DatumBestel"); //DateTime DeliverDate = myReader.GetDateTime("DatumLever"); Order order = new Order(OrderId, OrderDate, Message, Table); OrderList.Add(order); } await myReader.CloseAsync(); await CloseConnection(); return(OrderList); }
public async Task <List <Product> > GetProducts() { List <Product> Productlist = new List <Product>(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = await OpenConnection(); cmd.CommandText = "SELECT * FROM artikel"; cmd.Prepare(); MySqlDataReader myReader = (await cmd.ExecuteReaderAsync() as MySqlDataReader); while (await myReader.ReadAsync()) { int id = myReader.GetInt32("DRANKid"); string name = myReader.GetString("Naam"); double price = myReader.GetDouble("Prijs"); string Description = myReader.GetString("Beschrijving"); double AmountCl = myReader.GetDouble("HoeveelheidCL"); int Stock = myReader.GetInt32("Stock"); double AlcPercent = myReader.GetDouble("AlcPercent"); Product drink = new Product(id, name, price, AlcPercent, Stock, AmountCl, Description); Productlist.Add(drink); } await myReader.CloseAsync(); await CloseConnection(); return(Productlist); }
public async Task <User> GetUser(string email) { MySqlCommand cmd = new MySqlCommand(); cmd.Connection = await OpenConnection(); cmd.CommandText = "SELECT * FROM klant WHERE Email = @email"; cmd.Prepare(); cmd.Parameters.AddWithValue("@email", email); MySqlDataReader myReader = (await cmd.ExecuteReaderAsync() as MySqlDataReader); bool result = await myReader.ReadAsync(); if (result) { string dbid = myReader.GetString("userID"); string dbusername = myReader.GetString("Naam"); string dbGender = myReader.GetString("Geslacht"); int dbAge = myReader.GetInt32("Leeftijd"); string dbEmail = myReader.GetString("Email"); await myReader.CloseAsync(); User loggedUser = new User(dbid, dbGender, dbAge, dbEmail, null, dbusername); await CloseConnection(); return(loggedUser); } else { await CloseConnection(); return(null); } }
public async static Task <string[, ]> GetMysqlSelect(string sql) { string[,] ReceivedDataRows; try { MySqlConnection conn = new MySqlConnection(starter.MysqlConnectionData_login); await conn.OpenAsync(); MySqlCommand command = new MySqlCommand(sql, conn); MySqlDataReader reader = await command.ExecuteReaderAsync(); int ColumnNumber = reader.FieldCount; List <string> dat = new List <string>(); int rows = 0; while (reader.Read()) { for (int i = 0; i < ColumnNumber; i++) { dat.Add(reader[i].ToString()); } rows++; } ReceivedDataRows = new string[rows, ColumnNumber]; int index = 0; for (int i = 0; i < rows; i++) { for (int u = 0; u < ColumnNumber; u++) { ReceivedDataRows[i, u] = dat[index]; index++; } } await reader.CloseAsync(); await conn.CloseAsync(); return(ReceivedDataRows); } catch (Exception ex) { Console.WriteLine("==============ERROR================\n" + ex + "\n" + sql + "\n" + DateTime.Now + "\n" + "==================ERROR_END===========\n"); } ReceivedDataRows = new string[1, 1]; ReceivedDataRows[0, 0] = "error"; return(ReceivedDataRows); }
public async Task CloseAsync() { await _reader.CloseAsync(); }