Login Form Mvc without EF in VS 2019

Tri Setia

Hi guys,,l'm learn how to create login without EF in VS 2019 MVC. The login Controller can not return RedirectToAction("Index", "Home"); although the username and password has been entered correctly. I want if user entered correct username and password or success login will redirect to AdminDashboard.

this is the login.cshtm

@model AdminLTEMvc.Models.LoginViewModel
@{
Layout = null;
}
"en">
"utf-8">
"viewport" content="width=device-width, initial-scale=1">
Admin | Log <span class="keyword">in</span><span>
"stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback">
"stylesheet" href="~/plugins/fontawesome-free/css/all.min.css">
"stylesheet" href="~/plugins/icheck-bootstrap/icheck-bootstrap.min.css">
"stylesheet" href="~/dist/css/adminlte.min.css">
class="hold-transition login-page">
class="login-box">
class="login-logo">
"">Admin Login

class="card">

class="card-body login-card-body">

class="login-box-msg">Sign in to start your session

"post">

"All"

class="text-danger">

class="input-group mb-3">

for

="email" class="form-control" placeholder="Email" required>

for

="email" class="text-danger">

class="input-group-append">

class="input-group-text">

class="fas fa-envelope">

class="input-group mb-3">

for

="password" class="form-control" placeholder="Password" required>

for

="password" class="text-danger">

class="input-group-append">

class="input-group-text">

class="fas fa-lock">

class="row">

class="col-8">

class="icheck-primary">

"checkbox" id="remember">

for="remember">

Remember Me

class="col-4">

"Submit" class="btn btn-primary btn-block">Sign In

class="social-auth-links text-center mb-3">

- OR -

"#" class="btn btn-block btn-primary">

class="fab fa-facebook mr-2"> Sign in using Facebook

"#" class="btn btn-block btn-danger">

class="fab fa-google-plus mr-2"> Sign in using Google+

class="mb-1">

"forgot-password.html">I forgot my password

class="mb-0">

"" class="text-center">Register a new membership

"~/plugins/jquery/jquery.min.js">

"~/plugins/bootstrap/js/bootstrap.bundle.min.js">

"~/dist/js/adminlte.min.js">

this is the AccountController.cs

using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Configuration;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using AdminLTEMvc.Models;
using Microsoft.Data.SqlClient;
using System.Data;
namespace AdminLTEMvc.Controllers
{
public class AccountController : Controller
{
private readonly IConfiguration _configuration;
public AccountController(IConfiguration configuration)
{
this._configuration = configuration;
}
[HttpGet]
public IActionResult Login()
{
return View();
}
[HttpPost]
[ValidateAntiForgeryToken]
public IActionResult Login(LoginViewModel loginViewModel)
{
try
{
using (SqlConnection con = new SqlConnection(_configuration.GetConnectionString("db_mvc")))
{
con.Open();
SqlCommand cmd = new SqlCommand("spLoginUser", con);
cmd.Parameters.AddWithValue("@user_name", loginViewModel.user_name);
cmd.Parameters.AddWithValue("@password", loginViewModel.password);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.Read()==true)
{
//if login success
return RedirectToAction("Index", "Home");
}
else
{
//if login failed
return RedirectToAction("Login", "Account");
}
}
}
catch(Exception)
{
throw;
}
}
}
}

this the LoginViewModel.cs

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Threading.Tasks;
namespace AdminLTEMvc.Models
{
public class LoginViewModel
{
[Key]
public int user_id { get; set; }
[Required]
public string user_name { get; set; }
[Required]
[DataType(DataType.Password)]
[StringLength(150, MinimumLength = 6)]
[Display(Name = "Password: ")]
public string password { get; set; }
[Required]
public string email { get; set; }
public string create_date { get; set; }
[Required]
public string last_login_date { get; set; }
}
}

this is the connection string

{
"Logging": {
"LogLevel": {
"Default": "Information",
"Microsoft": "Warning",
"Microsoft.Hosting.Lifetime": "Information"
}
},
"AllowedHosts": "*",
"ConnectionStrings": {
"db_mvc": "Data Source=.;Initial Catalog=db_lma;Integrated Security=True"
}
}

this the Store Prosedure

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author:
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[spLoginUser]
-- Add the parameters for the stored procedure here
@user_name nvarchar(50)=null,
@password nvarchar(50)=null
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
Select * From tbl_login Where user_name=@user_name And password=@password
END

