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

            db.consultant_biography.Remove(consultant_biography);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "ID,consultant_id,bio_txt,show,bio_descr")] consultant_biography consultant_biography)
 {
     if (ModelState.IsValid)
     {
         consultant_biography.show_RIC        = "No";
         db.Entry(consultant_biography).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index", new { consultant_id = consultant_biography.consultant_id }));
     }
     //ViewBag.consultant_id = new SelectList(db.consultants, "ID", "consultant_nm", consultant_biography.consultant_id);
     return(View(consultant_biography));
 }
        // GET: Biography/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            consultant_biography consultant_biography = db.consultant_biography.Find(id);

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

            if (consultant_biography == null)
            {
                return(HttpNotFound());
            }
            //ViewBag.consultant_id = new SelectList(db.consultants, "ID", "consultant_nm", consultant_biography.consultant_id);
            return(View(consultant_biography));
        }
        public ActionResult Create([Bind(Include = "ID,consultant_id,bio_txt,show,bio_descr")] consultant_biography consultant_biography)
        {
            if (ModelState.IsValid)
            {
                // column "show_RIC" is non-nullable legacy baggage and is not used.
                // still, we need to give it a value or the Save will fail
                consultant_biography.show_RIC = (consultant_biography.show ? "Yes" : "No");

                db.consultant_biography.Add(consultant_biography);
                db.SaveChanges();
                return(RedirectToAction("Index", new { consultant_id = consultant_biography.consultant_id }));
            }

            ViewBag.consultant_id = new SelectList(db.consultants, "ID", "consultant_nm", consultant_biography.consultant_id);
            return(View(consultant_biography));
        }