Beispiel #1
0
        /// <summary>
        /// Run Candidates_SelectAll, and return results as a list of CandidatesRow.
        /// </summary>

        /// <returns>A collection of CandidatesRow.</returns>
        public static List <CandidatesContract> SelectAllNow()
        {
            var driver = new CandidatesLogic();

            driver.SelectAll();
            return(driver.Results);
        }
Beispiel #2
0
        /// <summary>
        /// Read all Candidates rows from the provided reader into the list structure of CandidatesRows
        /// </summary>
        /// <param name="reader">The result of running a sql command.</param>
        /// <returns>A populated CandidatesRows or an empty CandidatesRows if there are no results.</returns>
        public static List <CandidatesContract> ReadAllNow(SqlDataReader reader)
        {
            var driver = new CandidatesLogic();

            driver.ReadAll(reader);

            return(driver.Results);
        }
Beispiel #3
0
        /// <summary>
        /// Run Candidates_SelectAll, and return results as a list of CandidatesRow.
        /// </summary>

        /// <param name="connection">The SqlConnection to use</param>
        /// <param name="transaction">The SqlTransaction to use</param>
        /// <returns>A collection of CandidatesRow.</returns>
        public static List <CandidatesContract> SelectAllNow(SqlConnection connection, SqlTransaction transaction)
        {
            var driver = new CandidatesLogic();

            driver.SelectAll(connection, transaction);

            return(driver.Results);
        }
Beispiel #4
0
        /// <summary>
        /// Run Candidates_SelectBy_ConfirmedByUserId, and return results as a list of CandidatesRow.
        /// </summary>
        /// <param name="fldConfirmedByUserId">Value for ConfirmedByUserId</param>
        /// <returns>A collection of CandidatesRow.</returns>
        public static List <CandidatesContract> SelectBy_ConfirmedByUserIdNow(int fldConfirmedByUserId
                                                                              )
        {
            var driver = new CandidatesLogic();

            driver.SelectBy_ConfirmedByUserId(fldConfirmedByUserId
                                              );
            return(driver.Results);
        }
Beispiel #5
0
        /// <summary>
        /// Run Candidates_SelectBy_OrganizationId, and return results as a list of CandidatesRow.
        /// </summary>
        /// <param name="fldOrganizationId">Value for OrganizationId</param>
        /// <returns>A collection of CandidatesRow.</returns>
        public static List <CandidatesContract> SelectBy_OrganizationIdNow(int fldOrganizationId
                                                                           )
        {
            var driver = new CandidatesLogic();

            driver.SelectBy_OrganizationId(fldOrganizationId
                                           );
            return(driver.Results);
        }
Beispiel #6
0
        /// <summary>
        /// Run Candidates_SelectBy_ConfirmedByUserId, and return results as a list of CandidatesRow.
        /// </summary>
        /// <param name="fldConfirmedByUserId">Value for ConfirmedByUserId</param>
        /// <param name="connection">The SqlConnection to use</param>
        /// <param name="transaction">The SqlTransaction to use</param>
        /// <returns>A collection of CandidatesRow.</returns>
        public static List <CandidatesContract> SelectBy_ConfirmedByUserIdNow(int fldConfirmedByUserId
                                                                              , SqlConnection connection, SqlTransaction transaction)
        {
            var driver = new CandidatesLogic();

            driver.SelectBy_ConfirmedByUserId(fldConfirmedByUserId
                                              , connection, transaction);

            return(driver.Results);
        }
Beispiel #7
0
        /// <summary>
        /// Run Candidates_Search, and return results as a list of CandidatesRow.
        /// </summary>
        /// <param name="fldCandidateName">Value for CandidateName</param>
        /// <param name="fldSourceUrl">Value for SourceUrl</param>
        /// <returns>A collection of CandidatesRow.</returns>
        public static List <CandidatesContract> SearchNow(string fldCandidateName
                                                          , string fldSourceUrl
                                                          )
        {
            var driver = new CandidatesLogic();

            driver.Search(fldCandidateName
                          , fldSourceUrl
                          );
            return(driver.Results);
        }
Beispiel #8
0
        /// <summary>
        /// Run Candidates_Search, and return results as a list of CandidatesRow.
        /// </summary>
        /// <param name="fldCandidateName">Value for CandidateName</param>
        /// <param name="fldSourceUrl">Value for SourceUrl</param>
        /// <param name="connection">The SqlConnection to use</param>
        /// <param name="transaction">The SqlTransaction to use</param>
        /// <returns>A collection of CandidatesRow.</returns>
        public static List <CandidatesContract> SearchNow(string fldCandidateName
                                                          , string fldSourceUrl
                                                          , SqlConnection connection, SqlTransaction transaction)
        {
            var driver = new CandidatesLogic();

            driver.Search(fldCandidateName
                          , fldSourceUrl
                          , connection, transaction);

            return(driver.Results);
        }
Beispiel #9
0
        /// <summary>");
        /// Advance one, and read values into a Candidates
        /// </summary>
        /// <param name="reader">The result of running a sql command.</param>");
        /// <returns>A Candidates or null if there are no results.</returns>
        public static CandidatesContract ReadOneNow(SqlDataReader reader)
        {
            var driver = new CandidatesLogic();

            return(driver.ReadOne(reader) ? driver.Results[0] : null);
        }