<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;
use Illuminate\Http\Request;

class DBmodel extends Model
{
     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 ]);
    }

}