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

class Dataentry extends Controller
{

		public function index() {

				$data = DB::table('userstable')->simplePaginate(5);
       			return view('dataentry', ['users' => $data]);

		}


		public function doindex(Request $id) {

				$data = DB::table('userstable')->simplePaginate(3);
				$data2 = DB::table('userstable')->where('userid', '')->get();
       			return view('dataentry', ['users' => $data, 'usersel' => $data2]);

		}



		public function doshowrecord($id) {

				$data = DB::table('userstable')->simplePaginate(3);
				$data2 = DB::table('userstable')->where('userid', $id)->get();
       			return view('dataentry', ['users' => $data, 'usersel' => $data2]);

		}



		public function doDatamanipulation(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');
				 //$data = DB::table('userstable')->simplePaginate(2);
       			// return view('dataentry', ['users' => $data]);

				return redirect('DE');
		}

		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 ]);
		}

}