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

class Dataentry extends Controller
{
		public function doDatamainpulation(Request $req){

			$bvalue = $req->buttoncrud;

				$vReturn = $bvalue;

				if($bvalue == "Add"){

					$this->doInsert($req);

				} else if($bvalue == "Update"){

					$this->doUpdate($req);

				} else if($bvalue == "Delete"){

					$this->doDelete($req);
				}

				return view('dataentry');
		}

		public function doInsert(Request $req) {


			$vSQL = 'Insert Into userstable (userid, username, password, userlevel, status) values (?, ?, ?, ?, ?)';
			$vUserid = $req->txtuserid;
			$vUsername = $req->txtname;
			$vPass = $req->txtpassword;
			$vLevel = $req->txtlevel;
			$vStatus= $req->txtstatus;
			DB::insert($vSQL, [$vUserid , $vUsername, $vPass, $vLevel, $vStatus ]);

		}

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

		}

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

}