TenantsArchive Class

Definition

Namespace: MbcsCentral.WinPM
Assembly: MbcsCentral (in MbcsCentral.exe) Version: 2.0.1.15 (2.0.1.15)
C#
public class TenantsArchive : clsDB, 
	INotifyPropertyChanged
Inheritance
Object    clsDB    TenantsArchive
Implements
INotifyPropertyChanged

Constructors

Properties

AdditionalName 
AdditionalNameFlag 
AddName 
AltBillAdd1 
AltBillAdd2 
AltBillAdd3 
AltBillName 
AlternateBillingAddressFlag 
Apartment 
Arrears 
Bank 
BuildingNumber 
BusPhone1 
BusPhone2 
Cell2 
ColumnCount Reports column count
(Inherited from clsDB)
Comment 
CommercialProfessional 
dhcrACOne 
dhcrACTwo 
dhcrDateOne 
dhcrDateTwo 
dhcrDishwasherOne 
dhcrDishwasherTwo 
dhcrOtherOne 
dhcrOtherTextOne 
dhcrOtherTextTwo 
dhcrOtherTwo 
dhcrRefrigeratorOne 
dhcrRefrigeratorTwo 
dhcrRentOne 
dhcrRentTwo 
dhcrStoveOne 
dhcrStoveTwo 
dhcrWindowsOne 
dhcrWindowsTwo 
DueDate 
Email1 
Email2 
ErrorMessage Used to retrieve internal error messages
(Inherited from clsDB)
Exempt421aIncome 
Exempt421aMarketRate 
Exempt421aMedianIncome 
ExemptCommercialProfessionalCo 
ExemptCoopCondoOwner 
ExemptDate 
ExemptExp421a 
ExemptExpSec608 
ExemptHighRentIncome 
ExemptHighRentVacancy 
ExemptHighRentVacanyPeriod 
ExemptLastLegalPaid 
ExemptOther 
ExemptOtherDesc 
ExemptSec11243 
ExemptSubstantialRehab 
FairMarketAppeal 
FutureDate1 
FutureDate2 
FutureDate3 
FutureLegal1 
FutureLegal2 
FutureLegal3 
FutureRent1 
FutureRent2 
FutureRent3 
HomePhone1 
HomePhone2 
InterestInfo 
isChanged Has record been modified?
IsDupe Set true when a duplicate record is found on insertion
(Inherited from clsDB)
Item Generic method for getting values of property by names. Useful when iterating through columns in a record
(Inherited from clsDB)
LastPaidDate 
LateBase 
LateFee 
LateFeeNo 
LateFeeYes 
LeaseExpirationDate 
LeaseLetterFlag 
LeaseStartDate 
LegalCode 
LegalCode2 
LegalFee 
LegalFeeNo 
LowRentFlag 
MBR 
MoveinDate 
NewOnly 
NewTenantFlag 
NotPrimeResidence 
OldHistoryFilePointer 
OptTenant1 
OptTenant2 
OwnerOccupied 
Pager 
Paid 
PromptPay1 
PromptPay2 
ProposedLegal 
ProposedLegal2 
ProposedRent 
ProposedRent2 
Rent 
RentLegal 
RentOvercharge 
ReplacingTenant 
Rooms 
SecMultiple 
SecondSuccession 
Security 
SecurityAccount 
SecurityBuilding 
Seniorcit 
SequenceNumber 
Shares 
SquareFeet 
SSNumber1 
SSNumber2 
Succeeded 
Temp1 
Temp2 
TempExemptOther 
TenantName 
TenantNumber 
TotalCharges 
TransientOccupant 
Type 
x421a 

Methods

