public ActionResult Login(Activity2Part3.Models.UserModel model)
{
try
{
logger.Info("Entering Login()");
if (!ModelState.IsValid)
{
return(View("Login"));
}
Services.Business.SecurityService service = new Services.Business.SecurityService();
logger.Info("Parameters are: " + new JavaScriptSerializer().Serialize(model));
bool authenticated = service.Authenticate(model);
if (authenticated)
{
logger.Info("Exiting Login() with pass");
return(View("LoginPassed", model));
}
else
{
logger.Info("Exiting Login() with Login failed");
return(View("LoginFailed"));
}
} catch (Exception e)
{
logger.Error("Login() exit with error: " + e.Message);
}
return(View("LoginFailed"));
}
public bool FindByUser(Activity2Part3.Models.UserModel user)
{
SqlConnection conn = new SqlConnection("data source=(localdb)\\MSSQLLocalDB; database=Test; integrated security = SSPI");
SqlCommand cmnd = new SqlCommand("SELECT * FROM Users WHERE Username = '******' AND Password = '******'", conn);
conn.Open();
SqlDataReader reader = cmnd.ExecuteReader();
if (reader.HasRows)
{
return(true);
}
else
{
return(false);
}
}
public bool Authenticate(Activity2Part3.Models.UserModel user)
{
Data.SecurityDAO DAO = new Data.SecurityDAO();
return(DAO.FindByUser(user));
}
