// GET: RegionOfficers/Edit/5 public ActionResult Edit(int?id) { var identity = (System.Web.HttpContext.Current.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RegionOfficer regionOfficer = db.RegionOfficers.Find(id); if (regionOfficer == null) { return(HttpNotFound()); } var member = (from m in db.Members join co in db.ClubOfficers on m.member_seq equals co.member_seq where co.officer_id == 21 join c in db.Clubs on m.club_id equals c.club_id where c.district_id == identity.User.district_id select m ).OrderBy(x => x.first_name); ViewBag.member_seq = new SelectList(member, "member_seq", "full_name", regionOfficer.member_seq); return(View(regionOfficer)); }
public ActionResult Create([Bind(Include = "region_officer_id,region_no,fiscal_year,member_seq")] RegionOfficer regionOfficer) { var identity = (System.Web.HttpContext.Current.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; if (ModelState.IsValid) { db.RegionOfficers.Add(regionOfficer); db.SaveChanges(); // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "CreateRegionOfficer", identity.User.club_id); return(RedirectToAction("Index")); } var member = (from m in db.Members join co in db.ClubOfficers on m.member_seq equals co.member_seq where co.officer_id == 21 join c in db.Clubs on m.club_id equals c.club_id where c.district_id == identity.User.district_id select m ).OrderBy(x => x.first_name); ViewBag.member_seq = new SelectList(member, "member_seq", "full_name", regionOfficer.member_seq); return(View(regionOfficer)); }
public ActionResult DeleteConfirmed(int id) { var identity = (System.Web.HttpContext.Current.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity; RegionOfficer regionOfficer = db.RegionOfficers.Find(id); db.RegionOfficers.Remove(regionOfficer); db.SaveChanges(); // Write log to table TransactionLog //ProjLib projlib = new ProjLib(); ProjLib.writeTransactionLog(identity.User.member_seq, "DeleteRegionOfficer", identity.User.club_id); return(RedirectToAction("Index")); }
// GET: RegionOfficers/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RegionOfficer regionOfficer = db.RegionOfficers.Find(id); if (regionOfficer == null) { return(HttpNotFound()); } return(View(regionOfficer)); }