public ActionResult Create([Bind(Include = "TxnId,UserId,TxnTypeId,TxnAmount,TxnDateTime,TxnBalance,TxnRefJobId,TxnStatus,AddedBy,AddedOn,EditedBy,EditedOn,StatusId")] UserTxns userTxns) { if (ModelState.IsValid) { db.UserTxns.Add(userTxns); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(userTxns)); }
public ActionResult Edit([Bind(Include = "TxnId,UserId,TxnTypeId,TxnAmount,TxnDateTime,TxnBalance,TxnRefJobId,TxnStatus,EditedBy,EditedOn,StatusId", Exclude = "AddedBy,AddedOn")] UserTxns userTxns) { if (ModelState.IsValid) { db.Entry(userTxns).State = EntityState.Modified; db.Entry(userTxns).Property(uco => uco.AddedBy).IsModified = false; db.Entry(userTxns).Property(uco => uco.AddedOn).IsModified = false; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(userTxns)); }
// GET: UserTxns/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } UserTxns userTxns = db.UserTxns.Find(id); if (userTxns == null) { return(HttpNotFound()); } return(View(userTxns)); }
public ActionResult DeleteConfirmed(int id) { try { UserTxns userTxns = db.UserTxns.Find(id); userTxns.StatusId = 0; // on delete setting up the row status column to 0 for softdelete. 1 is active db.Entry(userTxns).State = EntityState.Modified; //db.Users.Remove(users); db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception e) { Console.WriteLine(e); throw e; } }
// GET: UserTxns/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } UserTxns userTxns = db.UserTxns.Find(id); if (userTxns == null) { return(HttpNotFound()); } //ViewBag.UserTypeId = new SelectList(db.UserTypes, "UserTypeId", "UserType"); ViewBag.StatusId = new SelectList(db.RStatus, "StatusId", "StatusName", userTxns.StatusId); //ViewBag.UStatusId = new SelectList(db.UStatus, "UStatusId", "UStatusName"); return(View(userTxns)); }