public JsonResult GetLogin(string UserID, string Password) { ALLMENU allMenu = new ALLMENU(); List <MenuPermission> listData = new List <MenuPermission>(); SqlCommand cmd = new SqlCommand(); try { string strLogin = @"Select * From UserInformation Where UserID = @UserID And Password = @Password AND IsActive = 1"; cmd = new SqlCommand(strLogin, DataManager.cnConnection); cmd.Parameters.Add("@UserID", SqlDbType.VarChar).Value = UserID; cmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = Encrypt(Password); DataTable dt = DataManager.ExecuteQuerySqlCommand(cmd); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { MenuPermission listItem = new MenuPermission(); listItem.UserID = dt.Rows[i]["UserID"].ToString(); listItem.UserName = dt.Rows[i]["UserName"].ToString(); listData.Add(listItem); } allMenu.ListObjMenuPermission = listData; if (allMenu.ListObjMenuPermission != null && allMenu.ListObjMenuPermission.Count != 0) { Session["UserID"] = allMenu.ListObjMenuPermission[0].UserID; Session["UserName"] = allMenu.ListObjMenuPermission[0].UserName; Session["Menu"] = allMenu; return(Json(new { isCompleted = true, redirectUrl = Url.Action("Home", "Home") }, JsonRequestBehavior.AllowGet)); } else { sMessage = "Login Failed, Please try again."; } } else { sMessage = "Login Failed, Please try again."; } } catch (Exception Ex) { } finally { } return(Json(new { isCompleted = false, redirectUrl = Url.Action("Index", "Security"), sMessage = sMessage }, JsonRequestBehavior.AllowGet)); }
//SecurityDB objSecurity = new SecurityDB(); #region Start :: Login Information //----------------- Start :: Action ----------------- public ActionResult Index() { ALLMENU allMenu = new ALLMENU(); allMenu = (ALLMENU)Session["Menu"]; if (allMenu != null) { ViewBag.MenuTitle = ""; return(RedirectToAction("../Home/Home")); } else { return(View()); } }
public ActionResult UpdatePost(PostInformation objItem) { ALLMENU allMenu = new ALLMENU(); allMenu = (ALLMENU)Session["Menu"]; if (allMenu != null) { DBSubmitPost objDB = new DBSubmitPost(); return(Json(objDB.UpdatePost(objItem, allMenu.ListObjMenuPermission[0].UserID.ToString()))); } else { return(Json(new { JsonData = "", IsLogin = "******", redirectUrl = Url.Action("Index", "Security") }, JsonRequestBehavior.AllowGet)); } }
//------------------ End :: Action ------------------ #endregion End :: Home Information #region Start :: SubmitPost Information //----------------- Start :: Action ----------------- public ActionResult SubmitPost() { ALLMENU allMenu = new ALLMENU(); allMenu = (ALLMENU)Session["Menu"]; if (allMenu != null) { ViewBag.MenuTitle = ""; return(View()); } else { return(RedirectToAction("../Security/Index")); } }
public JsonResult GetPostInformation(string PostID, string IsAcive) { ALLMENU allMenu = new ALLMENU(); allMenu = (ALLMENU)Session["Menu"]; if (allMenu != null) { DBSubmitPost objDB = new DBSubmitPost(); var jsonResult = Json(objDB.GetPostInformation(PostID, IsAcive, allMenu.ListObjMenuPermission[0].UserID.ToString()), JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = int.MaxValue; return(Json(new { JsonData = jsonResult, IsLogin = "******" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { JsonData = "", IsLogin = "******", redirectUrl = Url.Action("Index", "Security") }, JsonRequestBehavior.AllowGet)); } }
//-------------------- End :: Action ------------------- //------------------ Start :: Function ----------------- public JsonResult GetPostFeedBack_API() { ALLMENU allMenu = new ALLMENU(); allMenu = (ALLMENU)Session["Menu"]; if (allMenu != null) { DBSubmitPost objDB = new DBSubmitPost(); var jsonResult = Json(objDB.GetPostFeedBack_API(), JsonRequestBehavior.AllowGet); jsonResult.MaxJsonLength = int.MaxValue; return(Json(new { JsonData = jsonResult, IsLogin = "******" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { JsonData = "", IsLogin = "******", redirectUrl = Url.Action("Index", "Security") }, JsonRequestBehavior.AllowGet)); } }