public ActionResult GeneralIndex(int?ide) { if (ide != null) { pres_id = Convert.ToInt32(ide); //IEnumerable<SelectListItem> list = new IEnumerable<SelectListItem>(); //var medications = db.Medications.Include(m => m.Medicin).Include(m => m.Medicin1); var medications = db.Medications.Where(me => me.Pres_Id == ide); List <Medicates> med = new List <Medicates>(); foreach (var item in medications) { Medicates md = new Medicates(); var med_names = db.Database.SqlQuery <string>(string.Format("Select Name from dbo.Medicin where Med_Id={0}", item.Med_Id)).ToList(); string name = med_names[0]; md.Pres_Id = item.Pres_Id; md.Med_Name = name; md.timings = item.timings; med.Add(md); } //return View(medications.ToList()); return(View(med)); } else { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } }
public ActionResult Create([Bind(Include = "Pres_Id,Med_Name,timings")] Medicates medication) { Medication med = new Medication(); try { if (ModelState.IsValid) { var med_ids = db.Database.SqlQuery <int>(string.Format("Select Med_Id from dbo.Medicin where Name='{0}'", medication.Med_Name)).ToList(); int med_id = med_ids[0]; med.Med_Id = med_id; med.Pres_Id = medication.Pres_Id; med.timings = medication.timings; //med.Med_Id = db.Medicins.Where(me => me.Name == medication.Med_Name); db.Medications.Add(med); db.SaveChanges(); return(RedirectToAction("Index", new { ide = medication.Pres_Id })); } } catch { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ViewBag.Med_Id = new SelectList(db.Medicins, "Med_Id", "Name", med.Med_Id); ViewBag.Med_Id = new SelectList(db.Medicins, "Med_Id", "Name", med.Med_Id); //return View(medication); return(RedirectToAction("Index", med.Pres_Id)); }