public ActionResult Create(DETAILED_ETHINICITY_TABLE detailed_ethinicity_table)
        {
            //reset the id
            if (ModelState.ContainsKey("DETAILED_ETHINICITY_ID"))
                ModelState["DETAILED_ETHINICITY_ID"].Errors.Clear();

            if (ModelState.IsValid)
            {
                db.DETAILED_ETHINICITY_TABLE.Add(detailed_ethinicity_table);
                db.SaveChanges();
                TempData["notice"] = "The New Ethinicity Has Been Successfully Added";
                return RedirectToAction("Index");
            }

            ViewBag.ETHINICITY_ID = new SelectList(db.ETHINICITY_TABLE, "ETHINICITY_ID", "ETHINICITY", detailed_ethinicity_table.ETHINICITY_ID);
            return View(detailed_ethinicity_table);
        }
 public ActionResult Edit(DETAILED_ETHINICITY_TABLE detailed_ethinicity_table)
 {
     if (ModelState.IsValid)
     {
         db.Entry(detailed_ethinicity_table).State = EntityState.Modified;
         db.SaveChanges();
         TempData["notice"] = "Ethinicity Has Been Successfully Changed";
         return RedirectToAction("Index");
     }
     ViewBag.ETHINICITY_ID = new SelectList(db.ETHINICITY_TABLE, "ETHINICITY_ID", "ETHINICITY", detailed_ethinicity_table.ETHINICITY_ID);
     return View(detailed_ethinicity_table);
 }