public Task <List <UserDetails> > GetAllUsers() { List <UserDetails> lstDetails = new List <UserDetails>(); using (sqlConnection = new SqlConnection(connection)) { sqlCommand = new SqlCommand("select * from Credentials", sqlConnection); sqlConnection.Open(); using (var objDataReader = sqlCommand.ExecuteReader()) { while (objDataReader.Read()) { lstDetails.Add(UserDetails.Fill((IDataRecord)objDataReader)); } } return(Task.FromResult(lstDetails)); } }
public Task <UserDetails> Login(UserDetails userDetails) { bool rowAffected = false; using (sqlConnection = new SqlConnection(connection)) { sqlCommand = new SqlCommand("Login", sqlConnection); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add("@UserDetails", SqlDbType.Structured).Value = CreateDataTable(userDetails); sqlConnection.Open(); using (var objDataReader = sqlCommand.ExecuteReader()) { while (objDataReader.Read()) { userDetails = UserDetails.Fill((IDataRecord)objDataReader); } } return(Task.FromResult(userDetails)); } }