public ActionResult Delete(int sn, string pId, string sId, string dId)
{
dep_sym_ref data = (from m in db.dep_sym_ref
where m.dep_sym_sn == sn && m.part_id == pId && m.sym_id == sId && m.dep_id == dId
select m).FirstOrDefault();
db.dep_sym_ref.Remove(data);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(dep_sym_ref sd)
{
dep_sym_ref data = (from m in db.dep_sym_ref
where m.dep_sym_sn == sd.dep_sym_sn
select m).FirstOrDefault();
if (data == null)
{
return(HttpNotFound());
}
data.part_id = sd.part_id;
data.sym_id = sd.sym_id;
data.dep_id = sd.dep_id;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(int?sn, string pId, string sId, string dId)
{
if (sn == null || pId == null || sId == null || dId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
dep_sym_ref data = (from m in db.dep_sym_ref
where m.dep_sym_sn == sn && m.part_id == pId && m.sym_id == sId && m.dep_id == dId
select m).FirstOrDefault();
if (data == null)
{
return(HttpNotFound());
}
SymptomDepartment sd = new SymptomDepartment()
{
bodypartList = db.bodypart.ToList(),
symptomList = db.symptom.ToList(),
departmentList = db.department.ToList(),
depSymRef = data
};
return(View(sd));
}
public ActionResult Create(dep_sym_ref sd)
{
db.dep_sym_ref.Add(sd);
db.SaveChanges();
return(RedirectToAction("Index"));
}
