//POST: delete from database logic
public ActionResult Delete(string costid)
{
var userobject = Session["id"];
if (userobject == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
costid = Request.QueryString["costid"];
int ids = Convert.ToInt32(costid);
using (db)
{
mg_shoplist costdt = db.mg_shoplist.Where(x => x.ID == ids).FirstOrDefault <mg_shoplist>();
try
{
db.mg_shoplist.Remove(costdt);
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));
}
}
}
}
//POST: Insert to database logic
public ActionResult Insert(mg_shoplist2 costDt)
{
var userobject = Session["id"];
if (userobject == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
//var dates = Convert.ToDateTime(costDt.TRANS_DATE_STR).ToString("MM/dd/yyyy");
costDt.TRANS_DATE = Convert.ToDateTime(costDt.TRANS_DATE_STR);
var editmode = Request.QueryString["editmode"];
var username = User.Identity.Name;
var dtname = username;
mg_shoplist form = new mg_shoplist();
form.AMOUNT = costDt.AMOUNT;
form.TRANS_DATE = costDt.TRANS_DATE;
form.NOTES = costDt.NOTES;
form.ENTRY_DATE = DateTime.Now;
form.ENTRY_USER = userobject.ToString();
form.UPDATE_DATE = DateTime.Now;
form.UPDATE_USER = userobject.ToString();
using (db)
{
try
{
db.mg_shoplist.Add(form);
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));
}
}
}
}
