| Class: Images-Image Handling |
| How to Read: Property/Method(Parameter As Type, ...) As ReturnValue |
| Properties |
| ImgID() As Long Purpose: Return Image ID |
| ImgID(ID As Long) Purpose: Set Image ID to update a specific record |
| ImgContactID() As String Purpose: Return Contact ID Number |
| ImgContactID(ContactID As String) Purpose: Set Contact ID Number for record update |
| ImgOrder() As String Purpose: Return Image Order Number |
| ImgOrder(Order As String) Purpose: Set Image Order Number for record update |
| ImgHeading() As String Purpose: Return Heading (Grouping Name) |
| ImgHeading(Heading As String) Purpose: Set Heading (Grouping Name) for record update |
| ImgCaption() As String Purpose: Return Image Caption |
| ImgCaption(Caption As String) Purpose: Set Image Caption for record update |
| ImgLocation() As String Purpose: Return Image Location (Full Path) |
| ImgLocation(Location As String) Purpose: Set Image Location (Full Path) for record update |
| VideoFileSmall() As String Purpose: Return Small Video Filename |
| VideoFileSmall(SmallVideoFileName As String) Purpose: Set Small Video Filename for record update |
| VideoFileLarge() As String Purpose: Return Large Video Filename |
| VideoFileLarge(LargeVideoFileName As String) Purpose: Set Large Video Filename for record update |
| ImageIndex() As Integer Purpose: Return current Image Index |
| ImageCount() As Integer Purpose: Return Image Count after calling GetImageByContactID() |
| ImageEnd() As Boolean Purpose: Used with GetImageByContactID() and NextImage() |
| Methods |
| GetImageByContactID(ContactID As String) As Boolean Purpose: Search DB for records that contain Contact ID Number in 'cont_id' field Use ImageByIndex() to retrieve records by Index [ 1 to ImageCount() ] Requires: (String) Contact ID Number Returns: True - successful; False - error or no records were found |
| NextImage() As Boolean Purpose: Return data for next image found |
| ImageByIndex(Index As Integer) As Boolean Purpose: Return Image data for a given Index after calling GetImageByContactID() Requires: Index - number between 1 and ImageCount() Returns: True - successful; False - error |
| ImageHasDBRecord(Filename As String) As Boolean Purpose: Search DB for records that contain Filename in 'img_location' field Requires: Complete Filename (i.e, 980001.jpg) - or - filename and letter designator (i.e, 980001A) Returns: True - successful; False - error or no records were found |
| UpdateImageDB() As Boolean Purpose: Update DB record for given ID - Set values using the Image properties (ImgContactID, ImgOrder, ...) Use ImgID(0) to Add a record to the DB Use ImgID(ID) to Update a record by ID Returns: True - successful; False - error |
| RemoveImages(PictureFilePath As String, ImageList As String) As Boolean Purpose: Remove Image File from file system and delete record from database Requires: Complete Path; Full Filename (i.e., 980001A.jpg) Returns: True - successful; False - error |
| DeleteDBRecord(Filename As String) As Boolean Purpose: Delete record from database that contain Filename in 'img_location' field Requires: Complete Filename (i.e, 980001.jpg) - or - filename and letter designator (i.e, 980001A) Returns: True - successful; False - error |
| SortImages(PictureFilePath As String, ContactID As String, ImageList As String) As Boolean Purpose: Resort images - assume no images are added before processing Path and Contact ID used to get original list from file system which is compared to comma delimited ImageList as array Non-matching index filenames are renamed as temp files, then renamed as sorted filenames Requires: Complete Path; Contact ID; Image List (comma delimited) Returns: True - successful; False - error |
| ResetImageVars() Purpose: Reset all Image variables |