/**
  * Display a listing of the resource.
  * GET /site\event
  *
  * @return Response
  */
 public function index()
 {
     View::share('title', 'Események');
     $events = Event::where('shows', '=', true)->orderBy('start', 'DESC')->select(['id', 'title', 'start', 'end', 'content'])->paginate(10);
     $events = Event::whereRaw('shows = ? ORDER BY start DESC', array(true))->paginate(10);
     $this->layout->content = View::make('site.event.index')->with('events', $events);
 }
 /**
  * Remove the specified resource from storage.
  * DELETE /admin\gallery/{id}
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($id)
 {
     try {
         $gallery = Gallery::find($id);
         Article::where('gallery_id', '=', $gallery->id)->update(array('gallery_id' => 0));
         Event::where('gallery_id', '=', $gallery->id)->update(array('gallery_id' => 0));
         Page::where('gallery_id', '=', $gallery->id)->update(array('gallery_id' => 0));
         if ($gallery->delete()) {
             return Response::json(['message' => 'A(z) ' . $id . ' azonosítójú galéria törlése sikerült!', 'status' => true]);
         } else {
             return Response::json(['message' => 'A(z) ' . $id . ' azonosítójú galéria törlése nem sikerült!', 'status' => false]);
         }
     } catch (Exception $e) {
         if (Config::get('app.debug')) {
             return Response::json(['message' => $e->getMessage(), 'status' => false]);
         } else {
             return Response::json(['message' => 'A(z) ' . $id . ' azonosítójú galéria törlése nem sikerült!', 'status' => false]);
         }
     }
 }