public ActionResult Edit([Bind(Include = "driver_id,first_name,last_name,address,postal_code,city,province,corporation,phone,dob,nationality,gender,pp_number,license_number,license_expiry,medical_date,rate,rate_team")] table_driver table_driver)
 {
     if (ModelState.IsValid)
     {
         db.Entry(table_driver).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(table_driver));
 }
        //View Driver Details
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            table_driver table_driver = db.table_driver.Find(id);

            if (table_driver == null)
            {
                return(HttpNotFound());
            }
            return(View(table_driver));
        }
 public ActionResult Delete(int id)
 {
     try
     {
         table_driver table_driver = db.table_driver.Find(id);
         db.table_driver.Remove(table_driver);
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     catch (DataException)
     {
         return(RedirectToAction("Delete", new { id = id, saveChangesError = true }));
     }
     return(RedirectToAction("Index"));
 }
        //Delete Driver
        public ActionResult Delete(int?id, bool?saveChangesError = false)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            //
            if (saveChangesError.GetValueOrDefault())
            {
                ViewBag.ErrorMessage = "Delete failed.Try again.";
            }
            //
            table_driver table_driver = db.table_driver.Find(id);

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

            List <SelectListItem> provinceList = new List <SelectListItem>()
            {
                new SelectListItem()
                {
                    Text = "Alberta - AB", Value = "AB"
                },
                new SelectListItem()
                {
                    Text = "British Columbia - BC", Value = "BC"
                },
                new SelectListItem()
                {
                    Text = "Manitoba - MB", Value = "MB"
                },
                new SelectListItem()
                {
                    Text = "New Brunswick - NB", Value = "NB"
                },
                new SelectListItem()
                {
                    Text = "Newfoundland and Labrador - NL", Value = "NL"
                },
                new SelectListItem()
                {
                    Text = "Northwest Territories - NT", Value = "NT"
                },
                new SelectListItem()
                {
                    Text = "Nova Scotia - NS", Value = "NS"
                },
                new SelectListItem()
                {
                    Text = "Nunavut - NU", Value = "NU"
                },
                new SelectListItem()
                {
                    Text = "Ontario - ON", Value = "ON"
                },
                new SelectListItem()
                {
                    Text = "Prince Edward Island - PE", Value = "PE"
                },
                new SelectListItem()
                {
                    Text = "Quebec - QC", Value = "QC"
                },
                new SelectListItem()
                {
                    Text = "Saskatchewan - SK", Value = "SK"
                },
                new SelectListItem()
                {
                    Text = "Yukon - YT", Value = "YT"
                }
            };

            table_driver.provinceList = provinceList;

            List <SelectListItem> genderList = new List <SelectListItem>()
            {
                new SelectListItem()
                {
                    Text = "Male - M", Value = "M"
                },
                new SelectListItem()
                {
                    Text = "Female - F", Value = "F"
                }
            };

            table_driver.genderList = genderList;

            //
            if (table_driver == null)
            {
                return(HttpNotFound());
            }
            return(View(table_driver));
        }
        //Add Driver
        public ActionResult Create()
        {
            table_driver          obj          = new table_driver();
            List <SelectListItem> provinceList = new List <SelectListItem>()
            {
                new SelectListItem()
                {
                    Text = "Alberta - AB", Value = "AB"
                },
                new SelectListItem()
                {
                    Text = "British Columbia - BC", Value = "BC"
                },
                new SelectListItem()
                {
                    Text = "Manitoba - MB", Value = "MB"
                },
                new SelectListItem()
                {
                    Text = "New Brunswick - NB", Value = "NB"
                },
                new SelectListItem()
                {
                    Text = "Newfoundland and Labrador - NL", Value = "NL"
                },
                new SelectListItem()
                {
                    Text = "Northwest Territories - NT", Value = "NT"
                },
                new SelectListItem()
                {
                    Text = "Nova Scotia - NS", Value = "NS"
                },
                new SelectListItem()
                {
                    Text = "Nunavut - NU", Value = "NU"
                },
                new SelectListItem()
                {
                    Text = "Ontario - ON", Value = "ON"
                },
                new SelectListItem()
                {
                    Text = "Prince Edward Island - PE", Value = "PE"
                },
                new SelectListItem()
                {
                    Text = "Quebec - QC", Value = "QC"
                },
                new SelectListItem()
                {
                    Text = "Saskatchewan - SK", Value = "SK"
                },
                new SelectListItem()
                {
                    Text = "Yukon - YT", Value = "YT"
                }
            };

            obj.provinceList = provinceList;

            List <SelectListItem> genderList = new List <SelectListItem>()
            {
                new SelectListItem()
                {
                    Text = "Male - M", Value = "M"
                },
                new SelectListItem()
                {
                    Text = "Female - F", Value = "F"
                }
            };

            obj.genderList = genderList;

            return(View(obj));
            //return View();
        }