Clone 
CreateTable 
delete Delete record
(Inherited from clsDB)
deleteTenantsByBuilding 
EqualsDetermines whether the specified object is equal to the current object.
(Inherited from Object)
fill 
fillShort 
FinalizeAllows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object)
GetColumn Finds if specified Column name is in table. Datarows must have already been fetched.
(Inherited from clsDB)
GetHashCodeServes as the default hash function.
(Inherited from Object)
GetTableSchema Gets a table schema
(Inherited from clsDB)
GetTypeGets the Type of the current instance.
(Inherited from Object)
insertRecord Inserts a new record using instantiated Insert statement
(Inherited from clsDB)
load(Int16) 
load(Int32) 
load(String, String) 
load(String, String, Boolean) Retrieve records from a table using the passes SQL string
(Inherited from clsDB)
loadAll(Boolean) Retrieve all records in a table
(Inherited from clsDB)
loadAll(Int64, Boolean) 
loadByPrimaryKey Load a record by Primary Key
(Inherited from clsDB)
loadForDeletion 
loadForNames 
MemberwiseCloneCreates a shallow copy of the current Object.
(Inherited from Object)
OnPropertyChanged 
query Execute custom query. Used mainly for special deletion scenarios
(Inherited from clsDB)
queryWithCount Custome query for getting record counts
(Inherited from clsDB)
save Save or Update a record
ToStringReturns a string that represents the current object.
(Inherited from Object)
updateRecord Updates records using update statement passed with child class instantiation
(Inherited from clsDB)
updateRecordSpecial Updates records using passed update statement
(Inherited from clsDB)

Events

Fields

