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