public ActionResult Create(CARDCHTRAN cardchtran)
{
List<string> currencyList;
try
{
int adminFlag = 0;
OCCUSER user = (OCCUSER) Session["User"];
cardchtran.CREATEDBY = user.ID;
cardchtran.CREATEDON = DateTime.Now.Date;
cardchtran.STATUS = 13;
cardchtran.ISACTIVE = true;
cardchtran.ISDELETE = false;
var leaf=db.CARDCHLEAF.FirstOrDefault(x => x.ID == cardchtran.CHEQUELEAFID);
leaf.LEAFSTATUS = db.OCCENUMERATION.Where(x=>x.Name=="used").Select(x=>x.ID).FirstOrDefault();
db.Entry(leaf).State = EntityState.Modified;
if (ModelState.IsValid)
{
db.CARDCHTRAN.Add(cardchtran);
db.SaveChanges();
if (user.TYPE == 1)
{
adminFlag = 1;
}
var msg = "Data saved successfully. ";
return Json(new { msg, adminFlag }, JsonRequestBehavior.AllowGet);
}
currencyList = new List<string>() { "BDT" };
ViewBag.BRANCHCODE = new SelectList(db.BRANCHINFO.ToList(), "ID", "BRANCHNAME");
ViewBag.CURRENCY = new SelectList(currencyList);
return View("Index");
}
catch (DbEntityValidationException dbEntityValidationException)
{
return RedirectToAction("Error", "Home", new { Area = "" });
}
catch (InvalidOperationException invalidOperationException)
{
return RedirectToAction("Error", "Home", new { Area = "" });
}
catch (Exception exception)
{
return RedirectToAction("Error", "Home", new { Area = "" });
}
}
public ActionResult Details(CARDCHTRAN tran,string btnName)
{
try
{
OCCUSER user = (OCCUSER)Session["User"];
if (String.Equals(btnName, "update"))
{
var updatedTrn = db.CARDCHTRAN.Find(tran.ID);
updatedTrn.CHEQUELEAFID = tran.CHEQUELEAFID;
updatedTrn.CARDNO = tran.CARDNO;
updatedTrn.BENEFICIARINFO = tran.BENEFICIARINFO;
updatedTrn.AMOUNT = tran.AMOUNT;
updatedTrn.BRANCHCODE = tran.BRANCHCODE;
updatedTrn.REQUESTDATE = tran.REQUESTDATE;
updatedTrn.MODIFIEDBY = user.ID;
updatedTrn.MODIFIEDON = DateTime.Now;
// updatedTrn.ISACTIVE = true;
db.Entry(updatedTrn).State = EntityState.Modified;
db.SaveChanges();
var msg = "Successfully Updated";
return Json(msg, JsonRequestBehavior.AllowGet);
}
if (String.Equals(btnName, "delete"))
{
//aUser.MODIFIEDBY = user.ID;
//aUser.MODIFIEDON = DateTime.Now;
//aUser.ISACTIVE = false;
//db.Entry(aUser).State = EntityState.Modified;
//db.SaveChanges();
var updatedTrn = db.CARDCHTRAN.Find(tran.ID);
updatedTrn.ISDELETE = true;
db.Entry(updatedTrn).State = EntityState.Modified;
db.SaveChanges();
var msg = "Successfully Removed";
return Json(msg, JsonRequestBehavior.AllowGet);
}
var msg1 = "Error in operation";
return Json(msg1, JsonRequestBehavior.DenyGet);
// return View(tran);
}
catch (Exception exception)
{
return Json(exception.Message, JsonRequestBehavior.AllowGet);
//return RedirectToAction("Error", "Home", new { Area = "" });
}
}