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();
}
