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

 Here is the entire Galaxy Code Sheet:


Define quitfrmGalaxy


Declare GalaxyCustom()
Declare GalaxySetScreen()
Declare GalaxyCreate()
Declare GalaxyModify(GalaxyID.i)
Declare GalaxyDelete(GalaxyID.i)
Declare GalaxySetData()
Declare GalaxySave()

Declare GalaxyClose()

Procedure GalaxySetScreen()
  Protected String$, x, y, w, h, ID
  Shared WorkGalaxy
  Protected EventID, MenuID, GadgetID, WindowID, Index 
  Shared quitfrmGalaxy
  quitfrmGalaxy = #False
  If Window_frmGalaxy()
    DisableWindow(#Window_frmMain, #True) 
    SetActiveWindow(#Window_frmGalaxy)
    GalaxyCustom()
    
    SetGadgetText(#Gadget_frmGalaxy_txtName,  WorkGalaxy\Name)
    SetActiveGadget(#Gadget_frmGalaxy_txtName)
    ;Set Screen Data
    GALAXY::LoadListIcon(#Gadget_frmGalaxy_liSolarsystems)
    If ListEx::CountItems(#Gadget_frmGalaxy_liSolarsystems) > 0
      ListEx::SetState(#Gadget_frmGalaxy_liSolarsystems, 0)
    EndIf

    Repeat
      EventID =WaitWindowEvent()
      MenuID =EventMenu()
      GadgetID =EventGadget()
      WindowID =EventWindow()
      Select EventID
        Case #PB_Event_CloseWindow
          Select WindowID
            Case #Window_frmGalaxy
              GalaxyClose()
          EndSelect
        Case #PB_Event_Menu
          Select WindowID
          EndSelect
        Case #PB_Event_Gadget
          Select GadgetID
            ;*************************************
            ;**** Start frmGalaxy
            ;*************************************
            Case #Gadget_frmGalaxy_lbName
            Case #Gadget_frmGalaxy_txtName
              Select EventType()
                Case #PB_EventType_Focus
                  
                Default
              EndSelect
            Case #Gadget_frmGalaxy_lbSolarsystems
            Case #Gadget_frmGalaxy_liSolarsystems
              Select EventType()
                Case #PB_EventType_LeftDoubleClick
                  PostEvent(#PB_Event_Gadget, #Window_frmGalaxy, #Gadget_frmGalaxy_btModify, #PB_EventType_LeftClick)
              EndSelect
            Case #Gadget_frmGalaxy_btCreate
            Select EventType()
              Case #PB_EventType_LeftClick
                SolarSystemCreate()
            EndSelect
            Case #Gadget_frmGalaxy_btModify
            Select EventType()
              Case #PB_EventType_LeftClick
                Index=ListEx::GetState(#Gadget_frmGalaxy_liSolarsystems)
                If Index>-1
                  SolarSystemModify()
                Else
                  MessageRequester("Blog", "Please Select a Record To MODIFY!")
                EndIf
            EndSelect
            Case #Gadget_frmGalaxy_btDelete
            Select EventType()
              Case #PB_EventType_LeftClick
                Index=ListEx::GetState(#Gadget_frmGalaxy_liSolarsystems)
                If Index>-1
                  SolarSystemDelete()
                Else
                  MessageRequester("Blog", "Please Select a Record To DELETE!")
                EndIf
            EndSelect
            Case #Gadget_frmGalaxy_btSave
            Select EventType()
              Case #PB_EventType_LeftClick
                GalaxySave()
            EndSelect
            Case #Gadget_frmGalaxy_btCancel
            Select EventType()
              Case #PB_EventType_LeftClick
                GalaxyClose()
            EndSelect
          EndSelect
        EndSelect
      Until quitfrmGalaxy = #True
      CloseWindow(#Window_frmGalaxy)
    EndIf

EndProcedure


Procedure GalaxyCreate()
  Shared WorkGalaxy
  GALAXY::Init(@WorkGalaxy)
  GalaxySetScreen()
EndProcedure

Procedure GalaxyModify(GalaxyID.i)
  Shared WorkGalaxy
  GALAXY::Find(GalaxyID , @WorkGalaxy)
  GalaxySetScreen()
EndProcedure

Procedure GalaxyDelete(GalaxyID.i)
  Protected Index, Result, itemCount
  Index = ListEx::GetState(#Gadget_frmMain_liList) 
  DisableWindow(#Window_frmMain, #True) 
  Shared WorkGalaxy
  GALAXY::Find(GalaxyID , @WorkGalaxy)
    MessageRequester("Delete Confirmation", "Are you SURE you want To DELETE this Record ?", #PB_MessageRequester_YesNo )
    If Result = #PB_MessageRequester_Yes 
    If GALAXY::Delete(@WorkGalaxy) = #True
      ListEx::RemoveItem(#Gadget_frmMain_liList, Index)
      itemCount.i = ListEx::CountItems(#Gadget_frmMain_liList)-1
      If itemCount>0
        ListEx::SetState(#Gadget_frmMain_liList, 0)
      EndIf
    EndIf
  EndIf
  DisableWindow(#Window_frmMain, #False) 
EndProcedure

Procedure GalaxySetData()
  Protected Index
  Shared WorkGalaxy
  WorkGalaxy\Name = GetGadgetText(#Gadget_frmGalaxy_txtName) 
EndProcedure

Procedure GalaxySave()
  Shared WorkGalaxy
  Protected State = WorkGalaxy\State
  GalaxySetData()  
  ;Save to Database 
  If Galaxy::Save(@WorkGalaxy) = #True
    If State = DB::#New  ;insert record
      ListEx::AddItem(#Gadget_frmMain_liList,-1, WorkGalaxy\Name, "", 0)
      ListEx::SetItemData(#Gadget_frmMain_liList, ListEx::CountItems(#Gadget_frmMain_liList)-1, WorkGalaxy\ID)
      ListEx::SetState(#Gadget_frmMain_liList , ListEx::CountItems(#Gadget_frmMain_liList)-1)
    Else ;update selected record
      ListEx::SetItemText(#Gadget_frmMain_liList, ListEx::GetState(#Gadget_frmMain_liList), WorkGalaxy\Name,0)
    EndIf
    GalaxyClose()
  EndIf
EndProcedure

Procedure GalaxyClose()
  Shared quitfrmGalaxy
  If IsWindow(#Window_frmMain)
    SetActiveWindow(#Window_frmMain)
    DisableWindow(#Window_frmMain, #False)
  EndIf
  quitfrmGalaxy = #True
EndProcedure

Procedure GalaxyCustom()
  Define X, Y, W, H, Flags
  
  
  ;Convert the LidtIcinGadget to ListEX Custom Gadget
  X = GadgetX(#Gadget_frmGalaxy_liSolarsystems)     : Y = GadgetY(#Gadget_frmGalaxy_liSolarsystems)
  W = GadgetWidth(#Gadget_frmGalaxy_liSolarsystems) : H = GadgetHeight(#Gadget_frmGalaxy_liSolarsystems)
  FreeGadget(#Gadget_frmGalaxy_liSolarsystems)
  ;Now to create oue ListEx
  Flags = ListEx::#AdjustColumns|ListEx::#ResizeColumn|ListEx::#GridLines;|ListEx::#AutoResize
  ListEx::Gadget(#Gadget_frmGalaxy_liSolarsystems, X, Y, W, H, "", 25, "", Flags, #Window_frmMain)
  

EndProcedure


Comments

Post a Comment

Popular posts from this blog

PAHLabs Blog goes Live

 Welcome All! Today with this post the PAHLabs Blog goes Live. It is a goal of mine to share with others my passion in Software Development, Coding and Application Design.  I plan to use this blog to reach out to those of like minds, and especially those wanting to learn. Though in my 40+ year career in software development I have written many, many software languages, this blog is mostly going to focus on PureBasic.  I have an accompanying website ( https://www.PAHLabs.com ) where I have both free and licensed software products, developed using the PureBasic Language.  You can find out more about PureBasic at  PureBasic Here in my blog, I will begin explaining how these applications were written, and to share with you how I develop software.   The first thing about software development I wish to share with you is that software development is all about solving problems. A software program is nothing more than a solution to a problem.  As with ALL ...
Read more

How to build this without writing Code

I'm not sure if I should do this now, because I have not explained a number of additional aspects to the code, but for those of you who are interested.  The foundation of what I shown you here, IS the foundation of code my PBXClassBuilder-Standard generates for you.  And I truly mean generates  for you. You can have all this code generated for you without writing a single line of it yourself. Now PBXClassBuilder-Standard is not perfect, it is approximately 90=95% accurate. And I am constantly tweaking it edging this number ever higher. To use PBXClassBuilder-Standard, You should start with Forms already laid out and built.  Within PBXClassBuilder-Standard you use intuitive screens to define your table structure, while linking the Table Fields to their intended form Fields.  Then link the Tables together as Parent Child, and finally you simply click buttons to generate the code, Including the SQL Code to create the tables. The Whole development process, post For...
Read more

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 =EventG...
Read more