| Class: Images-Image Counter Handling |
| How to Read: Property/Method(Parameter As Type, ...) As ReturnValue |
| Properties |
| ImgCountID() As Long Purpose: Return Image Count Record ID |
| ImgCountID(RecordID As Long) Purpose: Set Image Count Record ID to update a specific record |
| CountMLS() As Long Purpose: Return MLS Number |
| CountMLS(MLSNumber As Long) Purpose: Set MLS Number for record update |
| PageTypeID() As Long Purpose: Return Page Type ID |
| PageTypeID(ID As Long) Purpose: Set Page Type ID to update a specific record |
| PageTitleID() As Long Purpose: Return Page Title ID |
| PageTitleID(ID As Long) Purpose: Set Page Title ID to update a specific record |
| SubTitleID() As Long Purpose: Return Sub Title ID |
| SubTitleID(ID As Long) Purpose: Set Sub Title ID to update a specific record |
| ImgName() As String Purpose: Return Image name - complete Filename (i.e, 980001A.jpg) |
| ImgName(ImageName As String) Purpose: Set Image name (complete filename) for record update |
| EntryDate() As String Purpose: Return Entry Date |
| ImgCount() As Long Purpose: Return Image Count |
| ImgCount(TotalCount As Long) Purpose: Set Image Count to update a specific record |
| ImgTotalCount() As Long Purpose: Return Total of Counts after calling GetCounters() |
| QueryStartDate(StartDate As String) Purpose: Set Start Date for query GetCounters() |
| QueryEndDate(EndDate As String) Purpose: Set End Date for query GetCounters() |
| CountIndex() As Integer Purpose: Return current Count Index |
| ImgCounterCount() As Integer Purpose: Return Counter Count after calling GetCounters() |
| Methods |
| GetCounters() As Boolean Purpose: Search DB for Counter records Set criteria using the Image Count properties: ImgCountID(RecordID As Long) - OR - CountMLS(MLSNumber As Long) PageTypeID(ID As Long) PageTitleID(ID As Long) SubTitleID(ID As Long) ImgName(ImageName As String) QueryStartDate(StartDate As String) QueryEndDate(EndDate As String) Use CountByIndex() to retrieve records by Index [ 1 to ImgCounterCount() ] Requires: MLS Number Returns: True - successful; False - error or no records were found |
| CountByIndex(Index As Integer) As Boolean Purpose: Return Counter data for a given Index after calling GetCounters() Requires: Index - number between 1 and ImageCounterCount() Returns: True - successful; False - error |
| UpdateImageCount() As Boolean Purpose: Update DB Image Count given Image - Set values using the Image Count properties: CountMLS(MLSNumber As Long) PageTypeID(ID As Long) PageTitleID(ID As Long) SubTitleID(ID As Long) ImgName(ImageName As String) Returns: True - successful; False - error |
| ResetCounterVars() Purpose: Reset all Image variables |