// CreateOrder public async Task <int> CreateOrder(OrderModel order) { DynamicParameters p = new DynamicParameters(); p.Add("OrderName", order.OrderName); p.Add("OrderDate", order.OrderDate); p.Add("FoodId", order.FoodId); p.Add("Quantity", order.Quantity); p.Add("Total", order.Total); p.Add("Id", DbType.Int32, direction: ParameterDirection.Output); await _db.SaveData("dbo.spOrders_Insert", p, _connectionString.ConnectionStringName); return(p.Get <int>("Id")); }