any help could be appriciate.

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar5y ago
Accepted answer
Hi,

Please try to load data in datatable and check it has data like this,
[HttpPost]
[ValidateAntiForgeryToken]
public IActionResult Login(LoginViewModel loginViewModel)
{
            try
            {
                using (SqlConnection con = new SqlConnection(_configuration.GetConnectionString("db_mvc")))
                {
                    con.Open();
                    SqlCommand cmd = new SqlCommand("spLoginUser", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@user_name", loginViewModel.user_name);
                    cmd.Parameters.AddWithValue("@password", loginViewModel.password);
                    cmd.ExecuteNonQuery();
                    DataTable dt=new DataTable();
dt.Load(cmd.ExecuteReader());
                    if (dt.Rows.Count > 0)
                    {
                        ViewData["Pesan"] = "Berhasil Login";
                        //if success login
                        return RedirectToAction("Index", "AdminDashboard");
                    }
                    else
                    {
                        ViewData["Pesan"] = "User Name atau password salah,,, silahkan ulangi kembali !!!";
                    }
                    con.Close();
                    //if failed login
                    return RedirectToAction("Login", "Account");
                }
            }
            catch(Exception)
            {
                throw;
            }
}
+3
Tri Setia5y ago
@Jignesh Kumar
amazing sir, the code working if use this code block.
    cmd.ExecuteNonQuery();
    DataTable dt=new DataTable();
    dt.Load(cmd.ExecuteReader());
    if (dt.Rows.Count > 0)
    {
        ViewData["Pesan"] = "Berhasil Login";
        //if success login
        return RedirectToAction("Index", "AdminDashboard");
    }
    else
    {
        ViewData["Pesan"] = "User Name atau password salah,,, silahkan ulangi kembali !!!";
    }
    con.Close();
    //if failed login
    return RedirectToAction("Login", "Account");
}
the problem has been solved,,
+3
Tri Setia5y ago
@Jignesh Kumar
I has been add
cmd.ExecuteNonQuery();
but the result still same,, the code directly access in block code after else statement. can not Redirect to return RedirectToAction("Index", "AdminDashboard");
else
                   {
                       ViewData["Pesan"] = "User Name atau password salah,,, silahkan ulangi kembali !!!";
return RedirectToAction("Login", "Account");
                   }
+2
Tri Setia5y ago
@Rijwan Ansari
I'm has been try like that sir, but the result still same. The code always jump and directly acces block code after else statement.
else
{
ViewData["Pesan"] = "User Name atau password salah,,, silahkan ulangi kembali !!!";
return RedirectToAction("Login", "Account");
}
and this code block always not working.
if (rdr.Read())
{
ViewData["Pesan"] = "Berhasil Login";
con.Close();
//if success login
return RedirectToAction("Index", "AdminDashboard");
}
I have do like this too, but the result stil same code directly jumpt and always access in
else
{
ViewData["Pesan"] = "User Name atau password salah,,, silahkan ulangi kembali !!!";
return RedirectToAction("Login", "Account");
}
this block not working sir..
if (rdr.HasRows)
{
rdr.Read();
con.Close();
ViewData["message"] = "Berhasil Login";
return RedirectToAction("Index", "AdminDashboard");
}
+2
Jignesh Kumar5y ago
Hi,

