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));
}
