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