SCM_SwimClubMeet-R/dlgDivision.pas at main · Artanemus/SCM_SwimClubMeet-R · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
unit dlgDivision;

interface

uses
  Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants,
  System.Classes, Vcl.Graphics,
  Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Data.DB, FireDAC.Stan.Intf,
  FireDAC.Stan.Option, FireDAC.Stan.Param, FireDAC.Stan.Error, FireDAC.DatS,
  FireDAC.Phys.Intf, FireDAC.DApt.Intf, FireDAC.Stan.Async, FireDAC.DApt,
  FireDAC.Comp.Client, FireDAC.Comp.DataSet,
  Vcl.StdCtrls, Vcl.DBCtrls, Vcl.Grids, Vcl.DBGrids, Vcl.Mask, Vcl.ExtCtrls,
  Vcl.ComCtrls, frxPreview, frxClass, frxDBSet;

type
  TDivision = class(TForm)
    Panel2: TPanel;
    btnClose: TButton;
    PageControl1: TPageControl;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    DBGrid1: TDBGrid;
    Label5: TLabel;
    qryDivision: TFDQuery;
    qryDivisionScoreDivisionID: TFDAutoIncField;
    qryDivisionSwimClubID: TIntegerField;
    qryDivisionAgeFrom: TIntegerField;
    qryDivisionAgeTo: TIntegerField;
    qryDivisionGenderID: TIntegerField;
    dsDivision: TDataSource;
    qryDivisionluGender: TStringField;
    qryDivisionCaption: TWideStringField;
    btnDivMembers: TButton;
    Label10: TLabel;
    DBNavigator1: TDBNavigator;
    tblGender: TFDTable;
    luGender: TDataSource;
    frxDivMembers: TfrxReport;
    frxDSDivMembers: TfrxDBDataset;
    qryDivMembers: TFDQuery;
    qryRptHeader: TFDQuery;
    frxDBDSRptHeader: TfrxDBDataset;

    procedure FormDestroy(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure btnCloseClick(Sender: TObject);
    procedure FormKeyDown(Sender: TObject; var Key: Word; Shift: TShiftState);
    procedure FormShow(Sender: TObject);
    procedure btnDivMembersClick(Sender: TObject);

  private
    { Private declarations }
    fSwimClubID: integer;
    fConnection: TFDConnection;
    fStartOfSwimSeason: TDateTime;

    procedure WritePreferences(iniFileName: string);
    procedure ReadPreferences(iniFileName: string);
  public
    { Public declarations }
    property Connection: TFDConnection write FConnection;
    property StartOfSwimSeason: TDateTime write fStartOfSwimSeason;
  end;

var
  Division: TDivision;

implementation

{$R *.dfm}

uses SCMUtility, iniFiles;

procedure TDivision.btnCloseClick(Sender: TObject);
begin
  ModalResult := mrOk;
end;

procedure TDivision.btnDivMembersClick(Sender: TObject);
begin
  // note : uses RPTS.qryRptHeader
	if (fStartOfSwimSeason <> 0) and Assigned(fConnection) then
  begin
    qryRptHeader.Connection := fConnection;
    qryRptHeader.Open();
    qryDivMembers.Connection := fConnection;
    qryDivMembers.ParamByName('SEEDDATE').AsDateTime := fStartOfSwimSeason;
    qryDivMembers.Prepare();
    qryDivMembers.Open();
    if (qryDivMembers.Active) and (qryRptHeader.Active) then
      frxDivMembers.ShowReport;
  end;
end;

procedure TDivision.FormCreate(Sender: TObject);
var
  iniFileName: string;
begin
  // i n i t   p a r a m s  .
  // -------------------------------------
  PageControl1.TabIndex := 0;
  fSwimClubID := 1;
  fStartOfSwimSeason := 0;
  // -------------------------------------
  // r e a d   p r e f e r e n c e .
  // -------------------------------------
  iniFileName := Scmutility.GetSCMPreferenceFileName;
  if FileExists(iniFileName) then
    ReadPreferences(iniFileName);
  PageControl1.TabIndex := 0;
end;

procedure TDivision.FormDestroy(Sender: TObject);
var
  iniFileName: string;
begin
  iniFileName := GetSCMPreferenceFileName();
  if FileExists(iniFileName) then
    WritePreferences(iniFileName);
end;

procedure TDivision.FormKeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key = VK_ESCAPE then
    ModalResult := mrOk;
end;

procedure TDivision.FormShow(Sender: TObject);
begin
  // -------------------------------------
  // C O N N E C T   L O C A L   D A T A S E T S  .
  // -------------------------------------
  if assigned(fConnection) then
  begin
    qryDivision.Connection := fConnection;
    tblGender.Connection := fConnection;
    // Activate tables/queries contained in this dialogue
    tblGender.Open;
    qryDivision.ParamByName('SWIMCLUBID').AsInteger := fSwimClubID;
    qryDivision.Prepare;
    qryDivision.Open();
  end;
end;


procedure TDivision.ReadPreferences(iniFileName: string);
var
  iFile: TIniFile;
begin
  iFile := TIniFile.Create(iniFileName);
//
  iFile.Free;
end;


procedure TDivision.WritePreferences(iniFileName: string);
var
  iFile: TIniFile;
begin
  iFile := TIniFile.Create(iniFileName);
//
  iFile.Free;
end;


end.