connectionString
(Inherited from clsDB)
DataSetName
(Inherited from clsDB)
insertStmt
(Inherited from clsDB)
loadAllStmt
(Inherited from clsDB)
loadStmt
(Inherited from clsDB)
LoadStmt
(Inherited from clsDB)
localCN
(Inherited from clsDB)
localTable
(Inherited from clsDB)
m_421a 
m_AdditionalName 
m_AdditionalNameFlag 
m_AddName 
m_AltBillAdd1 
m_AltBillAdd2 
m_AltBillAdd3 
m_AltBillName 
m_AlternateBillingAddressFlag 
m_Apartment 
m_Arrears 
m_Bank 
m_BuildingNumber 
m_BusPhone1 
m_BusPhone2 
m_Cell2 
m_Comment 
m_CommercialProfessional 
m_dhcrACOne 
m_dhcrACTwo 
m_dhcrDateOne 
m_dhcrDateTwo 
m_dhcrDishwasherOne 
m_dhcrDishwasherTwo 
m_dhcrOtherOne 
m_dhcrOtherTextOne 
m_dhcrOtherTextTwo 
m_dhcrOtherTwo 
m_dhcrRefrigeratorOne 
m_dhcrRefrigeratorTwo 
m_dhcrRentOne 
m_dhcrRentTwo 
m_dhcrStoveOne 
m_dhcrStoveTwo 
m_dhcrWindowsOne 
m_dhcrWindowsTwo 
m_DueDate 
m_Email1 
m_Email2 
m_Exempt421aIncome 
m_Exempt421aMarketRate 
m_Exempt421aMedianIncome 
m_ExemptCommercialProfessionalCo 
m_ExemptCoopCondoOwner 
m_ExemptDate 
m_ExemptExp421a 
m_ExemptExpSec608 
m_ExemptHighRentIncome 
m_ExemptHighRentVacancy 
m_ExemptHighRentVacanyPeriod 
m_ExemptLastLegalPaid 
m_ExemptOther 
m_ExemptOtherDesc 
m_ExemptSec11243 
m_ExemptSubstantialRehab 
m_FairMarketAppeal 
m_FutureDate1 
m_FutureDate2 
m_FutureDate3 
m_FutureLegal1 
m_FutureLegal2 
m_FutureLegal3 
m_FutureRent1 
m_FutureRent2 
m_FutureRent3 
m_HomePhone1 
m_HomePhone2 
m_InterestInfo 
m_isChanged 
m_LastPaidDate 
m_LateBase 
m_LateFee 
m_LateFeeNo 
m_LateFeeYes 
m_LeaseExpirationDate 
m_LeaseLetterFlag 
m_LeaseStartDate 
m_LegalCode 
m_LegalCode2 
m_LegalFee 
m_LegalFeeNo 
m_LowRentFlag 
m_MBR 
m_MoveinDate 
m_NewOnly 
m_NewTenantFlag 
m_NotPrimeResidence 
m_OldHistoryFilePointer 
m_OptTenant1 
m_OptTenant2 
m_OwnerOccupied 
m_Pager 
m_Paid 
m_PromptPay1 
m_PromptPay2 
m_ProposedLegal 
m_ProposedLegal2 
m_ProposedRent 
m_ProposedRent2 
m_Rent 
m_RentLegal 
m_RentOvercharge 
m_ReplacingTenant 
m_Rooms 
m_SecMultiple 
m_SecondSuccession 
m_Security 
m_SecurityAccount 
m_SecurityBuilding 
m_Seniorcit 
m_SequenceNumber 
m_Shares 
m_SquareFeet 
m_SSNumber1 
m_SSNumber2 
m_Succeeded 
m_Temp1 
m_Temp2 
m_TempExemptOther 
m_TenantName 
m_TenantNumber 
m_TotalCharges 
m_TransientOccupant 
m_Type 
orderBy 
orderBySql 
priKeyName
(Inherited from clsDB)
SQL_COL_421A 
SQL_COL_ADD_NAME 
SQL_COL_ADDITIONAL_NAME 
SQL_COL_ADDITIONAL_NAME_FLAG 
SQL_COL_ALT_BILL_ADD1 
SQL_COL_ALT_BILL_ADD2 
SQL_COL_ALT_BILL_ADD3 
SQL_COL_ALT_BILL_NAME 
SQL_COL_ALTERNATE_BILLING_ADDRESS_FLAG 
SQL_COL_APARTMENT 
SQL_COL_ARREARS 
SQL_COL_BANK 
SQL_COL_BUILDING_NUMBER 
SQL_COL_BUS_PHONE1 
SQL_COL_BUS_PHONE2 
SQL_COL_CELL2 
SQL_COL_CLIENT_ID 
SQL_COL_COMMENT 
SQL_COL_COMMERCIAL_PROFESSIONAL 
SQL_COL_DHCR_A_C_ONE 
SQL_COL_DHCR_A_C_TWO 
SQL_COL_DHCR_DATE_ONE 
SQL_COL_DHCR_DATE_TWO 
SQL_COL_DHCR_DISHWASHER_ONE 
SQL_COL_DHCR_DISHWASHER_TWO 
SQL_COL_DHCR_OTHER_ONE 
SQL_COL_DHCR_OTHER_TEXT_ONE 
SQL_COL_DHCR_OTHER_TEXT_TWO 
SQL_COL_DHCR_OTHER_TWO 
SQL_COL_DHCR_REFRIGERATOR_ONE 
SQL_COL_DHCR_REFRIGERATOR_TWO 
SQL_COL_DHCR_RENT_ONE 
SQL_COL_DHCR_RENT_TWO 
SQL_COL_DHCR_STOVE_ONE 
SQL_COL_DHCR_STOVE_TWO 
SQL_COL_DHCR_WINDOWS_ONE 
SQL_COL_DHCR_WINDOWS_TWO 
SQL_COL_DUE_DATE 
SQL_COL_EMAIL1 
SQL_COL_EMAIL2 
SQL_COL_EXEMPT_COMMERCIAL_PROFESSIONAL_CO 
SQL_COL_EXEMPT_COOP_CONDO_OWNER 
SQL_COL_EXEMPT_DATE 
SQL_COL_EXEMPT_EXP_SEC608 
SQL_COL_EXEMPT_EXP421A 
SQL_COL_EXEMPT_HIGH_RENT_INCOME 
SQL_COL_EXEMPT_HIGH_RENT_VACANCY 
SQL_COL_EXEMPT_HIGH_RENT_VACANY_PERIOD 
SQL_COL_EXEMPT_LAST_LEGAL_PAID 
SQL_COL_EXEMPT_OTHER 
SQL_COL_EXEMPT_OTHER_DESC 
SQL_COL_EXEMPT_SEC11243 
SQL_COL_EXEMPT_SUBSTANTIAL_REHAB 
SQL_COL_EXEMPT421A_INCOME 
SQL_COL_EXEMPT421A_MARKET_RATE 
SQL_COL_EXEMPT421A_MEDIAN_INCOME 
SQL_COL_FAIR_MARKET_APPEAL 
SQL_COL_FUTURE_DATE_1 
SQL_COL_FUTURE_DATE_2 
SQL_COL_FUTURE_DATE_3 
SQL_COL_FUTURE_LEGAL_1 
SQL_COL_FUTURE_LEGAL_2 
SQL_COL_FUTURE_LEGAL_3 
SQL_COL_FUTURE_RENT_1 
SQL_COL_FUTURE_RENT_2 
SQL_COL_FUTURE_RENT_3 
SQL_COL_HOME_PHONE1 
SQL_COL_HOME_PHONE2 
SQL_COL_INTEREST_INFO 
SQL_COL_LAST_PAID_DATE 
SQL_COL_LATE_BASE 
SQL_COL_LATE_FEE 
SQL_COL_LATE_FEE_NO 
SQL_COL_LATE_FEE_YES 
SQL_COL_LEASE_EXPIRATION_DATE 
SQL_COL_LEASE_LETTER_FLAG 
SQL_COL_LEASE_START_DATE 
SQL_COL_LEGAL_CODE 
SQL_COL_LEGAL_CODE_2 
SQL_COL_LEGAL_FEE 
SQL_COL_LEGAL_FEE_NO 
SQL_COL_LOW_RENT_FLAG 
SQL_COL_M_B_R 
SQL_COL_MOVE_IN_DATE 
SQL_COL_NEW_TENANT_FLAG 
SQL_COL_NOT_PRIME_RESIDENCE 
SQL_COL_OLD_HISTORY_FILE_POINTER 
SQL_COL_OPT_TENANT1 
SQL_COL_OPT_TENANT2 
SQL_COL_OWNER_OCCUPIED 
SQL_COL_PAGER 
SQL_COL_PAID 
SQL_COL_PROMPT_PAY1 
SQL_COL_PROMPT_PAY2 
SQL_COL_PROPOSED_LEGAL 
SQL_COL_PROPOSED_LEGAL2 
SQL_COL_PROPOSED_RENT 
SQL_COL_PROPOSED_RENT2 
SQL_COL_PROPOSED_RENT2_1 
SQL_COL_RENT 
SQL_COL_RENT_LEGAL 
SQL_COL_RENT_OVERCHARGE 
SQL_COL_REPLACING_TENANT 
SQL_COL_ROOMS 
SQL_COL_S_S_NUMBER1 
SQL_COL_S_S_NUMBER2 
SQL_COL_SEC_MULTIPLE 
SQL_COL_SECOND_SUCCESSION 
SQL_COL_SECURITY 
SQL_COL_SECURITY_ACCOUNT 
SQL_COL_SECURITY_BUILDING 
SQL_COL_SENIORCIT 
SQL_COL_SEQUENCE_NUMBER 
SQL_COL_SHARES 
SQL_COL_SQUARE_FEET 
SQL_COL_SUCCEEDED 
SQL_COL_TEMP_EXEMPT_OTHER 
SQL_COL_TEMP1 
SQL_COL_TEMP2 
SQL_COL_TENANT_NAME 
SQL_COL_TENANT_NUMBER 
SQL_COL_TOTAL_CHARGES 
SQL_COL_TRANSIENT_OCCUPANT 
SQL_COL_TYPE 
SQL_DELETE
(Inherited from clsDB)
SQL_INSERT 
SQL_LOAD 
SQL_LOAD_ALL 
SQL_LOAD_BY_SEQUENCE_NUMBER 
SQL_LOAD_FOR_DELETION 
SQL_LOAD_FOR_NAMES 
SQL_UPDATE 
TABLE 
updateStmt
(Inherited from clsDB)

See Also