/// <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["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.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.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.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["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);
}
/// <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.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);
}
}
/// <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);
}