You are using insert then select statement so that this issue is happening. could you please try to use this one, just try to add cmd.ExecuteNonQuery();
[HttpPost]
[ValidateAntiForgeryToken]
public IActionResult Login(LoginViewModel loginViewModel)
{
            try
            {
                using (SqlConnection con = new SqlConnection(_configuration.GetConnectionString("db_mvc")))
                {
                    con.Open();
                    SqlCommand cmd = new SqlCommand("spLoginUser", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@user_name", loginViewModel.user_name);
                    cmd.Parameters.AddWithValue("@password", loginViewModel.password);
                    cmd.ExecuteNonQuery();
                    SqlDataReader rdr = cmd.ExecuteReader();
                    if (rdr.Read())
                    {
                        ViewData["Pesan"] = "Berhasil Login";
                        //if success login
                        return RedirectToAction("Index", "AdminDashboard");
                    }
                    else
                    {
                        ViewData["Pesan"] = "User Name atau password salah,,, silahkan ulangi kembali !!!";
                    }
                    con.Close();
                    //if failed login
                    return RedirectToAction("Login", "Account");
                }
            }
            catch(Exception)
            {
                throw;
            }
}
+3
Rijwan Ansari5y ago
Hi,

You can do in this way
if (rdr.Read())
{
ViewData["Pesan"] = "Berhasil Login";
con.Close();
    //if success login
    return RedirectToAction("Index", "AdminDashboard");

}
else
{
ViewData["Pesan"] = "User Name atau password salah,,, silahkan ulangi kembali !!!";
return RedirectToAction("Login", "Account");
}
If it is returning to login then it is going to else case.
+3
Jignesh Kumar5y ago
Hi,

Please refer this link to redirect from one controller to another controller method.
https://www.c-sharpcorner.com/blogs/asp-net-mvc-redirect-from-one-controller-action-to-another1
+3
Tri Setia5y ago
@Jignesh Kumar
this the AdminDashboardController.cs
using Microsoft.AspNetCore.Mvc;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
namespace AdminLTEMvc.Controllers
{
public class AdminDashboardController : Controller
{
public IActionResult Index()
{
return View();
}
}
}
this the Index.cshtml
inside Folder AdminDashboard l create Index.cshtml
@*
For more information on enabling MVC for empty projects, visit https://go.microsoft.com/fwlink/?LinkID=397860
*@
@{
Layout = "~/Views/Shared/AdminLayout.cshtml";
}

class="content">
class="container-fluid">
Welcome Admin

and this the AdminLayout.cshtml that accessed from Index.cshtml

that show message "Welcome Admin" if the success login.

Jignesh Kumar5y ago

Have debug the code?
Are you getting data in your reader ?

As per your lastscreenshot you are redirect to AccountController and Index method. Can you please share AdminDashBoardController here ? so we can help you..

I am suspecting you are not going in Loggin sucessful code and finally its redirecting to AccountController Index method.

Tri Setia5y ago

@Jignesh Kumar

this is AccountController.cs

using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Configuration;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using AdminLTEMvc.Models;
using Microsoft.Data.SqlClient;
using System.Data;
namespace AdminLTEMvc.Controllers
{
public class AccountController : Controller
{
private readonly IConfiguration _configuration;
public AccountController(IConfiguration configuration)
{
this._configuration = configuration;
}
[HttpGet]
public IActionResult Login()
{
return View();
}
[HttpPost]
[ValidateAntiForgeryToken]
public IActionResult Login(LoginViewModel loginViewModel)
{
try
{
using (SqlConnection con = new SqlConnection(_configuration.GetConnectionString("db_mvc")))
{
con.Open();
SqlCommand cmd = new SqlCommand("spLoginUser", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@user_name", loginViewModel.user_name);
cmd.Parameters.AddWithValue("@password", loginViewModel.password);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.Read())
{
ViewData["Pesan"] = "Berhasil Login";
//if success login
return RedirectToAction("Index", "AdminDashboard");
}
else
{
ViewData["Pesan"] = "User Name atau password salah,,, silahkan ulangi kembali !!!";
}
con.Close();
//if failed login
return RedirectToAction("Login", "Account");
}
}
catch(Exception)
{
throw;
}
}
}
}

what wrong with that AccountController.cs sir ???

Tri Setia5y ago

hi @Jignesh Kumar l has been try it but l got blank page after success login,,

problem not yet solved.

after success login get blank

Jignesh Kumar5y ago

Hi,

You need to redirect to Actionmethod of AdminDashbord controller, i.e. your controller name "AdminDashboard" and it has Action method like "Dashboard". Please do change according to your controller name and Actionmethodname.

if (rdr.Read()==true)
{
//if login success
return RedirectToAction("Index", "AdminDashboard");
}
else
{
//if login failed
return RedirectToAction("Login", "Account");
}

Satya Karki5y ago

Hi, according to your requirement, instead of redirecting to Home page you should redirect to Admin Dashboard Index page.

Inplace of this

//if login success
return RedirectToAction("Index", "Home");

redirect it to your Admin dashboard.

Salman Beg5y ago

If I understood your requirement correctly, you want to redirect to dashboard page after login success. So as per your code, replace return RedirectToAction("Index", "Home"); with your particular controller and action method inside RedirectToAction. Thanks

Login Form Mvc without EF in VS 2019

@Jignesh Kumaramazing sir, the code working if use this code block.

@Jignesh Kumar

Welcome Admin

@Jignesh Kumar
amazing sir, the code working if use this code block.