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

            db.Medicine_Information.Remove(medicine_information);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        //
        // GET: /Medicine/Details/5

        public ActionResult Details(int id = 0)
        {
            Medicine_Information medicine_information = db.Medicine_Information.Find(id);

            if (medicine_information == null)
            {
                return(HttpNotFound());
            }
            return(View(medicine_information));
        }
        //
        // GET: /Medicine/Edit/5

        public ActionResult Edit(int id = 0)
        {
            Medicine_Information medicine_information = db.Medicine_Information.Find(id);

            if (medicine_information == null)
            {
                return(HttpNotFound());
            }
            //ViewBag.Generic_ID = new SelectList(db.Drug_Generic_name, "ID", "Genric_Name", medicine_information.Generic_ID);
            ViewBag.Manufacturer_ID = new SelectList(db.Manufacturers, "ID", "Manufacturer_Name", medicine_information.Manufacturer_ID);
            return(View(medicine_information));
        }
 public ActionResult Edit(Medicine_Information medicine_information)
 {
     if (ModelState.IsValid)
     {
         db.Medicine_Information.Attach(medicine_information);
         db.Entry(medicine_information).Property(r => r.Medicine_Name).IsModified   = true;
         db.Entry(medicine_information).Property(r => r.Category).IsModified        = true;
         db.Entry(medicine_information).Property(r => r.Manufacturer_ID).IsModified = true;
         // db.Entry(medicine_information).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     else
     {
         return(View(medicine_information));
     }
     //ViewBag.Generic_ID = new SelectList(db.Drug_Generic_name, "ID", "Genric_Name", medicine_information.Generic_ID);
     // ViewBag.Manufacturer_ID = new SelectList(db.Manufacturers, "ID", "Manufacturer_Name", medicine_information.Manufacturer_ID);
 }
        public ActionResult Create(Medicine_Information medicine_information)
        {
            if (ModelState.IsValid)
            {
                try
                {
                    db.Medicine_Information.Add(medicine_information);
                    db.SaveChanges();
                    return(RedirectToAction("Index"));
                }
                catch
                {
                    ModelState.AddModelError("Error", "Generic Name Already Assigned");
                }
            }

            ViewBag.Generic_ID      = new SelectList(db.Drug_Generic_name, "ID", "Genric_Name", medicine_information.Generic_ID);
            ViewBag.Manufacturer_ID = new SelectList(db.Manufacturers, "ID", "Manufacturer_Name", medicine_information.Manufacturer_ID);
            return(View(medicine_information));
        }