public ActionResult Form(int?id)
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Login", "Profile"));
}
Katalogue Katalogues;
string action = "New Data";
if (id == null)
{
Katalogues = new Katalogue();
Katalogues.CREATED_AT = ClassFunction.GetServerTime();
}
else
{
action = "Update Data";
Katalogues = db.Katalogues.Find(id);
}
if (Katalogues == null)
{
return(HttpNotFound());
}
ViewBag.action = action;
return(View(Katalogues));
}
public bool IsInputValid(Katalogue FAQ)
{
bool isValid = true;
if (!ModelState.IsValid)
{
isValid = false;
}
return(isValid);
}
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Katalogue qL_mstcurr = db.Katalogues.Find(id);
if (qL_mstcurr == null)
{
return(HttpNotFound());
}
return(View(qL_mstcurr));
}
public ActionResult Form(Katalogue FAQ, string action)
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Login", "Profile"));
}
FAQ.CREATED_AT = ClassFunction.GetServerTime();
sSql = "select top 1 max(ID) + 1 from FAQ";
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 FAQ (TITLE, SUBTITLE, CREATED_AT, UPDATED_AT) VALUES('" + FAQ.TITLE + "', '" + FAQ.SUBTITLE + "', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP)";
db.Database.ExecuteSqlCommand(sSql);
db.SaveChanges();
}
else
{
sSql = "UPDATE FAQ SET TITLE='" + FAQ.TITLE + "', SUBTITLE='" + FAQ.SUBTITLE + "', CREATED_AT=CURRENT_TIMESTAMP, UPDATED_AT=CURRENT_TIMESTAMP WHERE ID=" + FAQ.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(FAQ));
}
public ActionResult DeleteConfirmed(int id)
{
if (Session["UserID"] == null)
{
return(RedirectToAction("Login", "Profile"));
}
Katalogue list = db.Katalogues.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 Katalogues 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));
}
