Connecting the Forms to the Data-Layer (part 9)

Here is the whole View Code Sheet




Define quitfrmSolarSystem

Declare SolarSystemCustom()
Declare SolarSystemSetScreen()
Declare SolarSystemCreate()
Declare SolarSystemModify()
Declare SolarSystemDelete()
Declare SolarSystemSetData()
Declare SolarSystemSave()
Declare SolarSystemClose()

Procedure SolarSystemSetScreen()
  Protected String$, x, y, w, h, i, ID
  Shared WorkSolarSystem
  Protected EventID, MenuID, GadgetID, WindowID, Index 
  Shared quitfrmSolarSystem
  quitfrmSolarSystem = #False
  If Window_frmSolarSystem()
    
    SolarSystemCustom()
    SetActiveWindow(#Window_frmSolarSystem)
    ;Set Screen Data
    SetGadgetText(#Gadget_frmSolarSystem_txtName,  WorkSolarSystem\Name)
    SetGadgetText(#Gadget_frmSolarSystem_txtGrow, Str(WorkSolarSystem\GRow))
    SetGadgetText(#Gadget_frmSolarSystem_txtGCol, Str(WorkSolarSystem\GCol))
   
    SetActiveGadget(#Gadget_frmSolarSystem_txtName)
    Repeat
      EventID =WaitWindowEvent()
      MenuID =EventMenu()
      GadgetID =EventGadget()
      WindowID =EventWindow()
      Select EventID
        Case #PB_Event_CloseWindow
          Select WindowID
            Case #Window_frmSolarSystem
              SolarSystemClose()
          EndSelect
        Case #PB_Event_Menu
          Select WindowID
          EndSelect
        Case #PB_Event_Gadget
          Select GadgetID
            ;*************************************
            ;**** Start frmSolarSystem
            ;*************************************
            Case #Gadget_frmSolarSystem_lbName
            Case #Gadget_frmSolarSystem_txtName
              Select EventType()
                Case #PB_EventType_Focus
                  
                Default
              EndSelect
            Case #Gadget_frmSolarSystem_lbGRow
            Case #Gadget_frmSolarSystem_txtGrow
              Select EventType()
                Case #PB_EventType_Focus
                  
                Default
              EndSelect
            Case #Gadget_frmSolarSystem_lbGCol
            Case #Gadget_frmSolarSystem_txtGCol
              Select EventType()
                Case #PB_EventType_Focus
                  
                Default
              EndSelect
           
            Case #Gadget_frmSolarSystem_btSave
            Select EventType()
              Case #PB_EventType_LeftClick
                SolarSystemSave()
            EndSelect
            Case #Gadget_frmSolarSystem_btCancel
            Select EventType()
              Case #PB_EventType_LeftClick
                SolarSystemClose()
            EndSelect
            
          EndSelect
        EndSelect
      Until quitfrmSolarSystem = #True
      CloseWindow(#Window_frmSolarSystem)
    EndIf

EndProcedure

Procedure SolarSystemCreate()
  Shared WorkSolarSystem
  DisableWindow(#Window_frmGalaxy, #True) 
  SOLARSYSTEM::Init(@WorkSolarSystem)
  SolarSystemSetScreen()
EndProcedure

Procedure SolarSystemModify()
  Protected Index 
  Index = GetGadgetState(#Gadget_frmGalaxy_liSolarsystems) 
  Shared WorkGalaxy
  Shared WorkSolarSystem
  DisableWindow(#Window_frmGalaxy, #True) 
  If Index > -1
    SelectElement(WorkGalaxy\SolarSystemCollection(), Index) 
    WorkSolarSystem = WorkGalaxy\SolarSystemCollection()
    If WorkSolarSystem\State = DB::#New Or WorkSolarSystem\State = DB::#NewDirty
      WorkSolarSystem\State = DB::#NewDirty
    Else
      WorkSolarSystem\State = DB::#Dirty
    EndIf
    SolarSystemSetScreen()
  EndIf
EndProcedure

Procedure SolarSystemDelete()
  Protected Index, Result
  Shared WorkGalaxy
  Shared WorkSolarSystem
  DisableWindow(#Window_frmGalaxy, #True) 
  Index = ListEx::GetState(#Gadget_frmGalaxy_liSolarsystems)
  If Index > -1
    Result = MessageRequester("Delete Confirmation", "Are you SURE you want To DELETE this Record ?", #PB_MessageRequester_YesNo) 
    If Result = #PB_MessageRequester_Yes 
      SelectElement(WorkGalaxy\SolarSystemCollection(), Index)
      WorkSolarSystem = WorkGalaxy\SolarSystemCollection()
      DeleteElement(WorkGalaxy\SolarSystemCollection())
      If WorkSolarSystem\State <> DB::#New And WorkSolarSystem\State <> DB::#NewDirty
        AddElement(WorkGalaxy\DeleteSolarSystemCollection())  
        WorkGalaxy\DeleteSolarSystemCollection() = WorkSolarSystem
      EndIf
    Index = ListEx::GetState(#Gadget_frmGalaxy_liSolarsystems) 
    EndIf 
    DisableWindow(#Window_frmGalaxy, #False) 
  EndIf 
EndProcedure 

Procedure SolarSystemSetData()
  Protected Index
  Shared WorkSolarSystem
  WorkSolarSystem\Name = GetGadgetText(#Gadget_frmSolarSystem_txtName) 
  WorkSolarSystem\GRow = Val(GetGadgetText(#Gadget_frmSolarSystem_txtGrow)) 
  WorkSolarSystem\GCol = Val(GetGadgetText(#Gadget_frmSolarSystem_txtGCol)) 
EndProcedure

Procedure SolarSystemSave()
  Protected Index, State
  Shared WorkGalaxy
  Shared WorkSolarSystem
  Index = GetGadgetState(#Gadget_frmGalaxy_liSolarsystems)
  State = WorkSolarSystem\State
  SolarSystemSetData()  
  If SOLARSYSTEM::Validate(WorkSolarSystem)
    If State = DB::#New Or State = DB::#NewDirty
      ;ADD to Collection 
      LastElement(WorkGalaxy\SolarSystemCollection())  
      AddElement(WorkGalaxy\SolarSystemCollection())  
      WorkGalaxy\SolarSystemCollection()=WorkSolarSystem
      ListEx::AddItem(#Gadget_frmGalaxy_liSolarsystems,-1, GALAXY::ListIconItemSolarSystem(@WorkSolarSystem), "", 0)
      ListEx::SetState(#Gadget_frmGalaxy_liSolarsystems , ListEx::CountItems(#Gadget_frmGalaxy_liSolarsystems)-1)
    Else
      ListEx::SetItemText(#Gadget_frmGalaxy_liSolarsystems, Index, GALAXY::ListIconItemSolarSystem(@WorkSolarSystem), 0)
      SelectElement(WorkGalaxy\SolarSystemCollection(), Index) 
      WorkGalaxy\SolarSystemCollection()=WorkSolarSystem
    EndIf
    SolarSystemClose()
  EndIf 
EndProcedure

Procedure SolarSystemClose()
  Shared quitfrmSolarSystem
  If IsWindow(#Window_frmGalaxy)
    SetActiveWindow(#Window_frmGalaxy)
    DisableWindow(#Window_frmGalaxy, #False)
  EndIf
  quitfrmSolarSystem = #True
EndProcedure


Procedure SolarSystemCustom()
  

EndProcedure


Comments

Post a Comment

Popular posts from this blog

Connecting the Forms to the Data-Layer (part 1)

Image
Completing this series of Entries can not be complete until we connect the data-Layer with the Forms, and the is the goal of these next few entries. As methodical as my approch was with the Data-Layer, will be my approach to Forms. Now regardless, of what tool, if any, you use to develop your forms; Forms serve only Two Purposes. The first being, to present data, from the database, to the users, and Secondly to input all changes the user makes back into the Database. I will pick up where we left off, and build out our Galaxy/SolarSystem Example with the following Forms: Galaxy Form: Solar System Form: And here is the Code that generates these forms. Procedure.i Window_frmSolarSystem() If OpenWindow(#Window_frmSolarSystem,0,0,430,186,"Solar System",#PB_Window_SystemMenu|#PB_Window_ScreenCentered|#PB_Window_Invisible,WindowID(#Window_frmMain)) TextGadget(#Gadget_frmSolarSystem_lbName,40,10,150,25,"Name: ",#PB_Text_Right) SetGadgetFont(#Gadget_
Read more

Module DB, the foundation of any Data Layer.

 At the heart of any application is the database. Therefore, this segment of the application should be bulletproof.  To prevent repeating code, it should start with the module I call DB.  Module DB it the bottom most module, it is the actual module which interacts with the database.  If later you decide to migrate your database from SQLite to say Postgres, then all you will need to do is tweak THIS Module.  This module will also contain the Enumeration of "STATE".  By this I mean the current state of the record, is it: New - Created but not yest saved to the database. Clean - The Record is "Untouched". It is Identical to the record saved in the Database. Dirty - The record was loaded from the database, but it has been changed in some manner. DeleteRec - The record has been marked for deletion, but the user has yet to commit the delete to the database. NewDirty - The record is new, but the User is changing something, or the new record is being modified but has never
Read more

Defining Database Tables (part 1)

 Welcome back! In this blog entry we will begin the definition of a Table DB Module, which will be built on top of our DB Module. As you will remember the DB Module is the lowest level Module in our Database Layer. He is the only module who interacts with the database, no other module in your application should directly touch the database. Now I will begin the definition of the Modules who sit atop DB. There are three distinct table Structures that have to be considered.  Single, or stand-alone, Table - examples of this the bottom Module of the Parent Child Structure, or and Class which has No Children.  A Static list of Values, a List of Error Codes. This is often referred to an "is a" paradigm. if an object is a ErrorType, where ErrorType is Not a child. Parent-Child Table - A great example of this would be Galaxy, a Galaxy has Many SolarSystems, each SolarSystem has many Planets, Each Planet has Many Factories.  As you can see the Parent Child Table Structure is best desc
Read more