我无法登录 [英] I am not able to login

问题描述

当我调试我的程序时，我的用户定义函数出错，无法调试，请帮助我



我尝试了什么：

When i am debuging my program i am getting error in my user define function not able to debug kindly help me

What I have tried:

[HttpPost]
        [AllowAnonymous]
        [ValidateAntiForgeryToken]
        public ActionResult Login(Login login)
        {
            if (ModelState.IsValid)
            {

                bool success = objIAccountData.Login(login.username, login.password, false);
                var UserID = GetUserID_By_UserName(login.username);
                var LoginType = GetRoleBy_UserID(Convert.ToString(UserID));

                if (success == true)
                {
                    if (string.IsNullOrEmpty(Convert.ToString(LoginType)))
                    {
                        ModelState.AddModelError("Error", "Rights to User are not Provide Contact to Admin");
                        return View(login);
                    }
                    else
                    {
                        Session["Name"] = login.username;
                        Session["UserID"] = UserID;
                        Session["LoginType"] = LoginType;

                        if (Roles.IsUserInRole(login.username, "Admin"))
                        {
                            return RedirectToAction("AdminDashboard", "Dashboard");
                        }




                        else
                        {
                            return RedirectToAction("UserDashboard", "Dashboard");
                        }
                    }
                }
                else
                {

                    ModelState.AddModelError("Error", "Please enter valid Username and Password");
                    return View(login);
                }
            }
            else
            {
                ModelState.AddModelError("Error", "Please enter Username and Password");
            }
            return View(login);

        }

public static bool Login(string userName, string password, bool persistCookie = false)
{

    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Mystring"].ToString();
      var para = new DynamicParameters();
        para.Add("@UserName", userName);
        var para1 = new DynamicParameters();
        para1.Add("@password", password);

        var t  = con.Query<int>("login_pro", null, null, true, 0, CommandType.StoredProcedure).ToList().SingleOrDefault();
        if (t == 1)
        {
            return true;
        }

        else
        {
            return false;
        }

商店程序

store procedure

CREATE PROCEDURE login_pro
	-- Add the parameters for the stored procedure here
	@UserName varchar(50),
        @Password varchar(50)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	declare @status int
if exists(select * from [Users] where UserName=@UserName and Password=@Password)
       set @status=1
else
       set @status=0
select @status
 
END
GO

推荐答案

嗨。以纯文本存储密码是一个很大的可怕想法。



请参考以下链接。它描述了如何使用散列在数据库中存储密码，你可以在MVC中找到登录功能的代码。



MVC中的登录功能 [ ^ ]

Hi. It`s a horrible idea to store password in plain text.

please, refer below link. It describes, how to store password in database using hashing and you can also find code for Login Functionality in MVC.

Login functionality in MVC[^]

这篇关于我无法登录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！