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));
}
}
