public JsonResult GetVehicleInformation(string VehicleNumber)
        {
            var VehCRUD            = new VehicleCRUD();
            var VehicleInformation = VehCRUD.GetVehicleInformation(VehicleNumber);

            return(Json(VehicleInformation, JsonRequestBehavior.AllowGet));
        }
        //Afzal Work from Here
        // Ride phase
        //For Bus

        //For Truck

        /*
         *         public ActionResult AdminTruckride(int livecompanyid= 0)
         * {
         *  RideCRUDViewModel ridelist = new RideCRUDViewModel();
         *  var rides = ridelist.GetAllRide(livecompanyid);
         *  if(rides.Count()==0)
         *  {
         *      TempData["message"] = "No Ride Available";
         *  }
         *  return View(rides);
         * }
         *
         * public ActionResult AdminTruckAddRide(int id = 0, int companyid = 0)
         * {
         *  Ride editride = new Ride();
         *  RideCRUDViewModel TruckRide = new RideCRUDViewModel();
         *  VehiclesCrudViewModel TruckList = new VehiclesCrudViewModel();
         *  var cities = TruckRide.CityList();
         *  var drivers = TruckRide.DriverList(companyid);
         *  //Callthis Method from VehicleCRudView
         *  var vehicles = TruckList.TruckList(companyid);
         *  var viewmodel=new RideViewModel();
         *  if(id==0)
         *  {
         *      viewmodel = new RideViewModel(new Ride())
         *      {
         *          Vehicles = vehicles,
         *          Drivers = drivers,
         *          Cities = cities
         *      };
         *  }
         *  else
         *  {
         *
         *          editride = TruckRide.editride(id,companyid);
         *          viewmodel = new RideViewModel(new Ride())
         *          {
         *              Vehicles = vehicles,
         *              Drivers = drivers,
         *              Cities = cities,
         *              RideId = editride.RideId,
         *              RideSource = editride.RideSource,
         *              RideDestination = editride.RideDestination,
         *              RideDieselExpense = editride.RideDieselExpense,
         *              RideMaintainanceExpense = editride.RideMaintainanceExpense,
         *              RideFoodExpense = editride.RideFoodExpense,
         *              RideMobileExpense = editride.RideMobileExpense,
         *              RideTaxExpense = editride.RideTaxExpense,
         *              RideDriverCharge = editride.RideDriverCharge,
         *              RideCommisionCharge = editride.RideCommisionCharge,
         *              RideDieselQuantity = editride.RideDieselQuantity,
         *              RideDriverId = editride.RideDriverId,
         *              RideVehicleNumber = editride.RideVehicleNumber,
         *              RideProdit = editride.RideProdit,
         *              RideSeller = editride.RideSeller,
         *              RideBuyer = editride.RideBuyer,
         *              RideFare = editride.RideFare,
         *              RideDetail = editride.RideDetail,
         *              RideDate = editride.RideDate,
         *          };
         *
         *  }
         *
         *  return View(viewmodel);
         * }
         * [HttpPost]
         * [ValidateAntiForgeryToken]
         * public ActionResult AdminTruckAddRide(Ride ride)
         * {
         *
         *
         *  ModelState["RideConductorName"].Errors.Clear();
         *  ModelState["RidePassengerFare"].Errors.Clear();
         *  ModelState["RidePassengers"].Errors.Clear();
         *  //ModelState["RideDetail"].Errors.Clear();
         *  string message = "";
         *  RideCRUDViewModel CreateRide=new RideCRUDViewModel();
         *  var viewmodel = new RideViewModel();
         *  if(ModelState.IsValid)
         *  {
         *      if (ride.RideId == 0)
         *      {
         *
         *          message = CreateRide.CreateRide(ride);
         *          if (message != "")
         *          {
         *
         *              var cities = CreateRide.CityList();
         *              var drivers = CreateRide.DriverList(ride.CompanyId);
         *              var vehicles = CreateRide.TruckList();
         *              viewmodel = new RideViewModel(new Ride())
         *              {
         *                  Vehicles = vehicles,
         *                  Drivers = drivers,
         *                  Cities = cities,
         *              };
         *              TempData["message"] = message;
         *              return RedirectToAction("AdminTruckride", new { livecompanyid = Session["user_Id"] });
         *
         *          }
         *          else
         *          {
         *              TempData["message"] = "Problem During Adding Ride";
         *              return RedirectToAction("AdminTruckAddRide", new { livecompanyid = Session["user_Id"]});
         *          }
         *      }
         *      else
         *      {
         *          RideCRUDViewModel UpdateRide = new RideCRUDViewModel();
         *          message = UpdateRide.RideUpdate(ride);
         *          if (message != "")
         *          {
         *              TempData["message"] = message;
         *              TempData.Keep();
         *              return RedirectToAction("AdminTruckride", new { livecompanyid = Session["user_Id"] });
         *          }
         *          else
         *          {
         *              TempData["message"] = "Problem During Update Ride";
         *              return RedirectToAction("AdminTruckAddRide", new { livecompanyid = Session["user_Id"] });
         *          }
         *      }
         *
         *  }
         *  else
         *  {
         *      var cities = CreateRide.CityList();
         *      var drivers = CreateRide.DriverList(ride.CompanyId);
         *      var vehicles = CreateRide.TruckList();
         *      viewmodel = new RideViewModel(new Ride())
         *      {
         *          Vehicles = vehicles,
         *          Drivers = drivers,
         *          Cities = cities,
         *      };
         *  }
         *
         *
         *  return View(viewmodel);
         * }
         * public ActionResult AdmintruckrideDetail(int id=0,int companyid=0 )
         * {
         *
         *  RideCRUDViewModel TruckRide = new RideCRUDViewModel();
         *  //Return Detail of the truck Ride
         *  Ride busdetail = TruckRide.editride(id, companyid);
         *
         *  return View(busdetail);
         * }
         * public ActionResult AdminTruckDeleteRide(int Id=0)
         * {
         *  RideCRUDViewModel deleteride=new RideCRUDViewModel();
         *  string message=deleteride.RideDelete(Id);
         *  if (message != "")
         *      {
         *          TempData["message"] = message;
         *          TempData.Keep();
         *          return RedirectToAction("AdminTruckride", new { livecompanyid = Session["user_Id"] });
         *      }
         *      else
         *      {
         *          TempData["message"] = "Problem During Delete Ride";
         *          TempData.Keep();
         *          return RedirectToAction("AdminTruckride", new { livecompanyid = Session["user_Id"] });
         *      }
         * }
         *
         *
         *
         *
         * */



        ////Builty Module start here

        public JsonResult VehicleNumber(string Prefix)
        {
            var VehCRUD = new VehicleCRUD();
            var ObjList = VehCRUD.VehicleList();
            //Searching records from list using LINQ query
            var VehicleData = (from N in ObjList
                               where N.VehicleNumber.StartsWith(Prefix)
                               select new { N.VehicleNumber });

            return(Json(VehicleData, JsonRequestBehavior.AllowGet));
        }