how to remove owin security and login from database in mvc 5

public async Task Login(LoginViewModel model, string returnUrl)

{

if (!ModelState.IsValid)

{

return View(model);

}

// Require the user to have a confirmed email before they can log on.

var user = await UserManager.FindByNameAsync(model.Email);

if (user != null)

{

if (!await UserManager.IsEmailConfirmedAsync(user.Id))

{

string callbackUrl = await SendEmailConfirmationTokenAsync(user.Id, "Confirm your account-Resend");

ViewBag.errorMessage = "You must have a confirmed email to log on.";

return View("Error");

}

// This doesn't count login failures towards account lockout

// To enable password failures to trigger account lockout, change to shouldLockout: true

var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout: true);

switch (result)

{

case SignInStatus.Success:

return RedirectToLocal(returnUrl);

case SignInStatus.LockedOut:

return View("Lockout");

case SignInStatus.RequiresVerification:

return RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe });

case SignInStatus.Failure:

default:

ModelState.AddModelError("", "Invalid login attempt.");

return View(model);

}

this is my login i want to take the values from my database for logn here is the ado.net code

public bool Login(LoginViewModel login)

{

string constr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;

SqlConnection con = new SqlConnection(constr);

SqlCommand cmd = new SqlCommand("Login", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@Email", login.Email);

cmd.Parameters.AddWithValue("@Password", login.Password);

con.Open();

int i = cmd.ExecuteNonQuery();

con.Close();

if (i >= 1)

{

return true;

}

else

{

return false;

}

how do i integrate this code to get the login from my database plz help me

6 Replies

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

Shahbaz Kaware9y ago
im new for mvc i cant understand that
Arunprasath Gajapathi9y ago
simply you can use entity framework insted of ado.net, you can configure your connection string in webconfig file in your mvc project, you dont need those code,simply check the login credentials and redirect to your home page ,if login fails throw the errors using viewbag
Shahbaz Kaware9y ago
same hai connection name
Amit Kumar9y ago
Please check your connection name in webconfig file.
Shahbaz Kaware9y ago
public async Task Login(LoginViewModel model, string returnUrl)
{
if (!ModelState.IsValid)
{
return View(model);
}
// Require the user to have a confirmed email before they can log on.
var user = await UserManager.FindByNameAsync(model.Email);
if (user != null)
{
if (!await UserManager.IsEmailConfirmedAsync(user.Id))
{
string callbackUrl = await SendEmailConfirmationTokenAsync(user.Id, "Confirm your account-Resend");
ViewBag.errorMessage = "You must have a confirmed email to log on.";
return View("Error");
}
}
// This doesn't count login failures towards account lockout
// To enable password failures to trigger account lockout, change to shouldLockout: true
var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout: true);
switch (result)
{
case SignInStatus.Success:
return RedirectToLocal(returnUrl);
case SignInStatus.LockedOut:
return View("Lockout");
case SignInStatus.RequiresVerification:
return RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe });
case SignInStatus.Failure:
default:
ModelState.AddModelError("", "Invalid login attempt.");
return View(model);
}

this is my login i want to take the values from my database for logn here is the ado.net code

public bool Login(LoginViewModel login)
{
string constr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand("Login", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Email", login.Email);
cmd.Parameters.AddWithValue("@Password", login.Password);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
if (i >= 1)
{
return true;
}
else
{
return false;
}
}

how do i integrate this code to get the login from my database plz help me
Amit Kumar9y ago
Hi Dear,
Please use blow links.

https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/introduction/creating-a-connection-string