<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Illuminate\Http\Response;
use Illuminate\Support\Facades\DB;

class Dataentry extends Controller
{
	 public function index(){
	 	return view('dataentry');
	 }


	 public function doDM(Request $req){
	 	$vOption = $req->input('btnSubmit');
	 	 switch($vOption){
		 	case "Add":
					$this->doInsert($req);
					break;
			case "Delete":
					$this->doDelete($req);
					break;
			case "Update":
					$this->doUpdate($req);
					break;
		 }
		 $page ='dataentry';
		 return redirect($page);
	 }

     public function doInsert(Request $req){
  		 $vSQL = ' Insert Into usermaster ';
		 $vSQL .= '(userid, username, password, userlevel, status)';
		 $vSQL .= ' values (?, ?, ?, ?, ?)';

		 $vUserid = $req->input('txtuserid');
		 $vUsername = $req->input('txtusername');
		 $vPass = $req->input('txtpassword');
		 $vLevel = $req->input('txtuserlevel');
		 $vStatus= $req->input('txtstatus');

	     DB::insert($vSQL, [$vUserid, $vUsername, $vPass, $vLevel, $vStatus] );
     }

     public function doDelete(Request $req) {
	 	$vSQL = 'Delete From usermaster where userid = ?';
		$vUserid = $vUserid = $req->input('txtuserid');
		$deleted  = DB::delete($vSQL, [$vUserid ]);
     }

	public function doUpdate(Request $req) {
	 	$vSQL = "Update usermaster set password=?, username=?, userlevel=?, status=? where userid=?";
		 $vUserid = $req->input('txtuserid');
		 $vUsername = $req->input('txtusername');
		 $vPass = $req->input('txtpassword');
		 $vLevel = $req->input('txtuserlevel');
		 $vStatus= $req->input('txtstatus');
		$affected  = DB::update($vSQL, [$vPass, $vUsername, $vLevel, $vStatus, $vUserid ]);
    }


}