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); } } } }