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