public ActionResult DeleteConfirmed(int id) { HisEntity hisEntity = db.HisEntities.Find(id); db.HisEntities.Remove(hisEntity); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "Id,Name,Remarks,Address,Contact")] HisEntity hisEntity) { if (ModelState.IsValid) { db.HisEntities.Add(hisEntity); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(hisEntity)); }
// GET: HIS10/HisEntities/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HisEntity hisEntity = db.HisEntities.Find(id); if (hisEntity == null) { return(HttpNotFound()); } return(View(hisEntity)); }
public ActionResult Edit([Bind(Include = "Id,Name,Remarks,Address,Contact")] HisEntity hisEntity) { if (ModelState.IsValid) { db.Entry(hisEntity).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Categories = db.HisEntCats.Include(d => d.HisCategory).Where(d => d.HisEntityId == hisEntity.Id).ToList(); //ViewBag.Administrators = db.HisEntAdmins.Include(d => d.HisAdmin).Where(d => d.HisEntityId == hisEntity.Id ).ToList(); return(View(hisEntity)); }
// GET: HIS10/HisEntities/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HisEntity hisEntity = db.HisEntities.Find(id); if (hisEntity == null) { return(HttpNotFound()); } ViewBag.Categories = db.HisEntCats.Include(d => d.HisCategory).Where(d => d.HisEntityId == id).ToList(); string sqlExec = "select A.Email, A.Id as UserId from AspNetUsers A left outer join HisEntAdmins B on A.Id = B.AccntUserId where B.HisEntityId = " + id.ToString(); //DbRawSqlQuery<AccntUsers> adminAccnts = db.Database.SqlQuery<AccntUsers>(sqlExec).ToList(); List <AccntUsers> adminAccnts = db.Database.SqlQuery <AccntUsers>(sqlExec).ToList(); ViewBag.Administrators = adminAccnts; return(View(hisEntity)); }