//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["custid"];
int ids = Convert.ToInt32(custid);
using (db)
{
mt_customer custDt = db.mt_customer.Where(x => x.CUST_ID == ids).FirstOrDefault <mt_customer>();
try
{
db.mt_customer.Remove(custDt);
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(mt_customer custDt)
{
var userobject = Session["id"];
if (userobject == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
var editmode = Request.QueryString["editmode"];
var username = User.Identity.Name;
if (string.IsNullOrEmpty(custDt.PHONE))
{
custDt.PHONE = "";
}
if (string.IsNullOrEmpty(custDt.ADDRESS))
{
custDt.ADDRESS = "";
}
if (string.IsNullOrEmpty(custDt.EMAIL))
{
custDt.EMAIL = "";
}
custDt.ENTRY_DATE = DateTime.Now;
custDt.ENTRY_USER = userobject.ToString();
custDt.UPDATE_DATE = DateTime.Now;
custDt.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_customer.Add(custDt);
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));
}
}
}
}
//POST: Update to database logic
public ActionResult Update(mt_customer custDt)
{
var userobject = Session["id"];
if (userobject == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
var editmode = Request.QueryString["editmode"];
var username = User.Identity.Name;
custDt.UPDATE_DATE = DateTime.Now;
custDt.UPDATE_USER = userobject.ToString();
using (db)
{
var id = custDt.CUST_ID;
var dtfromdb = db.mt_customer.Find(id);
dtfromdb.CUST_NAME = custDt.CUST_NAME;
dtfromdb.PHONE = custDt.PHONE;
dtfromdb.ADDRESS = custDt.ADDRESS;
dtfromdb.EMAIL = custDt.EMAIL;
dtfromdb.UPDATE_DATE = custDt.UPDATE_DATE;
dtfromdb.UPDATE_USER = custDt.UPDATE_USER;
if (string.IsNullOrEmpty(custDt.PHONE))
{
dtfromdb.PHONE = "";
}
if (string.IsNullOrEmpty(custDt.ADDRESS))
{
dtfromdb.ADDRESS = "";
}
if (string.IsNullOrEmpty(custDt.EMAIL))
{
dtfromdb.EMAIL = "";
}
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));
}
}
}
}