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