public ActionResult Form(int?id) { if (Session["UserID"] == null) { return(RedirectToAction("Login", "Profile")); } HighlightNews HighlightNews; string action = "New Data"; if (id == null) { HighlightNews = new HighlightNews(); HighlightNews.CREATED_AT = ClassFunction.GetServerTime(); } else { action = "Update Data"; HighlightNews = db.HighlightNews.Find(id); } if (HighlightNews == null) { return(HttpNotFound()); } ViewBag.action = action; return(View(HighlightNews)); }
public bool IsInputValid(HighlightNews HighlightNews) { bool isValid = true; if (!ModelState.IsValid) { isValid = false; } return(isValid); }
public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HighlightNews qL_mstcurr = db.HighlightNews.Find(id); if (qL_mstcurr == null) { return(HttpNotFound()); } return(View(qL_mstcurr)); }
public ActionResult Form(HighlightNews HighlightNews, string action) { if (Session["UserID"] == null) { return(RedirectToAction("Login", "Profile")); } HighlightNews.CREATED_AT = ClassFunction.GetServerTime(); sSql = "select top 1 max(ID) + 1 from HighlightNews"; var mstoid = db.Database.SqlQuery <Decimal>(sSql).FirstOrDefault(); if (ModelState.IsValid) { using (var objTrans = db.Database.BeginTransaction()) { try { if (action == "New Data") { sSql = "INSERT INTO HighlightNews (TITLE, SUBTITLE, ISENABLE, CREATED_AT, UPDATED_AT) VALUES('" + HighlightNews.TITLE + "', '" + HighlightNews.SUBTITLE + "', '" + HighlightNews.ISENABLE + "', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP)"; db.Database.ExecuteSqlCommand(sSql); db.SaveChanges(); } else { sSql = "UPDATE HighlightNews SET TITLE='" + HighlightNews.TITLE + "', SUBTITLE='" + HighlightNews.SUBTITLE + "', ISENABLE='" + HighlightNews.ISENABLE + "', CREATED_AT=CURRENT_TIMESTAMP, UPDATED_AT=CURRENT_TIMESTAMP WHERE ID=" + HighlightNews.ID + ""; db.Database.ExecuteSqlCommand(sSql); db.SaveChanges(); } objTrans.Commit(); return(RedirectToAction("Index")); } catch (Exception ex) { objTrans.Rollback(); ModelState.AddModelError("", ex.ToString()); } } } ViewBag.action = action; return(View(HighlightNews)); }
public ActionResult DeleteConfirmed(int id) { if (Session["UserID"] == null) { return(RedirectToAction("Login", "Profile")); } HighlightNews list = db.HighlightNews.Find(id); var servertime = ClassFunction.GetServerTime(); string result = "success"; string msg = ""; if (list == null) { result = "failed"; msg = "Data can't be found!"; } if (result == "success") { using (var objTrans = db.Database.BeginTransaction()) { try { sSql = "DELETE FROM HighlightNews WHERE ID=" + list.ID; db.Database.ExecuteSqlCommand(sSql); db.SaveChanges(); objTrans.Commit(); } catch (Exception ex) { objTrans.Rollback(); result = "failed"; msg = ex.ToString(); } } } return(Json(new { result, msg }, JsonRequestBehavior.AllowGet)); }