protected qPtl_Announcement(DbRow c)
{
container = c;
container.SetContainerName("qPtl_Announcements");
announcement_id = container.NewColumn<Int32>("AnnouncementID", true);
scope_id = container.NewColumn<Int32>("ScopeID");
available = container.NewColumn<String>("Available");
created = container.NewColumn<DateTime>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
last_modified = container.NewColumn<DateTime?>("LastModified");
last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
announcement_for_campaign_id = container.NewColumn<Int32>("AnnouncementForCampaignID");
uri = container.NewColumn<String>("URI");
title = container.NewColumn<String>("Title");
text = container.NewColumn<String>("Text");
generic = container.NewColumn<String>("Generic");
generic_available_from = container.NewColumn<DateTime?>("GenericAvailableFrom");
generic_available_to = container.NewColumn<DateTime?>("GenericAvailableTo");
remind_every_days = container.NewColumn<Int32>("RemindEveryDays");
content_type_id = container.NewColumn<Int32>("ContentTypeID");
reference_id = container.NewColumn<Int32>("ReferenceID");
one_time = container.NewColumn<Boolean>("OneTime");
associated_announcement_id = container.NewColumn<Int32>("AssociatedAnnouncementID");
}
protected qPtl_RoleAction(DbRow c)
{
container = c;
container.SetContainerName("qPtl_RoleActions");
role_action_id = container.NewColumn<Int32>("RoleActionID", true);
scope_id = container.NewColumn<Int32>("ScopeID");
available = container.NewColumn<String>("Available");
created = container.NewColumn<DateTime>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
last_modified = container.NewColumn<DateTime?>("LastModified");
last_modified_by = container.NewColumn<Int32?>("LastModifiedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
role_id = container.NewColumn<Int32>("RoleID");
action_id = container.NewColumn<Int32>("ActionID");
start_days_from_now = container.NewColumn<Int32>("StartDaysFromNow");
end_days_from_now = container.NewColumn<Int32>("EndDaysFromNow");
after_num_logins = container.NewColumn<Int32>("AfterNumLogins");
priority = container.NewColumn<Int32>("Priority");
skip_allowed = container.NewColumn<String>("SkipAllowed");
number_skips_allowed = container.NewColumn<Int32>("NumberSkipsAllowed");
required = container.NewColumn<String>("Required");
option_opt_out = container.NewColumn<String>("OptionOptOut");
redirect_url = container.NewColumn<String>("RedirectURL");
redirect_skip_url = container.NewColumn<String>("RedirectSkipURL");
}
protected qCom_Contact(DbRow c)
{
container = c;
container.SetContainerName("qCom_Contacts");
contact_id = container.NewColumn<Int32>("ContactID", true);
scope_id = container.NewColumn<Int32>("ScopeID");
available = container.NewColumn<String>("Available");
created = container.NewColumn<DateTime>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
last_modified = container.NewColumn<DateTime?>("LastModified");
last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
first_name = container.NewColumn<String>("FirstName");
last_name = container.NewColumn<String>("LastName");
email = container.NewColumn<String>("Email");
keywords = container.NewColumn<String>("Keywords");
source = container.NewColumn<String>("Source");
user_id = container.NewColumn<Int32>("UserID");
ok_email = container.NewColumn<String>("OkEmail");
did = container.NewColumn<String>("DID");
partner = container.NewColumn<String>("Partner");
main_group = container.NewColumn<Int32>("MainGroup");
sub_group = container.NewColumn<Int32>("SubGroup");
custom_html_element = container.NewColumn<String>("CustomHTMLElement");
dm_misc = container.NewColumn<String>("DM_Misc");
unsubscribed = container.NewColumn<DateTime?>("Unsubscribed");
unsubscribed_campaign_id = container.NewColumn<Int32>("UnsubscribedCampaignID");
reported_as_spam = container.NewColumn<DateTime?>("ReportedAsSpam");
reported_as_spam_campaign_id = container.NewColumn<Int32>("ReportedAsSpamCampaignID");
action_log = container.NewColumn<String>("ActionLog");
}
protected qOrg_School(DbRow c)
{
container = c;
container.SetContainerName("qOrg_Schools");
school_id = container.NewColumn<Int32>("SchoolID", true);
scope_id = container.NewColumn<Int32>("ScopeID");
available = container.NewColumn<String>("Available");
created = container.NewColumn<DateTime>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
last_modified = container.NewColumn<DateTime?>("LastModified");
last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
school_selector = container.NewColumn<String>("SchoolSelector");
school = container.NewColumn<String>("School");
address1 = container.NewColumn<String>("Address1");
address2 = container.NewColumn<String>("Address2");
city = container.NewColumn<String>("City");
state_province = container.NewColumn<String>("StateProvince");
postal_code = container.NewColumn<String>("PostalCode");
country = container.NewColumn<String>("Country");
district = container.NewColumn<String>("District");
school_type = container.NewColumn<String>("SchoolType");
school_level = container.NewColumn<String>("SchoolLevel");
school_district_id = container.NewColumn<Int32>("SchoolDistrictID");
school_phone = container.NewColumn<String>("SchoolPhone");
school_fax = container.NewColumn<String>("SchoolFax");
longitude = container.NewColumn<Decimal>("Longitude");
latitude = container.NewColumn<Decimal>("Latitude");
}
protected qPtl_UserRole(DbRow c)
{
container = c;
container.SetContainerName("qPtl_UserRoles");
user_id = container.NewColumn<Int32>("UserID", true);
role_id = container.NewColumn<Int32>("RoleID", true);
}
protected qPtl_User(DbRow c)
{
container = c;
container.SetContainerName("qPtl_Users");
user_id = container.NewColumn<Int32>("UserID", true);
org_unit_id = container.NewColumn<Int32>("OrgUnitID");
scope_id = container.NewColumn<Int32>("ScopeID");
available = container.NewColumn<String>("Available");
created = container.NewColumn<DateTime>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
last_modified = container.NewColumn<DateTime?>("LastModified");
last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
username = container.NewColumn<String>("UserName");
password = container.NewColumn<String>("Password");
password_reset_code = container.NewColumn<String>("PasswordResetCode");
first_name = container.NewColumn<String>("FirstName");
last_name = container.NewColumn<String>("LastName");
email = container.NewColumn<String>("Email");
comments = container.NewColumn<String>("Comments");
dm_user_id = container.NewColumn<Int32>("DM_UserID");
dm_status_id = container.NewColumn<Int32>("DM_StatusID");
highest_role = container.NewColumn<String>("HighestRole");
highest_rank = container.NewColumn<Int32>("HighestRank");
last_time_seen = container.NewColumn<DateTime?>("LastTimeSeen");
last_ip_address = container.NewColumn<String>("LastIPAddress");
profile_pict = container.NewColumn<String>("ProfilePict");
status = container.NewColumn<String>("Status");
status_date = container.NewColumn<DateTime?>("StatusDate");
account_status = container.NewColumn<String>("AccountStatus");
last_activity = container.NewColumn<Int32>("LastActivity");
number_logins = container.NewColumn<Int32>("NumberLogins");
registration_type = container.NewColumn<String>("RegistrationType");
registration_notes = container.NewColumn<String>("RegistrationNotes");
}
protected qHtl_AbsenteeAnalysisVariable(DbRow c)
{
container = c;
container.SetContainerName("qHtl_AbsenteeAnalysisVariables");
absentee_analysis_variable_id = container.NewColumn<Int32>("AbsenteeAnalysisVariableID", true);
school_district_id = container.NewColumn<Int32>("SchoolDistrictID");
solution_start_date = container.NewColumn<DateTime?>("SolutionStartDate");
green_rate_std_multiplier = container.NewColumn<Decimal>("GreenRateSTDMultiplier");
yellow_rate_std_multiplier = container.NewColumn<Decimal>("YellowRateSTDMultiplier");
red_rate_std_multiplier = container.NewColumn<Decimal>("RedRateSTDMultiplier");
green_illness_boundary = container.NewColumn<Decimal>("GreenIllnessBoundary");
yellow_illness_boundary = container.NewColumn<Decimal>("YellowIllnessBoundary");
red_illness_boundary = container.NewColumn<Decimal>("RedIllnessBoundary");
green_gastrointestinal_boundary = container.NewColumn<Decimal>("GreenGastrointestinalBoundary");
yellow_gastrointestinal_boundary = container.NewColumn<Decimal>("YellowGastrointestinalBoundary");
red_gastrointestinal_boundary = container.NewColumn<Decimal>("RedGastrointestinalBoundary");
green_respiratory_boundary = container.NewColumn<Decimal>("GreenRespiratoryBoundary");
yellow_respiratory_boundary = container.NewColumn<Decimal>("YellowRespiratoryBoundary");
red_respiratory_boundary = container.NewColumn<Decimal>("RedRespiratoryBoundary");
green_rash_boundary = container.NewColumn<Decimal>("GreenRashBoundary");
yellow_rash_boundary = container.NewColumn<Decimal>("YellowRashBoundary");
red_rash_boundary = container.NewColumn<Decimal>("RedRashBoundary");
green_other_illness_boundary = container.NewColumn<Decimal>("GreenOtherIllnessBoundary");
yellow_other_illness_boundary = container.NewColumn<Decimal>("YellowOtherIllnessBoundary");
red_other_illness_boundary = container.NewColumn<Decimal>("RedOtherIllnessBoundary");
green_unknown_illness_boundary = container.NewColumn<Decimal>("GreenUnknownIllnessBoundary");
yellow_unknown_illness_boundary = container.NewColumn<Decimal>("YellowUnknownIllnessBoundary");
red_unknown_illness_boundary = container.NewColumn<Decimal>("RedUnknownIllnessBoundary");
sd_formula_type = container.NewColumn<String>("SDFormulaType");
}
protected qPtl_Task(DbRow c)
{
container = c;
container.SetContainerName("qPtl_Tasks");
task_id = container.NewColumn<Int32>("TaskID", true);
scope_id = container.NewColumn<Int32>("ScopeID");
available = container.NewColumn<String>("Available");
created = container.NewColumn<DateTime>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
last_modified = container.NewColumn<DateTime?>("LastModified");
last_modified_by = container.NewColumn<Int32?>("LastModifiedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
task_type_id = container.NewColumn<Int32>("TaskTypeID");
assigned_to = container.NewColumn<Int32?>("AssignedTo");
assigned_text = container.NewColumn<String>("AssignedText");
start_date = container.NewColumn<DateTime?>("StartDate");
due_date = container.NewColumn<DateTime?>("DueDate");
percent_completed = container.NewColumn<Double>("PercentCompleted");
status = container.NewColumn<String>("Status");
name = container.NewColumn<String>("Name");
description = container.NewColumn<String>("Description");
importance = container.NewColumn<Int32>("Importance");
content_type_id = container.NewColumn<Int32>("ContentTypeID");
reference_id = container.NewColumn<Int32>("ReferenceID");
}
protected qHtl_HealthProvider(DbRow c)
{
container = c;
container.SetContainerName("qHtl_HealthProviders");
health_provider_id = container.NewColumn<Int32>("HealthProviderID", true);
scope_id = container.NewColumn<Int32>("ScopeID");
available = container.NewColumn<String>("Available");
created = container.NewColumn<DateTime>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
last_modified = container.NewColumn<DateTime?>("LastModified");
last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
health_provider_type = container.NewColumn<String>("HealthProviderType");
name = container.NewColumn<String>("name");
description = container.NewColumn<String>("description");
address1 = container.NewColumn<String>("Address1");
address2 = container.NewColumn<String>("Address2");
city = container.NewColumn<String>("City");
state_province = container.NewColumn<String>("StateProvince");
postal_code = container.NewColumn<String>("PostalCode");
country = container.NewColumn<String>("Country");
phone = container.NewColumn<String>("Phone");
website = container.NewColumn<String>("Website");
service_type = container.NewColumn<String>("ServiceType");
service_categories = container.NewColumn<String>("ServiceCategories");
}
protected qHtl_HealthWarning(DbRow c)
{
container = c;
container.SetContainerName("qHtl_HealthWarnings");
health_warning_id = container.NewColumn<Int32>("HealthWarningID", true);
created = container.NewColumn<DateTime>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
data_date = container.NewColumn<DateTime?>("DataDate");
type = container.NewColumn<String>("Type");
title = container.NewColumn<String>("Title");
text = container.NewColumn<String>("Text");
notes = container.NewColumn<String>("Notes");
severity = container.NewColumn<String>("Severity");
issued_by = container.NewColumn<Int32>("IssuedBy");
issued_by_name = container.NewColumn<String>("IssuedByName");
review_status = container.NewColumn<String>("ReviewStatus");
issued_to = container.NewColumn<String>("IssuedTo");
valid_from = container.NewColumn<DateTime?>("ValidFrom");
valid_until = container.NewColumn<DateTime?>("ValidUntil");
multiple_classrooms = container.NewColumn<String>("MultipleClassrooms");
multiple_schools = container.NewColumn<String>("MultipleSchools");
school_levels = container.NewColumn<String>("SchoolLevels");
content_type_id = container.NewColumn<Int32>("ContentTypeID");
reference_id = container.NewColumn<Int32>("ReferenceID");
email_id = container.NewColumn<Int32>("EmailID");
notification_id = container.NewColumn<Int32>("NotificationID");
sms_message_id = container.NewColumn<Int32>("SMSMessageID");
}
protected qCom_UserPreference(DbRow c)
{
container = c;
container.SetContainerName("qCom_UserPreferences");
contact_preference_id = container.NewColumn<Int32>("ContactPreferenceID", true);
user_id = container.NewColumn<Int32>("UserID");
available = container.NewColumn<String>("Available");
scope_id = container.NewColumn<Int32>("ScopeID");
created = container.NewColumn<DateTime?>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
last_modified = container.NewColumn<DateTime?>("LastModified");
last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
ok_bulk_email = container.NewColumn<String>("OkBulkEmail");
ok_email = container.NewColumn<String>("OkEmail");
ok_phone = container.NewColumn<String>("OkPhone");
ok_fax = container.NewColumn<String>("OkFax");
ok_solicit = container.NewColumn<String>("OkSolicit");
ok_mail = container.NewColumn<String>("OkMail");
ok_partner_contact = container.NewColumn<String>("OkPartnerContact");
ok_sms = container.NewColumn<String>("OkSms");
ok_notifications = container.NewColumn<String>("OkNotifications");
confirm_sms = container.NewColumn<String>("ConfirmSms");
language_id = container.NewColumn<Int32>("LanguageID");
mobile_pin = container.NewColumn<String>("MobilePIN");
mobile_pin_verified = container.NewColumn<DateTime?>("MobilePINVerified");
default_sms_did = container.NewColumn<String>("DefaultSmsDid");
sms_active_minutes_window = container.NewColumn<Int32>("SmsActiveMinutesWindow");
}
protected qPtl_UserAction(DbRow c)
{
container = c;
container.SetContainerName("qPtl_UserActions");
user_action_id = container.NewColumn<Int32>("UserActionID", true);
scope_id = container.NewColumn<Int32>("ScopeID");
available = container.NewColumn<String>("Available");
created = container.NewColumn<DateTime>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
last_modified = container.NewColumn<DateTime?>("LastModified");
last_modified_by = container.NewColumn<Int32?>("LastModifiedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
user_id = container.NewColumn<Int32>("UserID");
action_id = container.NewColumn<Int32>("ActionID");
assign_type = container.NewColumn<String>("AssignType");
available_from = container.NewColumn<DateTime?>("AvailableFrom");
available_to = container.NewColumn<DateTime?>("AvailableTo");
after_num_logins = container.NewColumn<Int32>("AfterNumLogins");
priority = container.NewColumn<Int32>("Priority");
skip_allowed = container.NewColumn<String>("SkipAllowed");
number_skips_allowed = container.NewColumn<Int32>("NumberSkipsAllowed");
required = container.NewColumn<String>("Required");
optional_opt_out = container.NewColumn<String>("OptionalOptOut");
user_completed = container.NewColumn<DateTime?>("UserCompleted");
user_opt_out = container.NewColumn<DateTime?>("UserOptOut");
user_num_skips = container.NewColumn<Int32>("UserNumSkips");
user_last_skip = container.NewColumn<DateTime?>("UserLastSkip");
last_user_action_session_id = container.NewColumn<Int32>("LastUserActionSessionID");
reference_id = container.NewColumn<Int32>("ReferenceID");
redirect_url = container.NewColumn<String>("RedirectURL");
redirect_skip_url = container.NewColumn<String>("RedirectSkipURL");
}
protected qPtl_Language(DbRow c)
{
container = c;
container.SetContainerName("qPtl_Languages");
language_id = container.NewColumn<Int32>("LanguageID", true);
display_name = container.NewColumn<String>("DisplayName");
code = container.NewColumn<String>("Code");
available = container.NewColumn<Boolean>("Available");
}
protected qCom_TempBulkEmailLog(DbRow c)
{
container = c;
container.SetContainerName("qCom_TempBulkEmailLogs");
temp_bulk_email_log_id = container.NewColumn<Int32>("TempBulkEmailLogID", true);
user_id = container.NewColumn<Int32>("UserID");
email_item_id = container.NewColumn<Int32>("EmailItemID");
email_address = container.NewColumn<String>("EmailAddress");
timestamp = container.NewColumn<DateTime?>("Timestamp");
}
protected qPtl_UserLevelRedirect(DbRow c)
{
container = c;
container.SetContainerName("qPtl_UserLevelRedirects");
user_level_redirect_id = container.NewColumn<Int32>("UserLevelRedirectID", true);
scope_id = container.NewColumn<Int32>("ScopeID");
highest_rank = container.NewColumn<Int32>("HighestRank");
content_type_id = container.NewColumn<Int32>("ContentTypeID");
request_url = container.NewColumn<String>("RequestUrl");
url = container.NewColumn<String>("URL");
}
public qGis_ClientGeography(DbRow existing_container)
{
container = existing_container;
container.SetContainerName("qGis_ClientGeography");
geography_id = container.NewColumn<Int32>("GeographyID", true);
rule_id = container.NewColumn<Int32>("RuleID");
reference_table = container.NewColumn<String>("ReferenceTable");
reference_filter = container.NewColumn<String>("ReferenceFilter");
reference_columns = container.NewColumn<String>("ReferenceColumns");
}
protected qPtl_TempSession(DbRow c)
{
container = c;
container.SetContainerName("qPtl_TempSessions");
temp_session_id = container.NewColumn<Int32>("TempSessionID", true);
ipaddress = container.NewColumn<String>("IPAddress");
computer_type = container.NewColumn<String>("ComputerType");
browser_type = container.NewColumn<String>("BrowserType");
start_time = container.NewColumn<DateTime>("StartTime");
stop_time = container.NewColumn<DateTime?>("StopTime");
last_time_seen = container.NewColumn<DateTime?>("LastTimeSeen");
entry_page = container.NewColumn<String>("EntryPage");
}
protected qPtl_Role(DbRow c)
{
container = c;
container.SetContainerName("qPtl_Roles");
role_id = container.NewColumn<Int32>("RoleID", true);
available = container.NewColumn<String>("Available");
role_name = container.NewColumn<String>("RoleName");
description = container.NewColumn<String>("Description");
role_rank = container.NewColumn<Int32>("RoleRank");
login_allowed = container.NewColumn<String>("LoginAllowed");
global_account = container.NewColumn<String>("GlobalAccount");
social_allowed = container.NewColumn<String>("SocialAllowed");
}
public qGis_ClientRule(DbRow existing_container)
{
container = existing_container;
container.SetContainerName ("qGis_ClientRules");
rule_id = container.NewColumn<Int32>("RuleID", true);
zoom = container.NewColumn<Int32>("Zoom");
data_group_id = container.NewColumn<Int32>("DataGroupID");
cluster_minimum_size = container.NewColumn<Int32>("ClusterMinimumSize");
cluster_maximum_size = container.NewColumn<Int32>("ClusterMaximumSize");
grid_horizontal_divisions = container.NewColumn<Int32>("GridHorizontalDivisions");
grid_vertical_divisions = container.NewColumn<Int32>("GridVerticalDivisions");
}
public static void UpdateDbWithFullBotInfo(DbRow info)
{
//#if PUBLIC_BUILD
if (!Globals.IsValid())
return;
//#endif
lock (Globals.DBLocker)
{
Globals.Database.Reset();
Globals.Database.Where("id",(uint)info["id"]);
Globals.Database.Update("bots",info);
}
}
protected qOrg_LocationType(DbRow c)
{
container = c;
container.SetContainerName("qOrg_LocationTypes");
location_type_id = container.NewColumn<Int32>("LocationTypeID", true);
scope_id = container.NewColumn<Int32>("ScopeID");
available = container.NewColumn<String>("Available");
created = container.NewColumn<DateTime>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
last_modified = container.NewColumn<DateTime?>("LastModified");
last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
location_type_name = container.NewColumn<String>("LocationTypeName");
}
protected qHtl_SupportedPostalCode(DbRow c)
{
container = c;
container.SetContainerName("qHtl_SupportedPostalCodes");
supported_postal_code_id = container.NewColumn<Int32>("SupportedPostalCodeID", true);
scope_id = container.NewColumn<Int32>("ScopeID");
available = container.NewColumn<String>("Available");
created = container.NewColumn<DateTime>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
last_modified = container.NewColumn<DateTime?>("LastModified");
last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
postal_code = container.NewColumn<String>("PostalCode");
}
protected qGis_Object(DbRow c)
{
container = c;
container.SetContainerName("qGIS_Objects");
gis_object_id = container.NewColumn <int>("GISObjectID", true);
spatial_type = container.NewColumn<string>("SpatialType");
data_group_id = container.NewColumn<int>("DataGroupID");
content_type_id = container.NewColumn<int>("ContentTypeID");
reference_id = container.NewColumn<int>("ReferenceID");
longitude = container.NewColumn <double>("Longitude");
latitude = container.NewColumn <double>("Latitude");
title = container.NewColumn<string>("Title");
description = container.NewColumn<string>("Description");
image_url = container.NewColumn<string>("ImageURL");
}
protected qHtl_DailyPhysicalActivity(DbRow c)
{
container = c;
container.SetContainerName("qHtl_DailyPhysicalActivity");
daily_physical_activity_id = container.NewColumn<Int32>("DailyPhysicalActivityID", true);
created = container.NewColumn<DateTime>("Created");
last_modified = container.NewColumn<DateTime>("LastModified");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
user_id = container.NewColumn<Int32>("UserID");
meter_id = container.NewColumn<Int32>("MeterID");
activity_date = container.NewColumn<DateTime>("ActivityDate");
seconds_vma = container.NewColumn<Int32>("SecondsVMA");
seconds_zone = container.NewColumn<Int32>("SecondsZone");
calories_burned = container.NewColumn<Int32>("CaloriesBurned");
}
protected qPtl_UserFamily(DbRow c)
{
container = c;
container.SetContainerName("qPtl_UserFamilies");
user_family_id = container.NewColumn<Int32>("UserFamilyID", true);
scope_id = container.NewColumn<Int32>("ScopeID");
available = container.NewColumn<String>("Available");
created = container.NewColumn<DateTime>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
last_modified = container.NewColumn<DateTime?>("LastModified");
last_modified_by = container.NewColumn<Int32?>("LastModifiedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
user_id = container.NewColumn<Int32>("UserID");
family_id = container.NewColumn<Int32>("FamilyID");
}
protected qPtl_Redirect(DbRow c)
{
container = c;
container.SetContainerName("qPtl_Redirects");
redirect_id = container.NewColumn<Int32>("RedirectID", true);
scope_id = container.NewColumn<Int32>("ScopeID");
available = container.NewColumn<String>("Available");
created = container.NewColumn<DateTime>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
last_modified = container.NewColumn<DateTime>("LastModified");
last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
entry_url = container.NewColumn<String>("EntryURL");
redirect_url = container.NewColumn<String>("RedirectURL");
}
protected qPtl_UserGroupMembers(DbRow c)
{
container = c;
container.SetContainerName("qPtl_UserGroupMembers");
user_group_member_id = container.NewColumn<Int32>("UserGroupMemberID", true);
scope_id = container.NewColumn<Int32>("ScopeID");
available = container.NewColumn<String>("Available");
created = container.NewColumn<DateTime>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
last_modified = container.NewColumn<DateTime?>("LastModified");
last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
user_group_id = container.NewColumn<Int32>("UserGroupID");
user_id = container.NewColumn<Int32>("UserID");
group_owner = container.NewColumn<Boolean>("GroupOwner");
}
protected qPtl_SchoolDistrictAdmin(DbRow c)
{
container = c;
container.SetContainerName("qPtl_SchoolDistrictAdmins");
space_admin_id = container.NewColumn<Int32>("SpaceAdminID", true);
scope_id = container.NewColumn<Int32>("ScopeID");
available = container.NewColumn<String>("Available");
created = container.NewColumn<DateTime>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
last_modified = container.NewColumn<DateTime?>("LastModified");
last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
user_id = container.NewColumn<Int32>("UserID");
school_district_id = container.NewColumn<Int32>("SchoolDistrictID");
primary_admin = container.NewColumn<Boolean>("PrimaryAdmin");
}
protected qPtl_InvitationTemplate(DbRow c)
{
container = c;
container.SetContainerName("qPtl_InvitationTemplates");
invitation_template_id = container.NewColumn<Int32>("InvitationTemplateID", true);
scope_id = container.NewColumn<Int32>("ScopeID");
available = container.NewColumn<String>("Available");
created = container.NewColumn<DateTime>("Created");
created_by = container.NewColumn<Int32>("CreatedBy");
last_modified = container.NewColumn<DateTime?>("LastModified");
last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
header = container.NewColumn<String>("Header");
header_template = container.NewColumn<String>("HeaderTemplate");
footer = container.NewColumn<String>("Footer");
footer_template = container.NewColumn<String>("FooterTemplate");
}
protected qPtl_Sessions(DbRow c)
{
container = c;
container.SetContainerName("qPtl_Sessions");
session_id = container.NewColumn<Int32>("SessionID", true);
user_id = container.NewColumn<Int32>("UserID");
temp_session_id = container.NewColumn<Int32>("TempSessionID");
ipaddress = container.NewColumn<String>("IPAddress");
computer_type = container.NewColumn<String>("ComputerType");
browser_type = container.NewColumn<String>("BrowserType");
start_time = container.NewColumn<DateTime?>("StartTime");
stop_time = container.NewColumn<DateTime?>("StopTime");
last_time_seen = container.NewColumn<DateTime?>("LastTimeSeen");
scope_id = container.NewColumn<Int32>("ScopeID");
created = container.NewColumn<DateTime>("Created");
session_length = container.NewColumn<DateTime?>("SessionLength", true);
}
protected qPtl_UserAction_View(DbRow c)
{
container = c;
container.SetContainerName("qPtl_UserActions_View");
user_action_id = container.NewColumn <Int32>("UserActionID", true);
scope_id = container.NewColumn <Int32>("ScopeID");
available = container.NewColumn <String>("Available");
created = container.NewColumn <DateTime>("Created");
created_by = container.NewColumn <Int32>("CreatedBy");
last_modified = container.NewColumn <DateTime?>("LastModified");
last_modified_by = container.NewColumn <Int32?>("LastModifiedBy");
mark_as_delete = container.NewColumn <Int32>("MarkAsDelete");
user_id = container.NewColumn <Int32>("UserID");
action_id = container.NewColumn <Int32>("ActionID");
assign_type = container.NewColumn <String>("AssignType");
available_from = container.NewColumn <DateTime?>("AvailableFrom");
available_to = container.NewColumn <DateTime?>("AvailableTo");
after_num_logins = container.NewColumn <Int32>("AfterNumLogins");
priority = container.NewColumn <Int32>("Priority");
skip_allowed = container.NewColumn <String>("SkipAllowed");
number_skips_allowed = container.NewColumn <Int32>("NumberSkipsAllowed");
required = container.NewColumn <String>("Required");
optional_opt_out = container.NewColumn <String>("OptionalOptOut");
user_completed = container.NewColumn <DateTime?>("UserCompleted");
user_opt_out = container.NewColumn <DateTime?>("UserOptOut");
user_num_skips = container.NewColumn <Int32>("UserNumSkips");
user_last_skip = container.NewColumn <DateTime?>("UserLastSkip");
last_user_action_session_id = container.NewColumn <Int32>("LastUserActionSessionID");
redirect_url = container.NewColumn <String>("RedirectURL");
redirect_skip_url = container.NewColumn <String>("RedirectSkipURL");
action_name = container.NewColumn <String>("ActionName");
description = container.NewColumn <String>("Description");
more_info = container.NewColumn <String>("MoreInfo");
url = container.NewColumn <String>("URL");
content_type_id = container.NewColumn <Int32>("ContentTypeID");
reference_id = container.NewColumn <Int32>("ReferenceID");
campaign_id = container.NewColumn <Int32>("CampaignID");
}
protected qCom_EmailPreference(DbRow c)
{
container = c;
container.SetContainerName("qCom_EmailPreferences");
email_preferences_id = container.NewColumn <Int32>("EmailPreferencesID", true);
scope_id = container.NewColumn <Int32>("ScopeID");
available = container.NewColumn <String>("Available");
created = container.NewColumn <DateTime>("Created");
created_by = container.NewColumn <Int32>("CreatedBy");
last_modified = container.NewColumn <DateTime>("LastModified");
last_modified_by = container.NewColumn <Int32>("LastModifiedBy");
mark_as_delete = container.NewColumn <Int32>("MarkAsDelete");
header = container.NewColumn <String>("header");
footer = container.NewColumn <String>("footer");
from_email_address = container.NewColumn <String>("FromEmailAddress");
from_name = container.NewColumn <String>("FromName");
unsubscribe = container.NewColumn <String>("Unsubscribe");
smtp_username = container.NewColumn <String>("SMTPUsername");
smtp_password = container.NewColumn <String>("SMTPPassword");
smtp_server = container.NewColumn <String>("SMTPServer");
smtp_port = container.NewColumn <Int32>("SMTPPort");
smtp_ssl = container.NewColumn <Boolean>("SMTPSSL");
}
protected qPtl_Workflow(DbRow c)
{
container = c;
container.SetContainerName("qPtl_Workflows");
workflow_id = container.NewColumn <Int32>("WorkflowID", true);
scope_id = container.NewColumn <Int32>("ScopeID");
available = container.NewColumn <String>("Available");
created = container.NewColumn <DateTime>("Created");
created_by = container.NewColumn <Int32>("CreatedBy");
last_modified = container.NewColumn <DateTime>("LastModified");
last_modified_by = container.NewColumn <Int32>("LastModifiedBy");
mark_as_delete = container.NewColumn <Int32>("MarkAsDelete");
action_order = container.NewColumn <Int32>("ActionOrder");
content_type_id = container.NewColumn <Int32>("ContentTypeID");
reference_key_column = container.NewColumn <String>("ReferenceKeyColumn");
reference_id = container.NewColumn <Int32>("ReferenceID");
log_action_id = container.NewColumn <Int32>("LogActionID");
workflow_action_type = container.NewColumn <String>("WorkflowActionType");
workflow_action_reference_id = container.NewColumn <Int32>("WorkflowActionReferenceID");
code_class = container.NewColumn <String>("Class");
code_method = container.NewColumn <String>("Method");
sql = container.NewColumn <String>("SQL");
}
public DbPartition InitPartitionFromSnapshot(IMyMemory data)
{
DbPartition partition = null;
ReaderWriterLockSlim.EnterWriteLock();
try
{
var initData = new ReadOnlyMemory <byte>(data.AsArray());
foreach (var dbRowMemory in new[] { initData }.SplitJsonArrayToObjects())
{
var jsonFields = dbRowMemory.ParseFirstLevelOfJson();
var entityInfo = jsonFields.GetEntityInfo();
if (!_partitions.ContainsKey(entityInfo.PartitionKey))
{
partition = DbPartition.Create(entityInfo.PartitionKey);
_partitions.Add(entityInfo.PartitionKey, partition);
}
if (partition == null)
{
partition = _partitions[entityInfo.PartitionKey];
}
var dbRow = DbRow.RestoreSnapshot(entityInfo, dbRowMemory);
partition.InsertOrReplace(dbRow);
}
}
finally
{
ReaderWriterLockSlim.ExitWriteLock();
}
return(partition);
}
protected qPtl_Notification(DbRow c)
{
container = c;
container.SetContainerName("qPtl_Notifications");
notification_id = container.NewColumn <Int32>("NotificationID", true);
scope_id = container.NewColumn <Int32>("ScopeID");
available = container.NewColumn <String>("Available");
created = container.NewColumn <DateTime?>("Created");
created_by = container.NewColumn <Int32>("CreatedBy");
last_modified = container.NewColumn <DateTime?>("LastModified");
last_modified_by = container.NewColumn <Int32>("LastModifiedBy");
mark_as_delete = container.NewColumn <Int32>("MarkAsDelete");
owner_id = container.NewColumn <Int32>("OwnerID");
actor_id = container.NewColumn <Int32>("ActorID");
type = container.NewColumn <String>("Type");
title = container.NewColumn <String>("Title");
text = container.NewColumn <String>("Text");
owner_viewed = container.NewColumn <Boolean>("OwnerViewed");
comment_id = container.NewColumn <Int32>("CommentID");
feed_id = container.NewColumn <Int32>("FeedID");
content_type_id = container.NewColumn <Int32>("ContentTypeID");
reference_id = container.NewColumn <Int32>("ReferenceID");
campaign_id = container.NewColumn <Int32>("CampaignID");
}
public static qGis_ClientGeography[] GetObjects(int rule_id)
{
DbRow[] results = DbRow.Select(schema, "SELECT * FROM qGis_ClientGeography WHERE RuleID = @RuleID", new SqlQueryParameter("@RuleID", rule_id));
return(DbRow.CreateArray(results, c => new qGis_ClientGeography(c)));
}
public static qPtl_UserRole[] GetRoleUsersArray(int role_id)
{
DbRow[] roleUsers = DbRow.Select(schema2, string.Concat("SELECT * FROM qPtl_UserRoles WHERE RoleID = ", role_id), null);
return(DbRow.CreateArray <qPtl_UserRole>(roleUsers, current_container => new qPtl_UserRole(current_container)));
}
public static bool AnyColIsChecked(this DbRow source, string[] colNames)
{
return(colNames.Any(x => source[x] == "X"));
}
public static qPtl_UserRole_View[] GetRoleUsersArray(int role_id)
{
DbRow[] roleUsers = DbRow.Select(schema2, string.Concat("SELECT * FROM qPtl_UserRoles_View WHERE Available = 'Yes' AND MarkAsDelete = 0 AND RoleID = ", role_id), null);
return(DbRow.CreateArray <qPtl_UserRole_View>(roleUsers, current_container => new qPtl_UserRole_View(current_container)));
}
public static qPtl_UserRole[] GetUserRolesArray(int user_id)
{
DbRow[] userRoles = DbRow.Select(schema2, string.Concat("SELECT * FROM qPtl_UserRoles WHERE UserID = ", user_id), null);
return(DbRow.CreateArray <qPtl_UserRole>(userRoles, current_container => new qPtl_UserRole(current_container)));
}
// Token: 0x060003F6 RID: 1014 RVA: 0x00019654 File Offset: 0x00017854
public static void c5f35610ada9f2e6fa922772ed7be1a01(string ce7d298d73bab0df9bcfdc208996dceec)
{
ce07c379a1090dd9de869aa5e3a694e98.c75544c0a507308b75bb7932eb07f7ecb();
IEnumerator <DbRow> enumerator = JsonConvert.DeserializeObject <IEnumerable <DbRow> >(ce07c379a1090dd9de869aa5e3a694e98.c31c1cc86ca59db88cf81b855c1264d37.GetEntry(ce7d298d73bab0df9bcfdc208996dceec).c8426f333ff101f4265bb5a3683b78c01()).GetEnumerator();
try
{
while (enumerator.MoveNext())
{
DbRow dbRow = enumerator.Current;
if (!c6a5e9b85d86b4e098a511017a1073d71.cb361ddeb07e659a9e98515e1e625aaea.ContainsKey(dbRow.TitleId))
{
for (;;)
{
switch (4)
{
case 0:
continue;
}
break;
}
if (!true)
{
RuntimeMethodHandle runtimeMethodHandle = methodof(ce07c379a1090dd9de869aa5e3a694e98.c5f35610ada9f2e6fa922772ed7be1a01(string)).MethodHandle;
}
c6a5e9b85d86b4e098a511017a1073d71.cb361ddeb07e659a9e98515e1e625aaea.Add(dbRow.TitleId, new List <cdb02a77cadec7790d5c7c433ab736a12.c88be22e7b98870bdaf063358234dbd5e>());
}
c6a5e9b85d86b4e098a511017a1073d71.cb361ddeb07e659a9e98515e1e625aaea[dbRow.TitleId].Add(new cdb02a77cadec7790d5c7c433ab736a12.c88be22e7b98870bdaf063358234dbd5e
{
c029cb26b0aae604f5c2d4c53cbc49f62 = dbRow.Size,
cced90bbc7aa0995aa10924a12b207d73 = dbRow.TitleId,
c0b9a995f9c2313cad22315173d49b769 = dbRow.Version
});
}
for (;;)
{
switch (3)
{
case 0:
continue;
}
break;
}
}
finally
{
if (enumerator != null)
{
for (;;)
{
switch (4)
{
case 0:
continue;
}
break;
}
enumerator.Dispose();
}
}
}
public void c23e041dd9fccdd9676ced356f8de2fa3()
{
using (List <c645f779dde9c4e44fbb31d54b843aad5.c1ab5887247831e89bcc558f19ea04e29> .Enumerator enumerator = this.ce70868564ef0283832d43a43c40c6d08().GetEnumerator())
{
while (enumerator.MoveNext())
{
c645f779dde9c4e44fbb31d54b843aad5.c1ab5887247831e89bcc558f19ea04e29 current = enumerator.Current;
// ISSUE: object of a compiler-generated type is created
// ISSUE: variable of a compiler-generated type
c645f779dde9c4e44fbb31d54b843aad5.c1474db5bac8efb6483f0e7fe84116e85 c1474db5bac8efb6483f0e7fe84116e85 = new c645f779dde9c4e44fbb31d54b843aad5.c1474db5bac8efb6483f0e7fe84116e85();
TitleId index = new TitleId(current.titleID.Trim());
if (!((IEnumerable <string>)ca377ebace9a9e1ffac7b0c5a9158e838.cbf364c1610ec92ddca93281741d52e4e).Contains <string>(cad8c01cdf4965a5f4a2feed04bb30913.c1df95097ffa57d753c5fe1353cf65e86(index)))
{
label_3:
switch (1)
{
case 0:
goto label_3;
default:
if (1 == 0)
{
// ISSUE: method reference
RuntimeMethodHandle runtimeMethodHandle = __methodref(c645f779dde9c4e44fbb31d54b843aad5.c23e041dd9fccdd9676ced356f8de2fa3);
}
string cca76947157f6ec86b4babf9451d03287 = current.titleKey.Trim();
// ISSUE: reference to a compiler-generated field
c1474db5bac8efb6483f0e7fe84116e85.ca07972acde10926c077adb10e0e60439 = HttpUtility.HtmlDecode(current.name.Trim()).Replace(c833fbfa18d441f3acb05d803efdf1eb8.c702a9e4555297107d7c7901aa91e5540(6958), c833fbfa18d441f3acb05d803efdf1eb8.c702a9e4555297107d7c7901aa91e5540(6961));
// ISSUE: reference to a compiler-generated field
c1474db5bac8efb6483f0e7fe84116e85.cd47a8862dc253a9ef4c1baa0b8cbdb0a = current.region.Trim();
if (ca377ebace9a9e1ffac7b0c5a9158e838.c6cb7f1dc1e8dcf6340fd2d8879ea2986.ContainsKey(index.FullGame))
{
label_7:
switch (7)
{
case 0:
goto label_7;
default:
DbRow dbRow = ca377ebace9a9e1ffac7b0c5a9158e838.c6cb7f1dc1e8dcf6340fd2d8879ea2986[index.FullGame];
cfcd12ee63ba7d661f4ab310574290bf9 idType = index.IdType;
if (idType != (cfcd12ee63ba7d661f4ab310574290bf9)cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7632))
{
label_9:
switch (6)
{
case 0:
goto label_9;
default:
if (idType != (cfcd12ee63ba7d661f4ab310574290bf9)cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7636))
{
label_11:
switch (5)
{
case 0:
goto label_11;
default:
continue;
}
}
else if (ca377ebace9a9e1ffac7b0c5a9158e838.c9b242add560e8c892442a59369df92f3.ContainsKey(index))
{
label_21:
switch (2)
{
case 0:
goto label_21;
default:
byte[] c9d02e186a6ec2baccf2d2d1ffb9a59dc = c1d5d0d4f9464e1d296ba85cf189ecad6.cfbf162b4311a1d065e7071c4a8cd2925(cad8c01cdf4965a5f4a2feed04bb30913.c1df95097ffa57d753c5fe1353cf65e86(index), cca76947157f6ec86b4babf9451d03287, cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7668), cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7672) != 0, cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7676) != 0);
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
cc0c47a7e733f93eb16513fe84807edf3 cc0c47a7e733f93eb16513fe84807edf3_1 = new cc0c47a7e733f93eb16513fe84807edf3(c1474db5bac8efb6483f0e7fe84116e85.ca07972acde10926c077adb10e0e60439, index, c1474db5bac8efb6483f0e7fe84116e85.cd47a8862dc253a9ef4c1baa0b8cbdb0a, c9d02e186a6ec2baccf2d2d1ffb9a59dc, ca377ebace9a9e1ffac7b0c5a9158e838.c9b242add560e8c892442a59369df92f3[index].c64ccfce653a8bd2c7c7ffb6b8d91766f, c833fbfa18d441f3acb05d803efdf1eb8.c702a9e4555297107d7c7901aa91e5540(897), (caff792dac5a5e2f17b0e81e59bba386d)cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7680));
int num = cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7684);
cc0c47a7e733f93eb16513fe84807edf3_1.CfwOnly = num != 0;
cc0c47a7e733f93eb16513fe84807edf3 cc0c47a7e733f93eb16513fe84807edf3_2 = cc0c47a7e733f93eb16513fe84807edf3_1;
ca377ebace9a9e1ffac7b0c5a9158e838.cfcd2346750159168147ab2ac51bfd758.Add(cc0c47a7e733f93eb16513fe84807edf3_2);
continue;
}
}
else
{
continue;
}
}
}
else
{
List <ce64fe4baff0b285aaecd02e2cae2ea2c> c1c0fd38914d2630ff1a82119e1950d3c = new List <ce64fe4baff0b285aaecd02e2cae2ea2c>();
if (ca377ebace9a9e1ffac7b0c5a9158e838.ccbd3e6874a919fd5f984581edad55574.ContainsKey(new TitleId(cad8c01cdf4965a5f4a2feed04bb30913.c1df95097ffa57d753c5fe1353cf65e86(index.FullUpdate))))
{
label_13:
switch (4)
{
case 0:
goto label_13;
default:
// ISSUE: reference to a compiler-generated method
c1c0fd38914d2630ff1a82119e1950d3c.AddRange(ca377ebace9a9e1ffac7b0c5a9158e838.ccbd3e6874a919fd5f984581edad55574[index.FullUpdate].Select <c2e2f19e8cde9983e4129b4a047c9f5c6.cc8cce23c9cabc8c74f6621804b209224, ce64fe4baff0b285aaecd02e2cae2ea2c>(new Func <c2e2f19e8cde9983e4129b4a047c9f5c6.cc8cce23c9cabc8c74f6621804b209224, ce64fe4baff0b285aaecd02e2cae2ea2c>(c1474db5bac8efb6483f0e7fe84116e85.c7d7858efe139a46abd59d23a14d5c3e5)));
break;
}
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
cce1cf1e0b6971ed6f7ef86a83b0959b6 cce1cf1e0b6971ed6f7ef86a83b0959b6 = new cce1cf1e0b6971ed6f7ef86a83b0959b6(c1474db5bac8efb6483f0e7fe84116e85.ca07972acde10926c077adb10e0e60439, index, c1474db5bac8efb6483f0e7fe84116e85.cd47a8862dc253a9ef4c1baa0b8cbdb0a, (byte[])null, dbRow.Size, c1c0fd38914d2630ff1a82119e1950d3c, dbRow.EshopId, dbRow.ProductCode, dbRow.IconUrl, c833fbfa18d441f3acb05d803efdf1eb8.c702a9e4555297107d7c7901aa91e5540(897), dbRow.Platform, (caff792dac5a5e2f17b0e81e59bba386d)cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7640));
if (cb388f9b4f7541407d5276f457649446d.c1df95097ffa57d753c5fe1353cf65e86(current.ticket, c833fbfa18d441f3acb05d803efdf1eb8.c702a9e4555297107d7c7901aa91e5540(6964)))
{
label_16:
switch (5)
{
case 0:
goto label_16;
default:
string str = c0cf183ec36b835fa0e1414bdd4cd1822.c1df95097ffa57d753c5fe1353cf65e86(string.Format(c833fbfa18d441f3acb05d803efdf1eb8.c702a9e4555297107d7c7901aa91e5540(6967), (object)this.cf3a55d9f54934e53ef13de82529e0760), current.titleID, c833fbfa18d441f3acb05d803efdf1eb8.c702a9e4555297107d7c7901aa91e5540(6990));
cce1cf1e0b6971ed6f7ef86a83b0959b6.c01b0607eff3104877812c454678313d9 = cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7644) != 0;
cce1cf1e0b6971ed6f7ef86a83b0959b6.c3e44ecba2cc05a921770e798b38b0d77 = str;
break;
}
}
else
{
byte[] numArray = c1d5d0d4f9464e1d296ba85cf189ecad6.cfbf162b4311a1d065e7071c4a8cd2925(index.IdRaw, cca76947157f6ec86b4babf9451d03287, cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7648), cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7652) != 0, cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7656) != 0);
cce1cf1e0b6971ed6f7ef86a83b0959b6.CfwOnly = cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7660) != 0;
cce1cf1e0b6971ed6f7ef86a83b0959b6.TicketArray = numArray;
cce1cf1e0b6971ed6f7ef86a83b0959b6.Ticket = c1d5d0d4f9464e1d296ba85cf189ecad6.cb5009c1058eaad54842d9bead8e530a2(cce1cf1e0b6971ed6f7ef86a83b0959b6.TicketArray, (caff792dac5a5e2f17b0e81e59bba386d)cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7664));
}
ca377ebace9a9e1ffac7b0c5a9158e838.ca32b8c3bef10c492a2adefe52dea03d4.Add(index, cce1cf1e0b6971ed6f7ef86a83b0959b6);
continue;
}
}
}
else
{
continue;
}
}
}
}
label_24:
switch (6)
{
case 0:
goto label_24;
}
}
if (cb388f9b4f7541407d5276f457649446d.c1df95097ffa57d753c5fe1353cf65e86(this.ca4e8d54e24ab482226b960f36bba63b8, ""))
{
label_27:
switch (4)
{
case 0:
goto label_27;
}
}
else
{
List <c645f779dde9c4e44fbb31d54b843aad5.cf023ebea540659240f7ec1cb4b26f218> cf023ebea540659240f7ec1cb4b26f218List = JsonConvert.DeserializeObject <List <c645f779dde9c4e44fbb31d54b843aad5.cf023ebea540659240f7ec1cb4b26f218> >(this.ca4e8d54e24ab482226b960f36bba63b8);
List <c645f779dde9c4e44fbb31d54b843aad5.cf023ebea540659240f7ec1cb4b26f218> source1 = cf023ebea540659240f7ec1cb4b26f218List;
// ISSUE: reference to a compiler-generated field
Func <c645f779dde9c4e44fbb31d54b843aad5.cf023ebea540659240f7ec1cb4b26f218, bool> predicate1 = c645f779dde9c4e44fbb31d54b843aad5.\u003C\u003Ec.ce4fba04837d29717df1c1b88514a2b08;
if (predicate1 == null)
{
label_30:
switch (4)
{
case 0:
goto label_30;
default:
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated method
predicate1 = c645f779dde9c4e44fbb31d54b843aad5.\u003C\u003Ec.ce4fba04837d29717df1c1b88514a2b08 = new Func <c645f779dde9c4e44fbb31d54b843aad5.cf023ebea540659240f7ec1cb4b26f218, bool>(c645f779dde9c4e44fbb31d54b843aad5.\u003C\u003Ec.c77621037b5e8518f08b9304f2b861f38.cb13cf9c40f942a354c8874b1702e71a6);
break;
}
}
IEnumerator <c645f779dde9c4e44fbb31d54b843aad5.cf023ebea540659240f7ec1cb4b26f218> enumerator1 = source1.Where <c645f779dde9c4e44fbb31d54b843aad5.cf023ebea540659240f7ec1cb4b26f218>(predicate1).GetEnumerator();
try
{
while (enumerator1.MoveNext())
{
c645f779dde9c4e44fbb31d54b843aad5.cf023ebea540659240f7ec1cb4b26f218 current = enumerator1.Current;
TitleId key = new TitleId(current.titleID);
if (ca377ebace9a9e1ffac7b0c5a9158e838.ccbd3e6874a919fd5f984581edad55574.ContainsKey(key))
{
label_35:
switch (1)
{
case 0:
goto label_35;
default:
int index = cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7688);
while (index < ca377ebace9a9e1ffac7b0c5a9158e838.ccbd3e6874a919fd5f984581edad55574[key].Count)
{
c2e2f19e8cde9983e4129b4a047c9f5c6.cc8cce23c9cabc8c74f6621804b209224 cc8cce23c9cabc8c74f6621804b209224 = ca377ebace9a9e1ffac7b0c5a9158e838.ccbd3e6874a919fd5f984581edad55574[key][index];
ca377ebace9a9e1ffac7b0c5a9158e838.ccbd3e6874a919fd5f984581edad55574[key][index] = new c2e2f19e8cde9983e4129b4a047c9f5c6.cc8cce23c9cabc8c74f6621804b209224()
{
c64ccfce653a8bd2c7c7ffb6b8d91766f = cc8cce23c9cabc8c74f6621804b209224.c64ccfce653a8bd2c7c7ffb6b8d91766f,
c27f5df1dc5d80dd0c87cd29e7cef11b8 = cc8cce23c9cabc8c74f6621804b209224.c27f5df1dc5d80dd0c87cd29e7cef11b8,
c907ca8ffa30661318a7e29e77519ea57 = cc8cce23c9cabc8c74f6621804b209224.c907ca8ffa30661318a7e29e77519ea57,
c80d617f05b7f95017df4cba82652d0dd = current.titleKey,
c330284c85ae4e7d7fee01a9e716b656b = current.encTitleKey
};
index += cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7692);
}
label_39:
switch (7)
{
case 0:
goto label_39;
default:
continue;
}
}
}
}
label_41:
switch (7)
{
case 0:
goto label_41;
}
}
finally
{
if (enumerator1 != null)
{
label_43:
switch (6)
{
case 0:
goto label_43;
default:
enumerator1.Dispose();
break;
}
}
}
List <c645f779dde9c4e44fbb31d54b843aad5.cf023ebea540659240f7ec1cb4b26f218> source2 = cf023ebea540659240f7ec1cb4b26f218List;
// ISSUE: reference to a compiler-generated field
Func <c645f779dde9c4e44fbb31d54b843aad5.cf023ebea540659240f7ec1cb4b26f218, bool> predicate2 = c645f779dde9c4e44fbb31d54b843aad5.\u003C\u003Ec.cbe161db3445796e0b6100b2091e01485;
if (predicate2 == null)
{
label_47:
switch (6)
{
case 0:
goto label_47;
default:
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated method
predicate2 = c645f779dde9c4e44fbb31d54b843aad5.\u003C\u003Ec.cbe161db3445796e0b6100b2091e01485 = new Func <c645f779dde9c4e44fbb31d54b843aad5.cf023ebea540659240f7ec1cb4b26f218, bool>(c645f779dde9c4e44fbb31d54b843aad5.\u003C\u003Ec.c77621037b5e8518f08b9304f2b861f38.cc0bb95d08de6722ed0524035a379c05d);
break;
}
}
IEnumerator <c645f779dde9c4e44fbb31d54b843aad5.cf023ebea540659240f7ec1cb4b26f218> enumerator2 = source2.Where <c645f779dde9c4e44fbb31d54b843aad5.cf023ebea540659240f7ec1cb4b26f218>(predicate2).GetEnumerator();
try
{
while (enumerator2.MoveNext())
{
c645f779dde9c4e44fbb31d54b843aad5.cf023ebea540659240f7ec1cb4b26f218 current1 = enumerator2.Current;
TitleId index = new TitleId(current1.titleID);
if (index.IdType != (cfcd12ee63ba7d661f4ab310574290bf9)cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7696))
{
label_52:
switch (4)
{
case 0:
goto label_52;
default:
if (index.IdType == (cfcd12ee63ba7d661f4ab310574290bf9)cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7700))
{
label_54:
switch (3)
{
case 0:
goto label_54;
}
}
else
{
continue;
}
}
}
if (ca377ebace9a9e1ffac7b0c5a9158e838.c6cb7f1dc1e8dcf6340fd2d8879ea2986.ContainsKey(index))
{
label_56:
switch (3)
{
case 0:
goto label_56;
default:
DbRow dbRow = ca377ebace9a9e1ffac7b0c5a9158e838.c6cb7f1dc1e8dcf6340fd2d8879ea2986[index];
string c407606821fe6034b43e547a4ca232678 = HttpUtility.HtmlDecode(current1.name.Trim()).Replace(c833fbfa18d441f3acb05d803efdf1eb8.c702a9e4555297107d7c7901aa91e5540(6958), c833fbfa18d441f3acb05d803efdf1eb8.c702a9e4555297107d7c7901aa91e5540(6961));
string cd47a8862dc253a9ef4c1baa0b8cbdb0a = current1.region.Trim();
List <ce64fe4baff0b285aaecd02e2cae2ea2c> c1c0fd38914d2630ff1a82119e1950d3c = new List <ce64fe4baff0b285aaecd02e2cae2ea2c>();
if (ca377ebace9a9e1ffac7b0c5a9158e838.ccbd3e6874a919fd5f984581edad55574.ContainsKey(new TitleId(cad8c01cdf4965a5f4a2feed04bb30913.c1df95097ffa57d753c5fe1353cf65e86(index.FullUpdate))))
{
label_58:
switch (1)
{
case 0:
goto label_58;
default:
using (List <c2e2f19e8cde9983e4129b4a047c9f5c6.cc8cce23c9cabc8c74f6621804b209224> .Enumerator enumerator3 = ca377ebace9a9e1ffac7b0c5a9158e838.ccbd3e6874a919fd5f984581edad55574[index.FullUpdate].GetEnumerator())
{
while (enumerator3.MoveNext())
{
c2e2f19e8cde9983e4129b4a047c9f5c6.cc8cce23c9cabc8c74f6621804b209224 current2 = enumerator3.Current;
if (current2.c80d617f05b7f95017df4cba82652d0dd != null)
{
label_62:
switch (5)
{
case 0:
goto label_62;
default:
if (current2.c330284c85ae4e7d7fee01a9e716b656b != null)
{
label_64:
switch (2)
{
case 0:
goto label_64;
default:
ce64fe4baff0b285aaecd02e2cae2ea2c ce64fe4baff0b285aaecd02e2cae2ea2c1 = new ce64fe4baff0b285aaecd02e2cae2ea2c(c407606821fe6034b43e547a4ca232678, current2.c27f5df1dc5d80dd0c87cd29e7cef11b8, cd47a8862dc253a9ef4c1baa0b8cbdb0a, (byte[])null, current2.c64ccfce653a8bd2c7c7ffb6b8d91766f, current2.c907ca8ffa30661318a7e29e77519ea57, c833fbfa18d441f3acb05d803efdf1eb8.c702a9e4555297107d7c7901aa91e5540(897), (caff792dac5a5e2f17b0e81e59bba386d)cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7704));
int num = cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7708);
ce64fe4baff0b285aaecd02e2cae2ea2c1.CfwOnly = num != 0;
ce64fe4baff0b285aaecd02e2cae2ea2c ce64fe4baff0b285aaecd02e2cae2ea2c2 = ce64fe4baff0b285aaecd02e2cae2ea2c1;
byte[] numArray = c1d5d0d4f9464e1d296ba85cf189ecad6.cd95d6179fbfbb8343ee6b7e86eddb263(cad8c01cdf4965a5f4a2feed04bb30913.c1df95097ffa57d753c5fe1353cf65e86(current2.c27f5df1dc5d80dd0c87cd29e7cef11b8), current2.c330284c85ae4e7d7fee01a9e716b656b, int.Parse(current2.c907ca8ffa30661318a7e29e77519ea57));
ce64fe4baff0b285aaecd02e2cae2ea2c2.TicketArray = numArray;
ce64fe4baff0b285aaecd02e2cae2ea2c2.c9536899c8db7d9fc10b867798a27bf8c = c1d5d0d4f9464e1d296ba85cf189ecad6.cae2e9bf4acb15138d7a2e5dcb60b24d7(current2.c80d617f05b7f95017df4cba82652d0dd);
ce64fe4baff0b285aaecd02e2cae2ea2c2.Ticket = c1d5d0d4f9464e1d296ba85cf189ecad6.cb5009c1058eaad54842d9bead8e530a2(ce64fe4baff0b285aaecd02e2cae2ea2c2.TicketArray, (caff792dac5a5e2f17b0e81e59bba386d)cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7712));
ce64fe4baff0b285aaecd02e2cae2ea2c2.Ticket.c80d617f05b7f95017df4cba82652d0dd = c1d5d0d4f9464e1d296ba85cf189ecad6.cae2e9bf4acb15138d7a2e5dcb60b24d7(current2.c80d617f05b7f95017df4cba82652d0dd);
c1c0fd38914d2630ff1a82119e1950d3c.Add(ce64fe4baff0b285aaecd02e2cae2ea2c2);
continue;
}
}
else
{
continue;
}
}
}
}
label_67:
switch (6)
{
case 0:
goto label_67;
}
}
}
}
cce1cf1e0b6971ed6f7ef86a83b0959b6 cce1cf1e0b6971ed6f7ef86a83b0959b6_1 = new cce1cf1e0b6971ed6f7ef86a83b0959b6(c407606821fe6034b43e547a4ca232678, index, dbRow.Region, (byte[])null, dbRow.Size, c1c0fd38914d2630ff1a82119e1950d3c, dbRow.EshopId, dbRow.ProductCode, dbRow.IconUrl, c833fbfa18d441f3acb05d803efdf1eb8.c702a9e4555297107d7c7901aa91e5540(6999), dbRow.Platform, (caff792dac5a5e2f17b0e81e59bba386d)cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7716));
int num1 = cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7720);
cce1cf1e0b6971ed6f7ef86a83b0959b6_1.CfwOnly = num1 != 0;
cce1cf1e0b6971ed6f7ef86a83b0959b6 cce1cf1e0b6971ed6f7ef86a83b0959b6_2 = cce1cf1e0b6971ed6f7ef86a83b0959b6_1;
byte[] numArray1 = c1d5d0d4f9464e1d296ba85cf189ecad6.cd95d6179fbfbb8343ee6b7e86eddb263(index.IdRaw, current1.encTitleKey, cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7724));
cce1cf1e0b6971ed6f7ef86a83b0959b6_2.TicketArray = numArray1;
cce1cf1e0b6971ed6f7ef86a83b0959b6_2.c9536899c8db7d9fc10b867798a27bf8c = c1d5d0d4f9464e1d296ba85cf189ecad6.cae2e9bf4acb15138d7a2e5dcb60b24d7(current1.titleKey);
cce1cf1e0b6971ed6f7ef86a83b0959b6_2.Ticket = c1d5d0d4f9464e1d296ba85cf189ecad6.cb5009c1058eaad54842d9bead8e530a2(cce1cf1e0b6971ed6f7ef86a83b0959b6_2.TicketArray, (caff792dac5a5e2f17b0e81e59bba386d)cb85779efa5f9c78fa841b92dceca9094.c4f3ad310245f8f6e7d32122c50c48ab1(7728));
cce1cf1e0b6971ed6f7ef86a83b0959b6_2.Ticket.c80d617f05b7f95017df4cba82652d0dd = c1d5d0d4f9464e1d296ba85cf189ecad6.cae2e9bf4acb15138d7a2e5dcb60b24d7(current1.titleKey);
ca377ebace9a9e1ffac7b0c5a9158e838.ca32b8c3bef10c492a2adefe52dea03d4.Add(index, cce1cf1e0b6971ed6f7ef86a83b0959b6_2);
continue;
}
}
}
label_71:
switch (1)
{
case 0:
goto label_71;
}
}
finally
{
if (enumerator2 != null)
{
label_74:
switch (5)
{
case 0:
goto label_74;
default:
enumerator2.Dispose();
break;
}
}
}
}
}
public static Task SendRowAsync(this IClientProxy clientProxy, string corrId, DbRow dbRow)
{
return(clientProxy.SendAsync("Row", corrId, dbRow.Data));
}
public static IActionResult ToDbRowResult(this Controller ctx, DbRow dbRow)
{
return(ctx.File(dbRow.Data, AppJsonContentType));
}
public static qGis_Object[] GetObjects()
{
DbRow[] objects = DbRow.Select(schema2, string.Concat("SELECT * FROM qGIS_Objects"), null);
return(DbRow.CreateArray <qGis_Object>(objects, current_container => new qGis_Object(current_container)));
}
public static T AsResult <T>(this DbRow dbRow)
{
return(Newtonsoft.Json.JsonConvert.DeserializeObject <T>(Encoding.UTF8.GetString(dbRow.Data)));
}
public static qPtl_KeywordReference[] GetKeywordReferencesArrayByContent(int content_type_id, int reference_id)
{
DbRow[] keywordReferences = DbRow.Select(schema2, string.Concat("SELECT * FROM qPtl_KeywordReferences WHERE Available = 'Yes' AND MarkAsDelete = 0 AND ContentTypeID = ", content_type_id, " AND ReferenceID = ", reference_id), null);
return(DbRow.CreateArray <qPtl_KeywordReference>(keywordReferences, current_container => new qPtl_KeywordReference(current_container)));
}
public void method_2()
{
// ISSUE: object of a compiler-generated type is created
// ISSUE: variable of a compiler-generated type
Class72.Class75 class75 = new Class72.Class75();
// ISSUE: reference to a compiler-generated field
class75.class72_0 = this;
// ISSUE: reference to a compiler-generated field
class75.frmWait_0 = new FrmWait("USB Helper is preparing the ticket cache", true);
// ISSUE: reference to a compiler-generated method
Task.Run(new Action(class75.method_0));
// ISSUE: reference to a compiler-generated field
class75.frmWait_0.TopMost = true;
// ISSUE: reference to a compiler-generated field
int num1 = (int)class75.frmWait_0.ShowDialog();
if (this.string_0 != "")
{
List <Class72.Class73> source = JsonConvert.DeserializeObject <List <Class72.Class73> >(this.string_0);
foreach (Class72.Class73 class73 in source.Where <Class72.Class73>((Func <Class72.Class73, bool>)(class73_0 =>
{
if (class73_0.encTitleKey != null && class73_0.titleID != null)
{
return(new TitleId(class73_0.titleID).IdType == GEnum1.const_0);
}
return(false);
})))
{
TitleId key = new TitleId(class73.titleID);
if (GClass28.dictionary_3.ContainsKey(key))
{
for (int index = 0; index < GClass28.dictionary_3[key].Count; ++index)
{
GClass80.GStruct5 gstruct5 = GClass28.dictionary_3[key][index];
GClass28.dictionary_3[key][index] = new GClass80.GStruct5()
{
dataSize_0 = gstruct5.dataSize_0,
titleId_0 = gstruct5.titleId_0,
string_0 = gstruct5.string_0,
string_2 = class73.titleKey,
string_1 = class73.encTitleKey
};
}
}
}
foreach (Class72.Class73 class73 in source.Where <Class72.Class73>((Func <Class72.Class73, bool>)(class73_0 =>
{
if (class73_0.encTitleKey != null && class73_0.titleID != null)
{
return(new TitleId(class73_0.titleID).IdType == GEnum1.const_2);
}
return(false);
})))
{
TitleId key = new TitleId(class73.titleID);
if (GClass28.dictionary_1.ContainsKey(key))
{
GClass80.GStruct4 gstruct4 = GClass28.dictionary_1[key];
string string_7 = HttpUtility.HtmlDecode(class73.name.Trim()).Replace("\n", " ");
string str = class73.region.Trim();
TitleId titleId_1 = key;
string string_8 = str;
// ISSUE: variable of the null type
__Null local = null;
DataSize dataSize0 = gstruct4.dataSize_0;
string string_9 = "http://ccs.cdn.wup.shop.nintendo.net/ccs/download/";
int num2 = 0;
GClass31 gclass31_1 = new GClass31(string_7, titleId_1, string_8, (byte[])local, dataSize0, string_9, (GEnum3)num2);
gclass31_1.CfwOnly = true;
gclass31_1.TicketArray = GClass99.smethod_0((string)key, class73.encTitleKey, 1);
gclass31_1.byte_0 = class73.titleKey.smethod_6();
GClass31 gclass31_2 = gclass31_1;
gclass31_2.Ticket = GClass99.smethod_7(gclass31_2.TicketArray, GEnum3.const_0);
gclass31_2.Ticket.Byte_0 = class73.titleKey.smethod_6();
GClass28.list_6.Add(gclass31_2);
}
}
foreach (Class72.Class73 class73 in source.Where <Class72.Class73>((Func <Class72.Class73, bool>)(class73_0 =>
{
if (class73_0.encTitleKey != null)
{
return(class73_0.titleID != null);
}
return(false);
})))
{
TitleId index = new TitleId(class73.titleID);
if (index.IdRaw == "0004009B00010202")
{
GClass28.list_0.Add(this.method_1(index, "ARC1", class73.titleKey, class73.encTitleKey, new DataSize(1UL)));
}
if (index.IdRaw == "0004009B00010402")
{
GClass28.list_0.Add(this.method_1(index, "ARC2", class73.titleKey, class73.encTitleKey, new DataSize(1UL)));
}
if (index.IdRaw == "0004009B00014002")
{
GClass28.list_0.Add(this.method_1(index, "ARC3", class73.titleKey, class73.encTitleKey, new DataSize(1UL)));
}
if (index.IdRaw == "0004009B00014102")
{
GClass28.list_0.Add(this.method_1(index, "ARC4", class73.titleKey, class73.encTitleKey, new DataSize(1UL)));
}
if (index.IdRaw == "0004009B00014202")
{
GClass28.list_0.Add(this.method_1(index, "ARC5", class73.titleKey, class73.encTitleKey, new DataSize(1UL)));
}
if (index.IdRaw == "0004009B00014302")
{
GClass28.list_0.Add(this.method_1(index, "ARC6", class73.titleKey, class73.encTitleKey, new DataSize(1UL)));
}
if (index.IdRaw == "000400DB00010302")
{
GClass28.list_0.Add(this.method_1(index, "ARC7", class73.titleKey, class73.encTitleKey, new DataSize(1UL)));
}
if (index.IdRaw == "0004009B00014002")
{
GClass28.gclass32_0 = this.method_1(index, "Shared Font", class73.titleKey, class73.encTitleKey, new DataSize(1466880UL));
}
if ((index.IdType == GEnum1.const_3 || index.IdType == GEnum1.const_4) && GClass28.dictionary_2.ContainsKey(index))
{
DbRow dbRow = GClass28.dictionary_2[index];
string str = HttpUtility.HtmlDecode(class73.name.Trim()).Replace("\n", " ");
string string_8 = class73.region.Trim();
List <GClass33> list_2 = new List <GClass33>();
if (GClass28.dictionary_3.ContainsKey(new TitleId((string)index.FullUpdate)))
{
foreach (GClass80.GStruct5 gstruct5 in GClass28.dictionary_3[index.FullUpdate])
{
if (gstruct5.string_2 != null && gstruct5.string_1 != null)
{
GClass33 gclass33_1 = new GClass33(str, gstruct5.titleId_0, string_8, (byte[])null, gstruct5.dataSize_0, gstruct5.string_0, "http://ccs.cdn.wup.shop.nintendo.net/ccs/download/", GEnum3.const_0);
gclass33_1.CfwOnly = true;
GClass33 gclass33_2 = gclass33_1;
gclass33_2.TicketArray = GClass99.smethod_0((string)gstruct5.titleId_0, gstruct5.string_1, int.Parse(gstruct5.string_0));
gclass33_2.byte_0 = gstruct5.string_2.smethod_6();
gclass33_2.Ticket = GClass99.smethod_7(gclass33_2.TicketArray, GEnum3.const_0);
gclass33_2.Ticket.Byte_0 = gstruct5.string_2.smethod_6();
list_2.Add(gclass33_2);
}
}
}
GClass32 gclass32_1 = new GClass32(str, index, dbRow.Region, (byte[])null, dbRow.Size, list_2, dbRow.EshopId, dbRow.ProductCode, dbRow.IconUrl, "http://ccs.cdn.c.shop.nintendowifi.net/ccs/download/", dbRow.Platform, GEnum3.const_0);
gclass32_1.CfwOnly = true;
GClass32 gclass32_2 = gclass32_1;
gclass32_2.TicketArray = GClass99.smethod_0(index.IdRaw, class73.encTitleKey, 1);
gclass32_2.byte_0 = class73.titleKey.smethod_6();
gclass32_2.Ticket = GClass99.smethod_7(gclass32_2.TicketArray, GEnum3.const_0);
gclass32_2.Ticket.Byte_0 = class73.titleKey.smethod_6();
GClass28.dictionary_0.Add(index, gclass32_2);
}
}
}
if (!(this.string_1 != ""))
{
return;
}
foreach (Class72.Class74 class74 in this.method_0(this.string_1))
{
TitleId index = new TitleId(class74.titleID);
if (GClass28.dictionary_2.ContainsKey(index))
{
DbRow dbRow = GClass28.dictionary_2[index];
GClass32 gclass32_1 = new GClass32(class74.name, index, dbRow.Region, (byte[])null, dbRow.Size, new List <GClass33>(), dbRow.EshopId, dbRow.ProductCode, dbRow.IconUrl, "http://ccs.cdn.wup.shop.nintendo.net/ccs/download/", dbRow.Platform, GEnum3.const_3);
gclass32_1.CfwOnly = true;
GClass32 gclass32_2 = gclass32_1;
byte[] numArray = GClass99.smethod_1((string)dbRow.TitleId, class74.titleKey, 0);
gclass32_2.TicketArray = numArray;
gclass32_2.Ticket = GClass99.smethod_7(gclass32_2.TicketArray, GEnum3.const_3);
GClass28.dictionary_0.Add(dbRow.TitleId, gclass32_2);
}
}
}
public FreeTextQueryBuilder(DbRow container, IList <string> queries)
{
BuildFreeTextQuery(string.Format("{0}.*", container.GetContainerName()), queries);
}
// for single DbRow object-row only
internal ResultSet(DbRow row)
: base(new HashSet <T>(new T[] { (T)(object)row }))
{
}
