//POST: delete from database logic
public ActionResult Delete(string custid)
{
var userobject = Session["id"];
if (userobject == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
custid = Request.QueryString["catid"];
int ids = Convert.ToInt32(custid);
using (db)
{
mt_prod_cat catDt = db.mt_prod_cat.Where(x => x.id == ids).FirstOrDefault <mt_prod_cat>();
try
{
db.mt_prod_cat.Remove(catDt);
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: Update to database logic
public ActionResult Update(mt_prod_cat catDt)
{
var userobject = Session["id"];
if (userobject == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
var editmode = Request.QueryString["editmode"];
catDt.update_date = DateTime.Now;
catDt.update_user = userobject.ToString();
using (db)
{
var id = catDt.id;
var dtfromdb = db.mt_prod_cat.Find(id);
dtfromdb.category_name = catDt.category_name;
dtfromdb.amount = catDt.amount;
dtfromdb.update_date = catDt.update_date;
dtfromdb.update_user = catDt.update_user;
try
{
db.Entry(dtfromdb).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated 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(mt_prod_cat catDt)
{
var userobject = Session["id"];
if (userobject == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
var editmode = Request.QueryString["editmode"];
var username = Session["id"].ToString();
catDt.entry_date = DateTime.Now;
catDt.entry_user = userobject.ToString();
catDt.update_date = DateTime.Now;
catDt.update_user = userobject.ToString();
var dtname = username;
using (db)
{
//dt = db.PEKAONLINE_ACTIONLIST.Where(x => x.LSR_NUMBER == actionListDt.LSR_NUMBER).FirstOrDefault<PEKAONLINE_ACTIONLIST>();
//if (dt == null)
//{
// db.Dispose();
//}
//else
//{
// db.Dispose();
// return Json(new { success = false, message = "Duplicate Entry" }, JsonRequestBehavior.AllowGet);
//}
try
{
db.mt_prod_cat.Add(catDt);
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));
}
}
}
}
