//POST: delete from database logic
public ActionResult Delete(string transid)
{
var userobject = Session["id"];
if (userobject == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
transid = Request.QueryString["transid"];
int ids = Convert.ToInt32(transid);
using (db)
{
mt_transaction transdt = db.mt_transaction.Where(x => x.TRANS_ID == ids).FirstOrDefault <mt_transaction>();
try
{
db.mt_transaction.Remove(transdt);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { success = false, message = e.InnerException.Message }, JsonRequestBehavior.AllowGet));
}
}
}
}
public ActionResult Insert(OemahJowoClass transDt)
{
var userobject = Session["id"];
if (userobject == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
transDt.TRANS_DATE = Convert.ToDateTime(transDt.TRANS_DATE.ToString("MM/dd/yyyy"));
var editmode = Request.QueryString["editmode"];
var username = User.Identity.Name;
transDt.ENTRY_DATE = DateTime.Now;
transDt.ENTRY_USER = userobject.ToString();
transDt.UPDATE_DATE = DateTime.Now;
transDt.UPDATE_USER = userobject.ToString();
var dtname = username;
using (db)
{
try
{
mt_transaction transfield = new mt_transaction();
transfield.TRANS_DATE = transDt.TRANS_DATE;
transfield.PROD_ID = transDt.PROD_ID;
transfield.DESCRIPTION = transDt.DESCRIPTION;
transfield.CUST_ID = transDt.CUST_ID;
transfield.ITEM_AMT = transDt.ITEM_AMT;
transfield.PRICE = transDt.PRICE;
if (transDt.IS_ONLINE)
{
transfield.IS_GOJEK = "Y";
}
else
{
transfield.IS_GOJEK = "N";
}
transfield.UPDATE_DATE = transDt.UPDATE_DATE;
transfield.UPDATE_USER = transDt.UPDATE_USER;
transfield.ENTRY_DATE = transDt.ENTRY_DATE;
transfield.ENTRY_USER = transDt.ENTRY_USER;
db.mt_transaction.Add(transfield);
db.SaveChanges();
return(Json(new { success = true, message = "Saved successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { success = false, message = e.InnerException.Message }, JsonRequestBehavior.AllowGet));
}
}
}
}
