// GET: ClubOfficers/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ClubOfficer clubOfficer = db.ClubOfficers.Find(id);
if (clubOfficer == null)
{
return(HttpNotFound());
}
var c_member = from m in db.Members
select new
{
full_name = m.first_name + " " + m.last_name,
m.member_seq,
m.first_name,
m.last_name
};
ViewBag.member_seq = new SelectList(c_member.OrderBy(x => x.first_name).ThenBy(x => x.last_name), "member_seq", "full_name", clubOfficer.member_seq);
ViewBag.officer_id = new SelectList(db.Officers.OrderBy(x => x.officer_id), "officer_id", "title", clubOfficer.officer_id);
ViewBag.club_id = new SelectList(db.Clubs.OrderBy(x => x.club_name_thai), "club_id", "club_name_thai", clubOfficer.club_id);
return(View(clubOfficer));
}
public ActionResult Create([Bind(Include = "fiscal_year,member_seq,officer_id,club_officer_id,club_id,seq_no")] ClubOfficer clubOfficer)
{
if (ModelState.IsValid)
{
db.ClubOfficers.Add(clubOfficer);
db.SaveChanges();
var identity = (HttpContext.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity;
// Write log to table TransactionLog
//ProjLib projlib = new ProjLib();
ProjLib.writeTransactionLog(identity.User.member_seq, "CreateClubOfficer", identity.User.club_id);
return(RedirectToAction("Index"));
}
var c_member = from m in db.Members
select new
{
full_name = m.first_name + " " + m.last_name,
m.member_seq,
m.first_name,
m.last_name
};
ViewBag.member_seq = new SelectList(c_member.OrderBy(x => x.first_name).ThenBy(x => x.last_name), "member_seq", "full_name", clubOfficer.member_seq);
ViewBag.officer_id = new SelectList(db.Officers.OrderBy(x => x.officer_id), "officer_id", "title", clubOfficer.officer_id);
ViewBag.club_id = new SelectList(db.Clubs.OrderBy(x => x.club_name_thai), "club_id", "club_name_thai", clubOfficer.club_id);
return(View(clubOfficer));
}
public ActionResult DeleteConfirmed(int id)
{
ClubOfficer clubOfficer = db.ClubOfficers.Find(id);
db.ClubOfficers.Remove(clubOfficer);
db.SaveChanges();
var identity = (HttpContext.User as RegisterLions.MyPrincipal).Identity as RegisterLions.MyIdentity;
// Write log to table TransactionLog
//ProjLib projlib = new ProjLib();
ProjLib.writeTransactionLog(identity.User.member_seq, "DeleteClubOfficer", identity.User.club_id);
return(RedirectToAction("Index"));
}
// GET: ClubOfficers/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ClubOfficer clubOfficer = db.ClubOfficers.Find(id);
if (clubOfficer == null)
{
return(HttpNotFound());
}
return(View(clubOfficer));
}
