public JsonResult TruckOwners(string term)
 {
     term = term.ToLower();
     IList<string> list = new TankTruckRepository(_sqlConnectionString).OwnersList;
     var result = list.Where(c => c.ToLower().Contains(term)).Take(10);
     return Json(result, JsonRequestBehavior.AllowGet);
 }
 public JsonResult TankTucks(string term)
 {
     term = term.ToUpper();
     TankTruckRepository tt = new TankTruckRepository(_sqlConnectionString);
     IList<string> ttList = tt.TankTruckNosList;
     var result = ttList.Where(t => t.Contains(term)).Take(10);
     return Json(result, JsonRequestBehavior.AllowGet);
 }
        public ActionResult Create([Bind(Include = "DriverName,DriverMobileNo,AssignedTT")] Driver driver)
        {
            if (ModelState.IsValid)
            {
                TankTruckRepository tt = new TankTruckRepository(_sqlConnectionString);
                if (tt.VerifyTruckNo(driver.AssignedTT))
                {
                    _driverRepository.Create(driver);
                    return RedirectToAction("Index");
                }
                driver.AssignedTT = string.Empty;
                return View(driver);
            }

            return View();
        }
        public ActionResult Edit([Bind(Include = "Id,DriverName,DriverMobileNo,AssignedTT")] Driver driver)
        {
            if (ModelState.IsValid)
            {
                TankTruckRepository tt = new TankTruckRepository(_sqlConnectionString);
                if (tt.VerifyTruckNo(driver.AssignedTT))
                {
                    _driverRepository.Update(driver);
                    //return Redirect(Request.UrlReferrer.ToString());
                    return RedirectToAction("Index");
                }
                driver.AssignedTT = string.Empty;
                return View(driver);
            }

            return View();
        }