//POST: delete from database logic
public ActionResult Delete(string prodid)
{
var userobject = Session["id"];
if (userobject == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
prodid = Request.QueryString["prodid"];
int ids = Convert.ToInt32(prodid);
using (db)
{
mt_prod prodDt = db.mt_prod.Where(x => x.PROD_ID == ids).FirstOrDefault <mt_prod>();
try
{
db.mt_prod.Remove(prodDt);
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(prodClass prodDt)
{
var userobject = Session["id"];
if (userobject == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
mt_prod dt = new mt_prod();
var editmode = Request.QueryString["editmode"];
var username = User.Identity.Name;
prodDt.ENTRY_DATE = DateTime.Now;
prodDt.ENTRY_USER = userobject.ToString();
prodDt.UPDATE_DATE = DateTime.Now;
prodDt.UPDATE_USER = userobject.ToString();
var dtname = username;
using (db)
{
try
{
dt.PROD_NAME = prodDt.PROD_NAME;
dt.prod_cat_id = prodDt.prod_cat_id;
dt.DESCRIPTION = prodDt.DESCRIPTION;
if (prodDt.DESCRIPTION == null)
{
dt.DESCRIPTION = "";
}
dt.PRICE = prodDt.PRICE;
dt.ENTRY_DATE = prodDt.ENTRY_DATE;
dt.ENTRY_USER = prodDt.ENTRY_USER;
dt.UPDATE_DATE = prodDt.UPDATE_DATE;
dt.UPDATE_USER = prodDt.UPDATE_USER;
db.mt_prod.Add(dt);
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));
}
}
}
}
