<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use App\Model\Book;
use App\Models\Book as ModelsBook;


class BookController extends Controller
{
      public function binding(ModelsBook $key) {
        return $key;
      }

    function operations() {
        return ModelsBook::all();
       }

    public  function mutator() {
       // return "hello its mutator function.";
      // return Book::all();
      $Book = new ModelsBook();
      $Book->hindi="56";
      $Book->english="45";
      $Book->maths="76";
      $Book->sst="45";
      $Book->science="8";
      $Book->sanskrit="45";
      $Book->punjabi="87";
      $Book->drawing="45";
      $Book->save();
       }

   //table
   public function index()
   {
       $books = DB::table('books')->get();
       return view('book.index', ['data' => $books]);
   }
//form
   public function create()
   {
       $books = DB::table('books')->get();
       return view('book.create', ['data' => $books]);
   }
//data store
   public function store(request $req)
   {
       $req->validate([
           'hindi' => 'required',
           'english' => 'required',
           'maths' => 'required',
           'sst' => 'required',
           'science' => 'required',
           'sanskrit' => 'required',
           'punjabi' => 'required',
           'drawing' => 'required'
       ]);
       $Book = DB::table('books')
           ->insert([
               'hindi' => $req->hindi,
               'english' => $req->english,
               'maths' => $req->maths,
               'sst' => $req->sst,
               'science' => $req->science,
               'sanskrit' => $req->sanskrit,
               'punjabi' => $req->punjabi,
               'drawing' => $req->drawing,
           ]);
//redirect to create
       if ($Book) {
           return redirect()->route('index')->with('message', "data inserted successfully...");
       } else {
           echo "<h1>error...</h1>";
       }
   }

}