public IActionResult UserLogin([FromBody] MvUserLogin login)
{
var data = _service.GetLogin(login);
if (data == null)
{
return(NotFound());
}
return(Ok(data));
}
public IActionResult UserLogin([FromBody] MvUserLogin login)
{
try
{
var dataLogin = _service.GetLogin(login);
return(Ok(dataLogin));
}
catch (Exception)
{
throw;
}
}
public dynamic GetLogin(MvUserLogin userLogin)
{
using (SqlConnection sql = new SqlConnection(conn.ToString()))
{
using (SqlCommand command = new SqlCommand("SpUserLoginCheck", sql))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@UserName", userLogin.UserName));
command.Parameters.Add(new SqlParameter("@Password", userLogin.Password));
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
Console.WriteLine("user Exist");
return(reader);
}
return(null);
}
}
}
}
