/// <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); }
/// <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["ap_code"]); this.Description = Preparer.SafeString(reader["ap_description"]); this.SendNotification = Preparer.SafeBool(reader["ap_send_notification"]); this.ChangeStatusTo = Preparer.SafeString(reader["ap_change_status_to"]); this.PermissionRequired = Preparer.SafeInt(reader["ap_permission_required"]); // Get all associated roles for this attachment purpose AttachmentRole ardao = new AttachmentRole(this.phreezer); AttachmentRolesCriteria arcrit = new AttachmentRolesCriteria(); arcrit.AttachmentPurposeCode = reader["ap_code"].ToString(); AttachmentRoles aroles = ardao.GetAttachmentRoles(arcrit); IEnumerator i = aroles.GetEnumerator(); StringBuilder sb = new StringBuilder(); // put roles into a comma-delimited list while (i.MoveNext()) { AttachmentRole r = (AttachmentRole)i.Current; sb.Append(r.RoleDescription + ", "); } // trim off comma at the end if (sb.Length > 2) { sb.Length = sb.Length - 2; } this.Roles = Preparer.SafeString(sb.ToString()); this.OnLoad(reader); }
/// <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["l_code"]); this.Description = Preparer.SafeString(reader["l_description"]); this.OnLoad(reader); }
/// <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.AccountId = Preparer.SafeInt(reader["oa_account_id"]); this.OrderId = Preparer.SafeInt(reader["oa_order_id"]); this.PermissionBit = Preparer.SafeString(reader["oa_permission_bit"]); this.OnLoad(reader); }
/// <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); }
/// <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["rs_code"]); this.Description = Preparer.SafeString(reader["rs_description"]); this.PermissionBit = Preparer.SafeInt(reader["rs_permission_bit"]); this.OnLoad(reader); }
/// <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.RoleCode = Preparer.SafeString(reader["ap_code"]); this.RoleDescription = Preparer.SafeString(reader["r_description"]); this.AttachmentPurposeCode = Preparer.SafeString(reader["ap_code"]); this.AttachmentPurposeDescription = Preparer.SafeString(reader["ap_description"]); this.OnLoad(reader); }
/// <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); }
/// <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["os_code"]); this.Description = Preparer.SafeString(reader["os_description"]); this.PermissionBit = Preparer.SafeInt(reader["os_permission_bit"]); this.InternalExternal = Preparer.SafeBool(reader["os_internal_external"]); this.IsClosed = Preparer.SafeBool(reader["os_is_closed"]); this.OnLoad(reader); }
/// <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["rt_code"]); this.Description = Preparer.SafeString(reader["rt_description"]); this.ExportFormats = Preparer.SafeString(reader["rt_export_formats"]); this.Definition = Preparer.SafeString(reader["rt_definition"]); this.IsActive = Preparer.SafeBool(reader["rt_is_active"]); this.OnLoad(reader); }
/// <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.Zip = Preparer.SafeString(reader["Zip"]); this.City = Preparer.SafeString(reader["City"]); this.State = Preparer.SafeString(reader["State"]); this.County = Preparer.SafeString(reader["County"]); this.FipsCode = Preparer.SafeString(reader["FipsCode"]); this.OnLoad(reader); }
/// <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); }
/// <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); }
/// <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); }
/// <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); }
/// <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); }
/// <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.Taxing_district = Preparer.SafeString(reader["taxing_district"]); this.Type = Preparer.SafeString(reader["type"]); this.County = Preparer.SafeString(reader["county"]); this.Liable_party = Preparer.SafeString(reader["liable_party"]); this.Amount = Preparer.SafeString(reader["amount"]); this.Where = Preparer.SafeString(reader["where"]); this.Address = Preparer.SafeString(reader["address"]); this.CSZ = Preparer.SafeString(reader["csz"]); this.Phone = Preparer.SafeString(reader["phone"]); this.Website = Preparer.SafeString(reader["website"]); this.Stamp_exempt = Preparer.SafeString(reader["stamp_exempt"]); this.Notes = Preparer.SafeString(reader["notes"]); this.Stamp_required = Preparer.SafeInt(reader["stamp_required"]); this.OnLoad(reader); } }
/// <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); }