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