//GET: /BBSActionList/Edit
//NB: Edit popup is being separated for the time being
public ActionResult Edit(string prodid)
{
var userobject = Session["id"];
if (userobject == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
prodid = Request.QueryString["prodid"];
int ids = Convert.ToInt32(prodid);
prodClass field = new prodClass();
using (db)
{
var formDt = db.mt_prod.Where(x => x.PROD_ID == ids).FirstOrDefault <mt_prod>();
var prodcatdt = db.mt_prod_cat.OrderBy(y => y.category_name).ToList();
field.prodCatDD = prodcatdt;
field.PROD_ID = formDt.PROD_ID;
field.PROD_NAME = formDt.PROD_NAME;
field.DESCRIPTION = formDt.DESCRIPTION;
field.PRICE = formDt.PRICE;
field.prod_cat_id = formDt.prod_cat_id;
return(View(field));
}
}
}
//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));
}
}
}
}
public ActionResult AddorEdit(string prodid)
{
var id = Session["id"];
if (id == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
prodClass field = new prodClass();
var prodCatDt = db.mt_prod_cat.OrderBy(y => y.category_name).ToList();
field.prodCatDD = prodCatDt;
return(View(field));
}
}
//POST: Update to database logic
public ActionResult Update(prodClass prodDt)
{
var userobject = Session["id"];
if (userobject == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
var editmode = Request.QueryString["editmode"];
var username = User.Identity.Name;
prodDt.UPDATE_DATE = DateTime.Now;
prodDt.UPDATE_USER = userobject.ToString();
using (db)
{
var id = prodDt.PROD_ID;
var dtfromdb = db.mt_prod.Find(id);
dtfromdb.PROD_NAME = prodDt.PROD_NAME;
dtfromdb.DESCRIPTION = prodDt.DESCRIPTION;
if (prodDt.DESCRIPTION == null)
{
dtfromdb.DESCRIPTION = "";
}
dtfromdb.PRICE = prodDt.PRICE;
dtfromdb.prod_cat_id = prodDt.prod_cat_id;
dtfromdb.UPDATE_DATE = prodDt.UPDATE_DATE;
dtfromdb.UPDATE_USER = prodDt.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));
}
}
}
}
