コード例 #1
0
        /// <summary>
        /// reads the column values from a datareader and populates the object properties
        /// </summary>
        /// <param name="reader"></param>
        public override void Load(MySqlDataReader reader)
        {
            this.Id                 = Preparer.SafeInt(reader["o_id"]);
            this.InternalId         = Preparer.SafeString(reader["o_internal_id"]);
            this.InternalATSId      = Preparer.SafeString(reader["o_internal_ats_id"]);
            this.CustomerId         = Preparer.SafeString(reader["o_customer_id"]);
            this.Pin                = Preparer.SafeString(reader["o_pin"]);
            this.AdditionalPins     = Preparer.SafeString(reader["o_additional_pins"]);
            this.PropertyAddress    = Preparer.SafeString(reader["o_property_address"]);
            this.PropertyAddress2   = Preparer.SafeString(reader["o_property_address_2"]);
            this.PropertyCity       = Preparer.SafeString(reader["o_property_city"]);
            this.PropertyState      = Preparer.SafeString(reader["o_property_state"]);
            this.PropertyZip        = Preparer.SafeString(reader["o_property_zip"]);
            this.PropertyCounty     = Preparer.SafeString(reader["o_property_county"]);
            this.PropertyUse        = Preparer.SafeString(reader["o_property_use"]);
            this.InternalStatusCode = Preparer.SafeString(reader["o_internal_status_code"]);
            this.CustomerStatusCode = Preparer.SafeString(reader["o_customer_status_code"]);
            this.OriginatorId       = Preparer.SafeInt(reader["o_originator_id"]);
            this.Created            = Preparer.SafeDateTime(reader["o_created"]);
            this.Modified           = Preparer.SafeDateTime(reader["o_modified"]);
            this.ClosingDate        = Preparer.SafeDateTime(reader["o_closing_date"]);
            this.ClientName         = Preparer.SafeString(reader["o_client_name"]);
            this.OrderUploadLogId   = Preparer.SafeInt(reader["o_oul_id"]);

            this.OnLoad(reader);
        }
コード例 #2
0
ファイル: CompanyDao.cs プロジェクト: radtek/affinityistitle
        /// <summary>
        /// reads the column values from a datareader and populates the object properties
        /// </summary>
        /// <param name="reader"></param>
        public override void Load(MySqlDataReader reader)
        {
            this.Id      = Preparer.SafeInt(reader["c_id"]);
            this.Name    = Preparer.SafeString(reader["c_name"]);
            this.Created = Preparer.SafeDateTime(reader["c_created"]);

            this.OnLoad(reader);
        }
コード例 #3
0
ファイル: HUDLogDAO.cs プロジェクト: radtek/affinityistitle
        /// <summary>
        /// reads the column values from a datareader and populates the object properties
        /// </summary>
        /// <param name="reader"></param>
        public override void Load(MySqlDataReader reader)
        {
            this.Id            = Preparer.SafeInt(reader["h_id"]);
            this.AccountID     = Preparer.SafeInt(reader["a_id"]);
            this.SubmissionXML = Preparer.SafeString(reader["h_submission_xml"]);
            this.Created       = Preparer.SafeDateTime(reader["h_created"]);
            this.Modified      = Preparer.SafeDateTime(reader["h_modified"]);

            this.OnLoad(reader);
        }
コード例 #4
0
ファイル: TitleFeeDao.cs プロジェクト: radtek/affinityistitle
        /// <summary>
        /// reads the column values from a datareader and populates the object properties
        /// </summary>
        /// <param name="reader"></param>
        public override void Load(MySqlDataReader reader)
        {
            this.Id       = Preparer.SafeString(reader["tf_id"]);
            this.FeeType  = Preparer.SafeString(reader["tf_type"]);
            this.Name     = Preparer.SafeString(reader["tf_name"]);
            this.Fee      = Preparer.SafeDecimal(reader["tf_fee"]);
            this.Modified = Preparer.SafeDateTime(reader["tf_modified"]);
            this.Created  = Preparer.SafeDateTime(reader["tf_created"]);

            this.OnLoad(reader);
        }
コード例 #5
0
        /// <summary>
        /// reads the column values from a datareader and populates the object properties
        /// </summary>
        /// <param name="reader"></param>
        public override void Load(MySqlDataReader reader)
        {
            this.Code            = Preparer.SafeString(reader["ct_code"]);
            this.MetaTitle       = Preparer.SafeString(reader["ct_meta_title"]);
            this.MetaKeywords    = Preparer.SafeString(reader["ct_meta_keywords"]);
            this.MetaDescription = Preparer.SafeString(reader["ct_meta_description"]);
            this.Header          = Preparer.SafeString(reader["ct_header"]);
            this.Body            = Preparer.SafeString(reader["ct_body"]);
            this.Modified        = Preparer.SafeDateTime(reader["ct_modified"]);

            this.OnLoad(reader);
        }
コード例 #6
0
        /// <summary>
        /// reads the column values from a datareader and populates the object properties
        /// </summary>
        /// <param name="reader"></param>
        public override void Load(MySqlDataReader reader)
        {
            this.Id           = Preparer.SafeInt(reader["el_id"]);
            this.AccountID    = Preparer.SafeInt(reader["a_id"]);
            this.OrderID      = Preparer.SafeInt(reader["o_id"]);
            this.RequestID    = Preparer.SafeInt(reader["r_id"]);
            this.ExportFormat = Preparer.SafeString(reader["export_format"]);
            this.Created      = Preparer.SafeDateTime(reader["el_created"]);
            this.Modified     = Preparer.SafeDateTime(reader["el_modified"]);

            this.OnLoad(reader);
        }
