public ActionResult DeleteConfirmed(int id)
        {
            tbl_drivers_vehicles_rel tbl_drivers_vehicles_rel = db.tbl_drivers_vehicles_rel.Find(id);

            db.tbl_drivers_vehicles_rel.Remove(tbl_drivers_vehicles_rel);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "id,driver_id,vehicle_id,created_at,created_by")] tbl_drivers_vehicles_rel tbl_drivers_vehicles_rel)
 {
     if (ModelState.IsValid)
     {
         db.Entry(tbl_drivers_vehicles_rel).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.driver_id  = new SelectList(db.tbl_accounts, "id", "first_name", tbl_drivers_vehicles_rel.driver_id);
     ViewBag.vehicle_id = new SelectList(db.tbl_vehicles, "id", "model", tbl_drivers_vehicles_rel.vehicle_id);
     return(View(tbl_drivers_vehicles_rel));
 }
        // GET: tbl_drivers_vehicles_rel/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tbl_drivers_vehicles_rel tbl_drivers_vehicles_rel = db.tbl_drivers_vehicles_rel.Find(id);

            if (tbl_drivers_vehicles_rel == null)
            {
                return(HttpNotFound());
            }
            return(View(tbl_drivers_vehicles_rel));
        }
        // GET: tbl_drivers_vehicles_rel/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tbl_drivers_vehicles_rel tbl_drivers_vehicles_rel = db.tbl_drivers_vehicles_rel.Find(id);

            if (tbl_drivers_vehicles_rel == null)
            {
                return(HttpNotFound());
            }
            ViewBag.driver_id  = new SelectList(db.tbl_accounts, "id", "first_name", tbl_drivers_vehicles_rel.driver_id);
            ViewBag.vehicle_id = new SelectList(db.tbl_vehicles, "id", "model", tbl_drivers_vehicles_rel.vehicle_id);
            return(View(tbl_drivers_vehicles_rel));
        }
Esempio n. 5
0
        public ActionResult AssginVehcileToDriver(FormCollection form)
        {
            var vehcile_id = int.Parse(form.Get("vehicle_id") == null?"0": form.Get("vehicle_id"));
            var driver_id  = int.Parse(form.Get("account_id") == null?"0": form.Get("account_id"));

            tbl_drivers_vehicles_rel rel = new tbl_drivers_vehicles_rel()
            {
                vehicle_id = vehcile_id,
                driver_id  = driver_id,
                created_at = DateTime.Now,
                created_by = UserSession.User.user_id,
                status     = 0,
            };

            db.tbl_drivers_vehicles_rel.Add(rel);

            if (db.SaveChanges() <= 0)
            {
                return(Json(new { type = "error", message = "" }));
            }
            tbl_accounts driver = db.tbl_accounts.Include(t => t.sec_users).FirstOrDefault(a => a.id == driver_id);

            return(Json(new { type = "success", message = "Your request sent to " + driver.first_name + " " + driver.last_name + ", Please wait for his action" }));
        }