public JsonResult Delete(int id) { using (anhthaiEntities db = new anhthaiEntities()) { SVR_VERSION emp = db.SVR_VERSION.Where(x => x.VERSION_NO == id).FirstOrDefault <SVR_VERSION>(); db.SVR_VERSION.Remove(emp); db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Authorise(SVR_USER user) { using (anhthaiEntities db = new anhthaiEntities()) { var userDetail = db.SVR_USER.Where(x => x.USERNAME == user.USERNAME && x.PASSWORD == user.PASSWORD).FirstOrDefault(); if (userDetail == null) { user.LoginErrorMsg = "Invalid UserName or Password"; return(View("Index", user)); } else { Session["userName"] = user.USERNAME; return(RedirectToAction("Index", "SVR_VIEW")); } } }
public ActionResult GetData() { using (anhthaiEntities db = new anhthaiEntities()) { List <Svr_VersionViewModel> verList = db.SVR_VERSION.Select(x => new Svr_VersionViewModel { BUMON_ID = x.BUMON_ID, VERSION_NO = x.VERSION_NO, TYPE_SEND = x.TYPE_SEND, FROM_DATE = x.FROM_DATE, TO_DATE = x.TO_DATE, INSERT_DATE = x.INSERT_DATE, INSERT_USER = x.INSERT_USER, UPDATE_DATE = x.UPDATE_DATE, UPDATE_USER = x.UPDATE_USER, DEL_FLAG = x.DEL_FLAG, BUMON_NAME = x.SVR_BUMON.BUMON_NAME }).ToList(); return(Json(new { data = verList }, JsonRequestBehavior.AllowGet)); } }