コード例 #7
0
        /// <summary>
        /// reads the column values from a datareader and populates the object properties
        /// </summary>
        /// <param name="reader"></param>
        public override void Load(MySqlDataReader reader)
        {
            this.Id              = Preparer.SafeInt(reader["ul_id"]);
            this.AccountID       = Preparer.SafeInt(reader["a_id"]);
            this.UploadAccountID = Preparer.SafeInt(reader["ua_id"]);
            this.OrderID         = Preparer.SafeInt(reader["o_id"]);
            this.RequestID       = Preparer.SafeInt(reader["r_id"]);
            this.AttachmentID    = Preparer.SafeInt(reader["att_id"]);
            this.Created         = Preparer.SafeDateTime(reader["ul_created"]);
            this.Modified        = Preparer.SafeDateTime(reader["ul_modified"]);

            this.OnLoad(reader);
        }
コード例 #8
0
        /// <summary>
        /// reads the column values from a datareader and populates the object properties
        /// </summary>
        /// <param name="reader"></param>
        public override void Load(MySqlDataReader reader)
        {
            this.Id          = Preparer.SafeInt(reader["att_id"]);
            this.RequestId   = Preparer.SafeInt(reader["att_request_id"]);
            this.Name        = Preparer.SafeString(reader["att_name"]);
            this.MimeType    = Preparer.SafeString(reader["att_mime_type"]);
            this.SizeKb      = Preparer.SafeInt(reader["att_size_kb"]);
            this.Created     = Preparer.SafeDateTime(reader["att_created"]);
            this.Filepath    = Preparer.SafeString(reader["att_filepath"]);
            this.PurposeCode = Preparer.SafeString(reader["att_purpose_code"]);

            this.OnLoad(reader);
        }
コード例 #9
0
        /// <summary>
        /// reads the column values from a datareader and populates the object properties
        /// </summary>
        /// <param name="reader"></param>
        public override void Load(MySqlDataReader reader)
        {
            this.Id = Preparer.SafeInt(reader["r_id"]);
            this.RequestTypeCode = Preparer.SafeString(reader["r_request_type_code"]);
            this.OrderId         = Preparer.SafeInt(reader["r_order_id"]);
            this.OriginatorId    = Preparer.SafeInt(reader["r_originator_id"]);
            this.Created         = Preparer.SafeDateTime(reader["r_created"]);
            this.StatusCode      = Preparer.SafeString(reader["r_status_code"]);
            this.Xml             = Preparer.SafeString(reader["r_xml"]);
            this.IsCurrent       = Preparer.SafeBool(reader["r_is_current"]);
            this.Note            = Preparer.SafeString(reader["r_note"]);

            this.OnLoad(reader);
        }
コード例 #10
0
ファイル: ScheduleDAO.cs プロジェクト: radtek/affinityistitle
        /// <summary>
        /// reads the column values from a datareader and populates the object properties
        /// </summary>
        /// <param name="reader"></param>
        public override void Load(MySqlDataReader reader)
        {
            if (reader.HasRows)
            {
                this.Id                  = Preparer.SafeInt(reader["s_id"]);
                this.AccountID           = Preparer.SafeInt(reader["a_id"]);
                this.OrderID             = Preparer.SafeInt(reader["o_id"]);
                this.RequestID           = Preparer.SafeInt(reader["r_id"]);
                this.AttachmentID        = Preparer.SafeInt(reader["att_id"]);
                this.UploadAccountID     = Preparer.SafeInt(reader["ua_id"]);
                this.Search_package_date = Preparer.SafeDateTime(reader["s_search_package_date"]);
                this.First_notification  = Preparer.SafeDateTime(reader["s_first_notification"]);
                this.Second_notification = Preparer.SafeDateTime(reader["s_second_notification"]);
                this.Modified            = Preparer.SafeDateTime(reader["s_modified"]);
                this.Created             = Preparer.SafeDateTime(reader["s_created"]);

                this.OnLoad(reader);
            }
        }
コード例 #11
0
ファイル: AccountDao.cs プロジェクト: radtek/affinityistitle
        /// <summary>
        /// reads the column values from a datareader and populates the object properties
        /// </summary>
        /// <param name="reader"></param>
        public override void Load(MySqlDataReader reader)
        {
            this.Id                      = Preparer.SafeInt(reader["a_id"]);
            this.Username                = Preparer.SafeString(reader["a_username"]);
            this.Password                = Preparer.SafeString(reader["a_password"]);
            this.FirstName               = Preparer.SafeString(reader["a_first_name"]);
            this.LastName                = Preparer.SafeString(reader["a_last_name"]);
            this.StatusCode              = Preparer.SafeString(reader["a_status_code"]);
            this.Created                 = Preparer.SafeDateTime(reader["a_created"]);
            this.Modified                = Preparer.SafeDateTime(reader["a_modified"]);
            this.PasswordHint            = Preparer.SafeString(reader["a_password_hint"]);
            this.PreferencesXml          = Preparer.SafeString(reader["a_preferences_xml"]);
            this.RoleCode                = Preparer.SafeString(reader["a_role_code"]);
            this.CompanyId               = Preparer.SafeInt(reader["a_company_id"]);
            this.InternalId              = Preparer.SafeString(reader["a_internal_id"]);
            this.Email                   = Preparer.SafeString(reader["a_email"]);
            this.UnderwriterCodes        = Preparer.SafeString(reader["a_underwriter_codes"]);
            this.UnderwriterEndorsements = Preparer.SafeString(reader["a_underwriter_endorsements"]);
            this.BusinessLicenseID       = Preparer.SafeString(reader["a_business_license_id"]);
            this.IndividualLicenseID     = Preparer.SafeString(reader["a_individual_license_id"]);
            this.Signature               = Preparer.SafeString(reader["a_signature"]);

            this.OnLoad(reader);
        }