public List <CateringEvent> GetAllItems()
{
List <CateringEvent> allCateringEvents = new List <CateringEvent>();
// string cs = @"URI=file:../OrderEvent.db";
// using var con = new SQLiteConnection(cs);
// con.Open();
ConnectionString myConnection = new ConnectionString();
string cs = myConnection.cs;
using var con = new MySqlConnection(cs);
con.Open();
string stm = "SELECT * FROM OrderEvent";
using var cmd = new MySqlCommand(stm, con);
using MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
CateringEvent temp = new CateringEvent()
{
orderID = rdr.GetInt32(0), orderPlaced = rdr.GetDateTime(10), orderDate = rdr.GetDateTime(10), fulfilledStatus = rdr.GetBoolean(5), orderEventMethod = rdr.GetInt32(2), orderDescription = rdr.GetString(32)
};
allCateringEvents.Add(temp);
}
return(allCateringEvents);
}
public void Post([FromBody] CateringEvent value)
{
Console.WriteLine(value);
iPostEvent insertObject = new saveEventData();
insertObject.UpdateEvent(value.orderID, value.orderPlaced, value.orderDate, value.fulfilledStatus, value.orderEventMethod, value.orderDescription);
}
public void Put(int id, [FromBody] CateringEvent value)
{
iAddEvent putObject = new addEvent();
putObject.addOrderEvent(value.orderID, value.orderPlaced, value.orderDate, value.fulfilledStatus, value.orderEventMethod, value.orderDescription);
}
protected virtual void OnCateringEvent(CateringOrder order, Flight flight)
{
CateringEvent?.Invoke(this, new CateringEventArgs {
Flight = flight, Order = order
});
}
