Untitled

<?php
namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use App\Models\Employees;

class EmployeeController extends Controller
{
    public function getEmployees()
    {
        try {
            $sql = "SELECT * FROM employees";
            $employees = DB::connection('DBTraining')->select($sql);

            return response()->json([
                'from' => 'Public function getEmployees',
                'data' => $employees
            ], 200); // OK
        } catch (\Throwable $th) {
            return response()->json([
                'from' => 'Public function getEmployees',
                'error' => $th->getMessage(),
            ], 500); // Internal Server Error
        }
    }

    public function InsertEmployees(Request $request){
        try{
            //DB Raw
            // $sql = "
            //     INSERT INTO employees
            //         (id, name, age, department_id, section_id, team_id)
            //     VALUES 
            //         (?,?,?,?,?,?)
            // ";
            // DB:: connection('DBTraining')->insert($sql,[
            //     $request->id,
            //     $request->name,
            //     $request->age,
            //     $request->department_id,
            //     $request->section_id,
            //     $request->team_id,
               
            // ]);

                DB::connection('DBTraining')
                ->table('employees')
                ->insert([
                    'id' => $request->id,
                    'name' => $request->name,
                    'age' => $request->age,
                    'department_id' => $request->department_id,
                    'section_id' => $request->section_id,
                    'team_id' => $request->team_id,
                    
                ]);


            return response()->json([
                'from' => 'public function InsertEmployees',
            ], 200);  
        } catch (\Throwable $th) {
            return response()->json([
                'from' => 'Public function InsertEmployees',
                'error' => $th->getMessage(),
            ], 500);
        }
    }
}