public frmBetalingenBestand(DataAdapters da)
{
InitializeComponent();
param = new tblParameters();
betalingen = da.VulBetalingRecords();
dataAdaptor = da;
_windowState = new PersistWindowState(this, @"Leden\BetalingenBestand");
PersistControlValue.ReadControlValue(txtFilePrefixB);
PersistControlValue.ReadControlValue(txtFileSeqnrB);
PersistControlValue.ReadControlValue(txtMsgIDB);
PersistControlValue.ReadControlValue(txtOutputLocationIncB);
PersistControlValue.ReadControlValue(chkPrintVerslagB);
int nbrBetalingen = 0;
decimal sumBetalingen = 0;
foreach (tblBetaling betaling in betalingen)
{
if (betaling.Verstuurd)
{
continue;
}
sumBetalingen += betaling.TotaalBedrag;
nbrBetalingen++;
}
lblMessage.Text = "Aantal: " + nbrBetalingen.ToString() + " - Bedrag: " + sumBetalingen.ToEuroString();
}
public frmExportForMail(DataAdapters da, tblParameters Param)
{
InitializeComponent();
param = Param;
leden = da.VulLedenLijst();
//extraMailAdresses = new MosaicMru(this, "ExportMail");
//extraMailAdresses.ItemsSaveLimit = 10;
//extraMailAdresses.ItemsAreFiles = false;
//extraMailAdresses.BuildMenu(clbExtraEmail);
_windowState = new PersistWindowState(this, @"Leden\ExportMail");
txtOutputMailLocation.Text = param.mtxtOutputMailLocation;
try
{
foreach (string s in param.mtxtExtraEmail)
{
clbExtraEmail.Items.Add(s);
}
}
catch { }
//PersistControlValue.ReadControlValue(txtOutputMailLocation);
fileName = txtOutputMailLocation.Text + @"\" + param.ClubNameShort + "_Ledenlijst_voor_Mail.xml";
}
public frmSelectLeden(LedenLijst l)
{
InitializeComponent();
leden = l;
_windowState = new PersistWindowState(this, @"Leden\LedenSelect");
foreach (tblLid lid in leden)
{
clbLeden.Items.Add(lid.VolledigeNaam, true); //lid.Gemerkt);
}
clbLeden.MultiColumn = true;
cboFilterLeeftijd.Items.AddRange(strFilterLeeftijd);
cboFilterLeeftijd.SelectedIndex = 0;
cboFilterLidBond.Items.AddRange(strFilterBond);
cboFilterLidBond.SelectedIndex = 0;
cboFilterCompetitie.Items.AddRange(strFilterCompetitie);
cboFilterCompetitie.SelectedIndex = 0;
cboFilterLidType.Items.AddRange(strFilterLidTypeDescriptions);
cboFilterLidType.SelectedIndex = 0;
cboFilterBetaalWijze.Items.AddRange(strFilterBetaalWijzeDescriptions);
cboFilterBetaalWijze.SelectedIndex = 0;
cboFilterLeeftijd.SelectedIndexChanged += new System.EventHandler(this.cboFilter_SelectedIndexChanged);
cboFilterLidBond.SelectedIndexChanged += new System.EventHandler(this.cboFilter_SelectedIndexChanged);
cboFilterCompetitie.SelectedIndexChanged += new System.EventHandler(this.cboFilter_SelectedIndexChanged);
cboFilterLidType.SelectedIndexChanged += new System.EventHandler(this.cboFilter_SelectedIndexChanged);
cboFilterBetaalWijze.SelectedIndexChanged += new System.EventHandler(this.cboFilter_SelectedIndexChanged);
}
public GridView(MainForm parent, ref configurationGrid layout)
{
_mainForm = parent;
InitializeComponent();
_gv = new Controls.GridView(_mainForm, ref layout, this);
_gv.KeyDown += GridView_KeyDown;
Controls.Add(_gv);
_gv.Dock = DockStyle.Fill;
_layout = layout;
fullScreenToolStripMenuItem.Checked = layout.FullScreen;
alwaysOnTopToolStripMenuItem.Checked = layout.AlwaysOnTop;
Cg = layout;
Disposed += (s, a) =>
{
_mWindowState?.Dispose();
};
if (!layout.FullScreen)
{
_mWindowState = new PersistWindowState {
Parent = this, RegistryPath = @"Software\ispy\grid_" + _layout.name
}
}
;
RenderResources();
}
public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
persistState = new PersistWindowState(registryPath, this);
}
private void Common(DataAdapters da)
{
InitializeComponent();
_windowState = new PersistWindowState(this, @"Leden\EenmaligeRekening");
cboTypeRekening.Items.AddRange(tblRekening.RekeningTypeDescriptions);
cboTypeRekening.SelectedIndex = 1;
param = new tblParameters();
dataAdaptor = da;
reportFileName = param.LocationLogFiles + @"\" + param.ClubNameShort + "_Aangemaakte rekeningen.csv";
}
public Form1()
{
//
// Windows Form 디자이너 지원에 필요합니다.
//
InitializeComponent();
//
// TODO: InitializeComponent를 호출한 다음 생성자 코드를 추가합니다.
//
persistState = new PersistWindowState(registryPath, this);
}
public StationMapForm()
{
InitializeComponent();
persistState = new PersistWindowState(registryPath, this);
DesignSurface surface = new DesignSurface();
IServiceContainer container = surface.GetService(typeof(IServiceContainer)) as IServiceContainer;
_menuCommandService = new MenuCommandService(surface);
if (container != null)
{
container.AddService(typeof(IMenuCommandService), _menuCommandService);
}
DrawForm();
//InitStationDeviceType();
}
public frmContributieAanmaken(DataAdapters da, tblParameters Param)
{
InitializeComponent();
leden = da.VulLedenLijst();
rekeningen = da.VulRekeningRecords();
dataAdaptor = da;
// param = new tblParameters();
param = Param;
_windowState = new PersistWindowState(this, @"Leden\ContributieAanmaken");
reportFileName = param.LocationLogFiles + @"\" + param.ClubNameShort + "_Aangemaakte rekeningen.csv";
dtpPeilDatum.Value = param.ContributiePeilDatum;
cboSelectieType.SelectedIndex = 0;
clbLidTypes.Items.AddRange(tblLid.LidTypeDescriptions);
clbLidTypes.Items.RemoveAt(2);
txtCompBijdrageSen.Text = param.cCompBijdrageSen.ToEuroString();
txtCompBijdrageJun.Text = param.cCompBijdrageJun.ToEuroString();
txtBondsBijdrage.Text = param.cBondsBijdrage.ToEuroString();
txtSen.Text = param.cSen.ToEuroString();
txt65.Text = param.c65.ToEuroString();
txtWlpPup.Text = param.cWlpPup.ToEuroString();
txtCadJun.Text = param.cCadJun.ToEuroString();
txtKostenRekening.Text = param.cKostenRekening.ToEuroString();
txtPercZwerf.Text = param.cPercZwerf.ToString();
txtPakketBedrag.Text = param.cPakketBedrag.ToEuroString();
txtOmschrijving.Text = param.cOmschrijving;
txtKortingVrijwilliger.Text = param.cKortingVrijwilliger.ToEuroString();
//PersistControlValue.ReadControlValue(txtOmschrijving);
//PersistControlValue.ReadControlValue(txtCompBijdrageSen);
//PersistControlValue.ReadControlValue(txtCompBijdrageJun);
//PersistControlValue.ReadControlValue(txtBondsBijdrage);
//PersistControlValue.ReadControlValue(txtSen);
//PersistControlValue.ReadControlValue(txt65);
//PersistControlValue.ReadControlValue(txtWlpPup);
//PersistControlValue.ReadControlValue(txtCadJun);
//PersistControlValue.ReadControlValue(txtKostenRekening);
//PersistControlValue.ReadControlValue(txtPercZwerf);
//PersistControlValue.ReadControlValue(txtPakketBedrag);
//PersistControlValue.ReadControlValue(txtKortingVrijwilliger);
}
public CodeForm(string code)
{
Text = Properties.Resources.CaptionCodeForm;
Icon = Properties.Resources.Icon;
persistWindowState = new PersistWindowState();
persistWindowState.Parent = this;
persistWindowState.WindowStateLoaded += new PersistWindowState.WindowStateEventHandler(OnWindowStateLoaded);
persistWindowState.WindowStateSaved += new PersistWindowState.WindowStateEventHandler(OnWindowStateSaved);
InitializeComponent();
BuildContextMenu();
richTextBox.Font = new Font("Courier New", 10);
richTextBox.Text = code;
buttonWordWrap.Text = richTextBox.WordWrap ? Properties.Resources.MenuItemDontWordWrap : Properties.Resources.MenuItemWordWrap;
}
public frmAankondiging(DataAdapters da, tblParameters xParam)
{
InitializeComponent();
param = xParam;
verstuurdeRekeningenReport = param.LocationLogFiles + @"\" + param.ClubNameShort + @"_Verstuurde rekeningen.csv";
EmailLogFile = param.LocationLogFiles + @"\" + param.ClubNameShort + "_Mail_Logfile.txt";
if (!File.Exists(EmailLogFile))
{
File.Create(EmailLogFile);
}
rekeningen = da.VulRekeningRecords();
leden = da.VulLedenLijst();
dataAdaptor = da;
_windowState = new PersistWindowState(this, @"Leden\Aankondiging");
chkLogEmail.Checked = param.LogEmail;
ckbDoNotSendEmail.Checked = param.DoNotSendEmail;
foreach (Leden.Net.tblRekening rekening in rekeningen)
{
if (rekening.Verstuurd)
{
continue;
}
if (rekening.Lid.IsIncasso)
{
selectedInc.Add(rekening);
sumTotaalInc += rekening.TotaalBedrag;
nbrTxtInc++;
}
if (rekening.Lid.IsRekening)
{
selectedRek.Add(rekening);
sumTotaalRek += rekening.TotaalBedrag;
nbrTxtRek++;
}
}
dtpIncassoDatum.Value = DateTime.Now.AddDays(10);
lblMessage.Text = "Aantal: " + nbrTxtInc.ToString() + " - Bedrag: " + sumTotaalInc.ToEuroString();
lblMessageRek.Text = "Aantal: " + nbrTxtRek.ToString() + " - Bedrag: " + sumTotaalRek.ToEuroString();
}
public frmParameters(tblParameters p)
{
InitializeComponent();
param = p;
_windowState = new PersistWindowState(this, @"Leden\Parameters");
txtIBAN.Text = param.IBAN;
txtBIC.Text = param.BIC;
txtTemplateLoc.Text = param.LocationTemplates;
txtLocatieLogFiles.Text = param.LocationLogFiles;
txtNameLong.Text = param.ClubNameLong;
txtNameShort.Text = param.ClubNameShort;
txtKvK.Text = param.KvK;
txtSMTPServer.Text = param.STMPserver;
txtPort.Text = param.STMPport.ToString();
txtReturnAddress.Text = param.EmailReturnAdress;
txtStatuten.Text = param.BijlageStatuten;
txtReglement.Text = param.BijlageReglement;
txtInfoFolder.Text = param.BijlageInfoFolder;
txtUserID.Text = param.EmailUserId;
txtPassword.Text = param.EmailPassword;
ckbDoNotSendEmail.Checked = param.DoNotSendEmail;
chkLogEmail.Checked = param.LogEmail;
}
public frmCompResult2(DataAdapters da)
{
InitializeComponent();
param = new tblParameters();
leden = da.VulLedenLijst();
resultaten = da.VulCompResultRecords();
dataAdaptor = da;
_windowState = new PersistWindowState(this, @"Leden\CompResult");
cboJaar.Items.Add(DateTime.Today.Year - 1);
cboJaar.Items.Add(DateTime.Today.Year);
cboSeizoen.Items.AddRange(tblCompResult.CompSeizoen);
DateTime now_date = DateTime.Now;
DateTime july_1_thisYear = new DateTime(DateTime.Now.Year, 7, 1, 0, 0, 0);
if (now_date < july_1_thisYear)
{
cboJaar.SelectedIndex = 1;
cboSeizoen.SelectedIndex = 0;
}
else
{
cboJaar.SelectedIndex = 0;
cboSeizoen.SelectedIndex = 1;
}
InitializeDataGridView(dgView);
#region Create Columns
DataGridViewTextBoxColumn dgvc0 = new DataGridViewTextBoxColumn();
dgvc0.Name = "LidNr";
dgvc0.Width = 180;
dgvc0.Visible = false;
DataGridViewTextBoxColumn dgvc1 = new DataGridViewTextBoxColumn();
dgvc1.Name = "Naam";
dgvc1.Width = 180;
dgvc1.ReadOnly = true;
dgvc1.SortMode = DataGridViewColumnSortMode.Automatic;
DataGridViewTextBoxColumn dgvc2 = new DataGridViewTextBoxColumn();
dgvc2.Name = "Bondsnummer";
dgvc2.Width = 60;
dgvc2.ReadOnly = true;
dgvc2.SortMode = DataGridViewColumnSortMode.Automatic;
DataGridViewComboBoxColumn dgvc3 = new DataGridViewComboBoxColumn();
dgvc3.Name = "Klasse";
dgvc3.Width = 120;
dgvc3.ReadOnly = false;
dgvc3.SortMode = DataGridViewColumnSortMode.Automatic;
dgvc3.Items.AddRange(tblCompResult.CompKlasses);
DataGridViewTextBoxColumn dgvc4 = new DataGridViewTextBoxColumn();
dgvc4.Name = "Percentage";
dgvc4.Width = 80;
dgvc4.ReadOnly = false;
dgvc4.SortMode = DataGridViewColumnSortMode.Automatic;
dgView.Columns.AddRange(new DataGridViewColumn[] { dgvc0, dgvc1, dgvc2, dgvc3, dgvc4 });
dgView.ReadOnly = false;
dgView.Width = 460;
#endregion
CreateRows();
FillColumns();
}
public frmIncassoInhoud2(DataAdapters da)
{
#region Initialize
InitializeComponent();
_windowState = new PersistWindowState(this, @"Leden\IncassoInhoud");
RekeningenLijst r = da.VulRekeningRecords();
param = new tblParameters();
var reks = from rek in r where !rek.Verstuurd && rek.Lid.IsIncasso orderby rek.AanmaakDatum select rek;
// het gebruik van rekeningen geeft een cast error! Daarom maar reks
// weer een mooie Linq. Alleen de OrderBy heeft waarschijnlijk ruzie met grouping van OLV
InitializeDataListView(olvVCard);
#endregion
#region Create Columns
OLVColumn colNaam = new OLVColumn("Naam", "Naam");
OLVColumn colDatum = new OLVColumn("Datum", "Datum");
OLVColumn dlvc03 = new OLVColumn("Omschrijving", "Omschrijving");
OLVColumn colBedrag = new OLVColumn("Bedrag", "TotaalBedrag");
OLVColumn colSeq = new OLVColumn("IncSeq", "Inc Seq");
OLVColumn colType = new OLVColumn("Type", "TypeRekening");
colNaam.Width = 170;
colBedrag.Width = 70;
dlvc03.Width = 210;
colDatum.Width = 90;
colSeq.Width = 50;
colType.Width = 90;
colNaam.UseInitialLetterForGroup = true;
colBedrag.UseInitialLetterForGroup = true;
colBedrag.AspectToStringFormat = "{0:C}";
colBedrag.TextAlign = HorizontalAlignment.Right;
// dlvc03.UseInitialLetterForGroup = true;
colDatum.Sortable = true;
colDatum.TextAlign = HorizontalAlignment.Right;
colDatum.UseInitialLetterForGroup = true;
colSeq.UseInitialLetterForGroup = true;
colType.UseInitialLetterForGroup = true;
olvVCard.Columns.Add(colType);
olvVCard.Columns.Add(colNaam);
olvVCard.Columns.Add(colSeq);
olvVCard.Columns.Add(dlvc03);
olvVCard.Columns.Add(colBedrag);
olvVCard.Columns.Add(colDatum);
colType.AspectGetter = delegate(object row)
{
if (((tblRekening)row).TypeRekening == 0)
{
return("Contributie");
}
return("Overig");
};
colNaam.AspectGetter = delegate(object row)
{
tblLid lid = ((tblRekening)row).Lid;
if (lid != null)
{
return(lid.VolledigeNaam);
}
return(string.Empty);
};
colSeq.AspectGetter = delegate(object row)
{
tblLid lid = ((tblRekening)row).Lid;
if (lid != null)
{
if (lid.Geincasseerd)
{
return("RCUR");
}
else
{
return("FRST");
}
}
return(string.Empty);
};
colDatum.AspectGetter = delegate(object row)
{
return(((tblRekening)row).AanmaakDatum.ToShortDateString());
};
#endregion
olvVCard.SecondarySortColumn = colDatum;
olvVCard.SetObjects(reks);
}
public frmCompareNAS(DataAdapters da)
{
InitializeComponent();
dataAdaptor = da;
param = new tblParameters();
leden = da.VulLedenLijst();
_windowState = new PersistWindowState(this, @"Leden\CompareNAS");
PersistControlValue.ReadControlValue(txtNASteamindeling);
PersistControlValue.ReadControlValue(txtNASLeden);
#region Create Columns
DataGridViewColumn dgvc0 = new DataGridViewTextBoxColumn();
dgvc0.Name = "Bondsnummer";
dgvc0.Width = 70;
dgvc0.ReadOnly = true;
dgvc0.SortMode = DataGridViewColumnSortMode.Automatic;
DataGridViewColumn dgvc1 = new DataGridViewTextBoxColumn();
dgvc1.Name = "Naam";
dgvc1.Width = 180;
dgvc1.ReadOnly = true;
dgvc1.SortMode = DataGridViewColumnSortMode.Automatic;
DataGridViewColumn dgvc2 = new DataGridViewCheckBoxColumn();
dgvc2.Name = "CG NAS";
dgvc2.Width = 60;
dgvc2.ReadOnly = true;
dgvc2.SortMode = DataGridViewColumnSortMode.Automatic;
DataGridViewColumn dgvc3 = new DataGridViewCheckBoxColumn();
dgvc3.Name = "CG Admin";
dgvc3.Width = 60;
dgvc3.ReadOnly = false;
dgvc3.SortMode = DataGridViewColumnSortMode.Automatic;
DataGridViewColumn dgvc4 = new DataGridViewCheckBoxColumn();
dgvc4.Name = "Team NAS";
dgvc4.Width = 60;
dgvc4.ReadOnly = true;
dgvc4.SortMode = DataGridViewColumnSortMode.Automatic;
DataGridViewColumn dgvc5 = new DataGridViewCheckBoxColumn();
dgvc5.Name = "LB Admin";
dgvc5.Width = 60;
dgvc5.ReadOnly = false;
dgvc5.SortMode = DataGridViewColumnSortMode.Automatic;
DataGridViewColumn dgvc6 = new DataGridViewCheckBoxColumn();
dgvc6.Name = "LB NAS";
dgvc6.Width = 60;
dgvc6.ReadOnly = true;
dgvc6.SortMode = DataGridViewColumnSortMode.Automatic;
DataGridViewColumn dgvc7 = new DataGridViewCheckBoxColumn();
dgvc7.Name = "Niet in Admin";
dgvc7.Width = 60;
dgvc7.ReadOnly = true;
dgvc7.SortMode = DataGridViewColumnSortMode.Automatic;
DataGridViewColumn dgvc8 = new DataGridViewTextBoxColumn();
dgvc8.Name = "Lic Admin";
dgvc8.Width = 60;
dgvc8.ReadOnly = false;
dgvc8.SortMode = DataGridViewColumnSortMode.Automatic;
DataGridViewColumn dgvc9 = new DataGridViewTextBoxColumn();
dgvc9.Name = "Lic NAS";
dgvc9.Width = 60;
dgvc9.ReadOnly = true;
dgvc9.SortMode = DataGridViewColumnSortMode.Automatic;
DataGridViewColumn dgvc10 = new DataGridViewTextBoxColumn();
dgvc10.Name = "Email NAS";
dgvc10.Width = 180;
dgvc10.ReadOnly = true;
dgvc10.SortMode = DataGridViewColumnSortMode.Automatic;
dgView.Columns.AddRange(new DataGridViewColumn[] { dgvc0, dgvc1, dgvc2, dgvc3, dgvc4, dgvc5, dgvc6, dgvc7, dgvc8, dgvc9, dgvc10 });
dgView.ReadOnly = false;
pnlGrid.Width = 930;
#endregion
InitializeDataGridView(dgView);
CreateRows();
//trigger the updates vanuit de tekstvelden om de eerste vergelijking te maken
txtNASLeden_TextChanged(this, new EventArgs());
txtNASteamindeling_TextChanged(this, new EventArgs());
// activeer de eventhandlers
dgView.CellValueChanged += new System.Windows.Forms.DataGridViewCellEventHandler(dgView_CellValueChanged);
txtNASLeden.TextChanged += new System.EventHandler(txtNASLeden_TextChanged);
txtNASteamindeling.TextChanged += new System.EventHandler(txtNASteamindeling_TextChanged);
dgView.CurrentCellDirtyStateChanged += new System.EventHandler(dgView_CurrentCellDirtyStateChanged);
}
public frmEenmaligeBetaling(DataAdapters da)
{
InitializeComponent();
param = new tblParameters();
dataAdaptor = da;
betalingen = da.VulBetalingRecords();
_windowState = new PersistWindowState(this, @"Leden\EenmaligeBetaling");
PersistControlValue.ReadControlValue(chkFilter);
SetChangeMode(false);
cboTypeRekening.Items.AddRange(tblBetaling.BetalingTypeDescriptions);
InitializeDataListView(olvBetalingen);
#region Create Columns
OLVColumn colNaam = new OLVColumn("Naam", "Crediteur");
OLVColumn colDatum = new OLVColumn("Datum", "AanmaakDatum");
OLVColumn dlvc03 = new OLVColumn("Omschrijving", "Omschrijving");
OLVColumn dlvc04 = new OLVColumn("End To End Id", "EndToEndId");
OLVColumn colBedrag = new OLVColumn("Bedrag", "TotaalBedrag");
OLVColumn colType = new OLVColumn("Type", "TypeBetaling");
OLVColumn colVerwerkingsDatum = new OLVColumn("Verw, Datun", "GewensteVerwerkingsDatum");
colNaam.Width = 140;
colDatum.Width = 90;
dlvc03.Width = 200;
dlvc04.Width = 130;
colBedrag.Width = 70;
colType.Width = 70;
colVerwerkingsDatum.Width = 90;
colNaam.UseInitialLetterForGroup = true;
colBedrag.UseInitialLetterForGroup = true;
colBedrag.AspectToStringFormat = "{0:C}";
colBedrag.TextAlign = HorizontalAlignment.Right;
// dlvc03.UseInitialLetterForGroup = true;
colDatum.Sortable = true;
colDatum.TextAlign = HorizontalAlignment.Right;
colDatum.UseInitialLetterForGroup = true;
colVerwerkingsDatum.Sortable = true;
colVerwerkingsDatum.TextAlign = HorizontalAlignment.Right;
colVerwerkingsDatum.UseInitialLetterForGroup = true;
colType.UseInitialLetterForGroup = true;
olvBetalingen.Columns.Add(colType);
olvBetalingen.Columns.Add(colNaam);
olvBetalingen.Columns.Add(dlvc03);
olvBetalingen.Columns.Add(dlvc04);
olvBetalingen.Columns.Add(colBedrag);
olvBetalingen.Columns.Add(colDatum);
olvBetalingen.Columns.Add(colVerwerkingsDatum);
colType.AspectGetter = delegate(object row)
{
if (((tblBetaling)row).TypeBetaling == 0)
{
return("Overig");
}
return("Overig"); // Voor het geval er nog meer komen :o)
};
colDatum.AspectGetter = delegate(object row)
{
return(((tblBetaling)row).AanmaakDatum.ToShortDateString());
};
colVerwerkingsDatum.AspectGetter = delegate(object row)
{
return(((tblBetaling)row).GewensteVerwerkingsDatum.ToShortDateString());
};
dlvc04.AspectGetter = delegate(object row)
{
return(((tblBetaling)row).FormattedEndToEndId);
};
#endregion
olvBetalingen.SetObjects(betalingen);
#region Vul Crediteuren
LedenLijst leden = da.VulLedenLijst();
CrediteurenLijst crediteuren = da.VulCrediteurenRecords();
foreach (tblCrediteur cred in crediteuren)
{
cboCrediteur.AddRecord(cred.Naam, cred);
}
foreach (tblLid lid in leden)
{
if (lid.IsIncasso)
{
cboCrediteur.AddRecord(lid.VolledigeNaam, lid);
}
}
cboCrediteur.First();
#endregion
// Show the first
//if (betalingen.Count > 0)
// olvBetalingen.Items[0].Selected = true;
//else
// CmdNew_Click(this, null); // Waarom werkt dit niet: CmdNew.PerformClick();
}
public frmSnelInvoeren(DataAdapters da)
{
InitializeComponent();
this.da = da;
#region Create Controls
lblNaamSpeler = new Label[maxNbrSpelers];
txtGespeeld = new TextBox[maxNbrSpelers];
txtGewonnen = new TextBox[maxNbrSpelers];
int beginHoogte = 190;
int controlSpace = 2;
for (int y = 0; y < maxNbrSpelers; y++)
{
#region Create all dynamic control)
lblNaamSpeler[y] = new Label(); // Voeg ik runtime toe
this.Controls.Add(this.lblNaamSpeler[y]);
lblNaamSpeler[y].Location = new System.Drawing.Point(10, beginHoogte + controlHeight + controlSpace);
lblNaamSpeler[y].Size = new System.Drawing.Size(120, controlHeight);
lblNaamSpeler[y].Name = "lblNaamSpeler" + y.ToString();
lblNaamSpeler[y].CausesValidation = true;
lblNaamSpeler[y].Visible = false;
lblNaamSpeler[y].Text = "Spelers " + y.ToString();
txtGespeeld[y] = new TextBox();
txtGewonnen[y] = new TextBox();
this.Controls.Add(txtGespeeld[y]);
this.Controls.Add(txtGewonnen[y]);
txtGespeeld[y].Location = new System.Drawing.Point((lblNaamSpeler[y].Right + 10), beginHoogte + controlHeight + controlSpace);
txtGespeeld[y].Size = new System.Drawing.Size(16, controlHeight);
txtGespeeld[y].Name = "Gespeeld" + y.ToString();
txtGespeeld[y].MaxLength = 1;
txtGespeeld[y].ReadOnly = false;
txtGespeeld[y].TextAlign = HorizontalAlignment.Center;
txtGespeeld[y].TabIndex = y;
txtGespeeld[y].Visible = false;
txtGespeeld[y].CausesValidation = true;
txtGespeeld[y].BorderStyle = BorderStyle.None;
txtGespeeld[y].TabStop = false;
txtGespeeld[y].MouseDown += new System.Windows.Forms.MouseEventHandler(this.SelectAll_MouseDown);
txtGespeeld[y].Enter += new System.EventHandler(this.SelectAll_Enter);
txtGespeeld[y].KeyDown += new System.Windows.Forms.KeyEventHandler(this.txtGespeeld_KeyDown);
txtGespeeld[y].KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.NumericCheck_KeyPress);
txtGespeeld[y].Validating += new System.ComponentModel.CancelEventHandler(textBox_Validating);
txtGespeeld[y].BackColor = System.Drawing.SystemColors.Control;
txtGewonnen[y].Location = new System.Drawing.Point(txtGespeeld[y].Right + 10, beginHoogte + controlHeight + controlSpace);
txtGewonnen[y].Size = new System.Drawing.Size(16, controlHeight);
txtGewonnen[y].Name = "Gewonnen" + y.ToString();
txtGewonnen[y].MaxLength = 1;
txtGewonnen[y].ReadOnly = false;
txtGewonnen[y].TextAlign = HorizontalAlignment.Center;
txtGewonnen[y].TabIndex = y + 2;
txtGewonnen[y].TabStop = true;
txtGewonnen[y].Visible = false;
txtGewonnen[y].CausesValidation = true;
txtGewonnen[y].BorderStyle = BorderStyle.None;;
txtGewonnen[y].Text = string.Empty;
txtGewonnen[y].MouseDown += new System.Windows.Forms.MouseEventHandler(this.SelectAll_MouseDown);
txtGewonnen[y].Enter += new System.EventHandler(this.SelectAll_Enter);
txtGewonnen[y].KeyDown += new System.Windows.Forms.KeyEventHandler(this.txtGewonnen_KeyDown);
txtGewonnen[y].KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.NumericCheck_KeyPress);
txtGewonnen[y].Validating += new System.ComponentModel.CancelEventHandler(textBox_Validating);
beginHoogte += (controlSpace + controlHeight);
#endregion
}
#endregion
GuiRoutines.SetFlatStyle(this.Controls);
m_windowState = new PersistWindowState(this, @"Stand\SnelInvoeren");
}
public frmCrediteuren(DataAdapters da)
{
#region Initialize
InitializeComponent();
_windowState = new PersistWindowState(this, @"Leden\Crediteuren");
dataAdaptor = da;
param = new tblParameters();
crediteuren = da.VulCrediteurenRecords();
InitializeDataListView(olvVCard);
PersistControlValue.ReadControlValue(txtOutputLocation);
#endregion
#region Create Columns
// OLVColumn dlvc01 = new OLVColumn("Crediteuren ID", "Crediteur");
OLVColumn dlvc02 = new OLVColumn("Naam", "Naam");
OLVColumn dlvc03 = new OLVColumn("IBAN", "IBAN");
OLVColumn dlvc04 = new OLVColumn("BIC", "BIC");
OLVColumn colOmschrijving = new OLVColumn("Omschrijving", "Omschrijving");
// dlvc01.Width = 90;
dlvc02.Width = 150;
dlvc03.Width = 140;
dlvc04.Width = 100;
colOmschrijving.Width = 200;
// dlvc01.UseInitialLetterForGroup = true;
dlvc02.UseInitialLetterForGroup = true;
dlvc03.UseInitialLetterForGroup = true;
dlvc04.UseInitialLetterForGroup = true;
colOmschrijving.UseInitialLetterForGroup = false;
dlvc04.IsEditable = false;
// olvVCard.Columns.Add(dlvc01);
olvVCard.Columns.Add(dlvc02);
olvVCard.Columns.Add(dlvc03);
olvVCard.Columns.Add(dlvc04);
olvVCard.Columns.Add(colOmschrijving);
dlvc02.AspectPutter = delegate(object row, object newValue)
{
((tblCrediteur)row).Naam = (string)newValue;
};
dlvc03.AspectPutter = delegate(object row, object newValue)
{
((tblCrediteur)row).IBAN = (string)newValue;
};
colOmschrijving.AspectPutter = delegate(object row, object newValue)
{
((tblCrediteur)row).Omschrijving = (string)newValue;
};
//dlvc02.AspectGetter = delegate(object row)
//{
// VCard2 vc = (VCard2)row;
// return vc.Voornaam + " " + (vc.Tussen != string.Empty ? vc.Tussen + " " : string.Empty) + vc.Achternaam + "\n" + "twee";
//};
#endregion
olvVCard.SetObjects(crediteuren);
}
private void TmrStartupTick(object sender, EventArgs e)
{
_tmrStartup.Stop();
StopAndStartServer();
iSpyServer.Default.Subscribed = false;
if (iSpyServer.Default.Enable_Update_Check && !SilentStartup)
{
CheckForUpdates(true);
}
if (SilentStartup)
{
_mWindowState = new PersistWindowState {Parent = this, RegistryPath = @"Software\ispyserver\startup"};
// set registry path in HKEY_CURRENT_USER
}
SilentStartup = false;
_tsslStats.Text = "OK";
_tmrStartup.Dispose();
}
public MainForm(bool silent, string loadFile)
{
SilentStartup = silent;
if (!SilentStartup)
{
_mWindowState = new PersistWindowState();
_mWindowState.Parent = this;
// set registry path in HKEY_CURRENT_USER
_mWindowState.RegistryPath = @"Software\ispy\startup";
}
//
// Required for Windows Form Designer support
//
InitializeComponent();
RenderResources();
LoadFile = Program.AppPath + @"XML\objects.xml";
if (loadFile != "")
LoadFile = loadFile;
_toolStrip1.Renderer = new WindowsVistaRenderer();
_pnlCameras.BackColor = iSpyServer.Default.MainColor;
if (SilentStartup)
{
ShowInTaskbar = false;
ShowIcon = false;
WindowState = FormWindowState.Minimized;
}
}
public frmVCard(object l)
{
#region Initialize
InitializeComponent();
_windowState = new PersistWindowState(this, @"Leden\ExportVCard");
param = new tblParameters();
if (l is DataAdapters)
{
leden = ((DataAdapters)l).VulLedenLijst();
}
if (l is LedenLijst)
{
leden = (LedenLijst)l;
}
objVCardList = new List <VCard2>();
InitializeDataListView(olvVCard);
PersistControlValue.ReadControlValue(txtOutputLocation);
#endregion
#region Create Columns
int lTel = 85;
int lMail = 180;
OLVColumn dlvc01 = new OLVColumn("Achternaam", "Achternaam");
OLVColumn dlvc02 = new OLVColumn("Voornaam", "Voornaam");
OLVColumn dlvc03 = new OLVColumn("Tussen", "Tussen");
OLVColumn dlvc04 = new OLVColumn("Titel", "Titel");
OLVColumn ColumnOrganisatie = new OLVColumn("Organisatie", "Organisatie");
OLVColumn dlvc06 = new OLVColumn("TelThuis", "TelThuis");
OLVColumn dlvc07 = new OLVColumn("Mobiel1", "Mobiel1");
OLVColumn dlvc08 = new OLVColumn("Mobiel2", "Mobiel2");
OLVColumn dlvc09 = new OLVColumn("TelWerk", "TelWerk");
OLVColumn dlvc10 = new OLVColumn("Email1", "Email1");
OLVColumn dlvc11 = new OLVColumn("Email2", "Email2");
OLVColumn dlvc12 = new OLVColumn("Adres", "Adres");
OLVColumn dlvc13 = new OLVColumn("Postcode", "Postcode");
OLVColumn dlvc14 = new OLVColumn("Woonplaats", "Woonplaats");
OLVColumn dlvc15 = new OLVColumn("Notitie", "Notitie");
OLVColumn dlvc16 = new OLVColumn("Lid", "Lid");
dlvc01.Width = 90;
dlvc02.Width = 120;
dlvc03.Width = 30;
dlvc04.Width = 60;
ColumnOrganisatie.Width = 60;
dlvc06.Width = dlvc07.Width = dlvc08.Width = dlvc09.Width = lTel;
dlvc10.Width = dlvc11.Width = lMail;
dlvc12.Width = 60;
dlvc13.Width = 60;
dlvc14.Width = 60;
dlvc15.Width = 180;
dlvc16.Width = 60;
dlvc01.UseInitialLetterForGroup = true;
dlvc02.UseInitialLetterForGroup = true;
dlvc03.UseInitialLetterForGroup = true;
dlvc04.UseInitialLetterForGroup = true;
ColumnOrganisatie.UseInitialLetterForGroup = false;
dlvc06.UseInitialLetterForGroup = true;
dlvc07.UseInitialLetterForGroup = true;
dlvc08.UseInitialLetterForGroup = true;
dlvc09.UseInitialLetterForGroup = true;
dlvc10.UseInitialLetterForGroup = true;
dlvc11.UseInitialLetterForGroup = true;
dlvc12.UseInitialLetterForGroup = true;
dlvc13.UseInitialLetterForGroup = true;
dlvc14.UseInitialLetterForGroup = true;
dlvc15.UseInitialLetterForGroup = true;
//dlvc16.CheckBoxes = true;
dlvc16.HeaderTextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc16.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc16.ToolTipText = "Is dit contact toegevoegd via Leden administratie?";
dlvc16.TriStateCheckBoxes = true;
//dlvc16.HeaderCheckBox = true;
olvVCard.Columns.Add(dlvc01);
olvVCard.Columns.Add(dlvc02);
olvVCard.Columns.Add(dlvc03);
olvVCard.Columns.Add(dlvc04);
olvVCard.Columns.Add(ColumnOrganisatie);
olvVCard.Columns.Add(dlvc06);
olvVCard.Columns.Add(dlvc07);
olvVCard.Columns.Add(dlvc08);
olvVCard.Columns.Add(dlvc09);
olvVCard.Columns.Add(dlvc10);
olvVCard.Columns.Add(dlvc11);
olvVCard.Columns.Add(dlvc12);
olvVCard.Columns.Add(dlvc13);
olvVCard.Columns.Add(dlvc14);
olvVCard.Columns.Add(dlvc15);
olvVCard.Columns.Add(dlvc16);
//dlvc02.AspectGetter = delegate(object row)
//{
// VCard2 vc = (VCard2)row;
// return vc.Voornaam + " " + (vc.Tussen != string.Empty ? vc.Tussen + " " : string.Empty) + vc.Achternaam + "\n" + "twee";
//};
#endregion
#region Inlezen XML met contactpersonen
contactFileNameXML = param.LocationTemplates + @"\ContactPersonen.xml";
if (contactFileNameXML != string.Empty)
{
try
{
using (StreamReader sr = File.OpenText(contactFileNameXML))
{
using (TextReader tr = new StringReader(sr.ReadToEnd()))
{
XmlSerializer s = new XmlSerializer(typeof(tblVCard));
vCardLijst = (tblVCard)s.Deserialize(tr);
}
}
foreach (VCard vCard in vCardLijst)
{
vCard.Dirty = true;
}
}
catch { }
if (vCardLijst == null)
{
vCardLijst = new tblVCard();
}
}
#endregion
OntdubbelvCardLijst();
CopyVCardListToLocal();
olvVCard.SetObjects(objVCardList);
}
public frmNotes()
{
InitializeComponent();
_windowState = new PersistWindowState(this, @"Leden\Notes");
PersistControlValue.ReadControlValue(richTextBox1);
}
public frmMultiMail(object lijst, tblParameters Param, object templateName, string subject, List <string> attachmentList, bool OnlyFinancialEmail)
{
InitializeComponent();
cmdGetMail.Visible = cmdSaveMail.Visible = false;
if (lijst == null)
{
return;
}
//param = new tblParameters();
param = Param;
// De schaduwlijst dient om bij ieder email adres in de checkbox een Lid object te hebben zodat we de keywords kunnen vervangen
ledenSchaduwlijst = new LedenLijst();
//mostRecentlyUsed = new MosaicMru(this, "Multimail");
//mostRecentlyUsed.ItemsSaveLimit = 10;
//mostRecentlyUsed.ItemsAreFiles = false;
//mostRecentlyUsed.BuildMenu(clbExtraEmail);
try
{
foreach (string s in param.mmtxtExtraEmail)
{
clbExtraEmail.Items.Add(s);
}
}
catch { }
_windowState = new PersistWindowState(this, @"Leden\Mail");
//txtExtraEmail.Text = PersistControlValue.ReadControlValue(txtExtraEmail);
chkLogEmail.Checked = param.LogEmail;
ckbDoNotSendEmail.Checked = param.DoNotSendEmail;
EmailLogFile = param.LocationLogFiles + @"\" + param.ClubNameShort + "_Mail_Logfile.txt";
if (!File.Exists(EmailLogFile))
{
File.Create(EmailLogFile);
}
#region Bouw Ledenlijst op
if (lijst.GetType() == typeof(LedenLijst))
{
leden = (LedenLijst)lijst;
}
if (lijst.GetType() == typeof(tblLid))
{
tblLid lid = (tblLid)lijst;
lid.Gemerkt = true;
leden = new LedenLijst(lid);
}
if (lijst.GetType() == typeof(List <EmailAdresLid>))
{
leden = new LedenLijst();
foreach (EmailAdresLid e in (List <EmailAdresLid>)lijst)
{
if (string.IsNullOrEmpty(e.EmailAddress.Trim()))
{
continue;
}
tblLid lid = new tblLid();
lid.Gemerkt = true;
lid.Email1 = e.EmailAddress;
leden.Add(lid);
}
}
if (lijst.GetType() == typeof(tblRekening))
{
tblRekening rekening = (tblRekening)lijst;
tblLid lid = rekening.Lid;
lid.Gemerkt = true;
leden = new LedenLijst(lid);
}
#endregion
try
{
foreach (tblLid lid in leden)
{
if (lid.Gemerkt)
{
AddEmailToComboAndShadow(lid, OnlyFinancialEmail);
}
}
#region templateName == null dus we gebruiken de laatste opgeslagen default
string body = string.Empty;
if (templateName == null)
{
mailFileName = PersistControlValue.ReadLocalAppSetting(@"Leden.Net", "LastUsedEmail");
cmdGetMail.Visible = cmdSaveMail.Visible = true;
if (mailFileName != string.Empty || !File.Exists(mailFileName))
{
StreamReader sr = File.OpenText(mailFileName);
StringReader str = new StringReader(sr.ReadToEnd());
body = htmlTextbox1.Text = str.ReadToEnd();
sr.Close();
sr.Dispose();
}
else
{
body = htmlTextbox1.Text = mailFileName + " not found";
}
return;
}
#endregion
#region TemplateNaam is ingevuld dus gaan we die gebruiken. igv lege string dan default mailtje
// Het type is een string dus gaan we uit van een templatenaam
if (templateName.GetType() == typeof(string))
{
if ((string)templateName == string.Empty)
{
htmlTextbox1.Text = "Beste " + param.ClubNameShort + "-er,<br><br>Met vriendelijke groet,<br>" + param.ClubNameShort;
return;
}
// we maken gebruik van een template voor de leden. bijv Upas mail
//Inlezen van de template
string fileNameTemplate = param.LocationTemplates + @"\Template_" + (string)templateName + ".htm";;
if (!File.Exists(fileNameTemplate))
{
MessageBox.Show("Template mail " + fileNameTemplate + " bestaat niet", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
StreamReader sr1 = File.OpenText(fileNameTemplate);
StringReader str1 = new StringReader(sr1.ReadToEnd());
htmlTextbox1.Text = str1.ReadToEnd();
}
#endregion
if (templateName.GetType() == typeof(BodyString))
{
htmlTextbox1.Text = (BodyString)templateName;
}
//Replace keywords
if (lijst.GetType() == typeof(tblLid))
{
tblLid lid = (tblLid)lijst;
htmlTextbox1.Text = MailRoutines.ReplaceKeyWords(htmlTextbox1.Text, lid, param);
}
if (lijst.GetType() == typeof(tblRekening))
{
tblRekening rekening = (tblRekening)lijst;
htmlTextbox1.Text = MailRoutines.ReplaceKeyWords(htmlTextbox1.Text, rekening, param);
}
#region Subject en Attachments
txtSubject.Text = (subject != null ? subject : string.Empty);
if (attachmentList != null)
{
for (int i = 0; i < attachmentList.Count && i < 3; i++)
{
if (i == 0 && attachmentList[i] != string.Empty)
{
txtBijlage1.Text = attachmentList[i];
}
if (i == 1 && attachmentList[i] != string.Empty)
{
txtBijlage2.Text = attachmentList[i];
}
if (i == 2 && attachmentList[i] != string.Empty)
{
txtBijlage3.Text = attachmentList[i];
}
}
}
#endregion
}
catch { }
}
public MainForm()
{
InitializeComponent();
persistState = new PersistWindowState(registryPath, this);
}
public frmLedenOverzicht1(DataAdapters da, tblParameters.LedenLijstType lijstType)
{
InitializeComponent();
leden = da.VulLedenLijst();
dataAdaptor = da;
param = new tblParameters();
InitializeDataListView(olvVrijwilligers);
#region Create Columns
OLVColumn dlvc01 = new OLVColumn("Naam", "VolledigeNaam");
// vrijwilligers
OLVColumn dlvc02 = new OLVColumn("Regeling Toepassen", "VrijwillgersRegelingIsVanToepassing");
OLVColumn dlvc03 = new OLVColumn("Afgekocht", "VrijwillgersAfgekocht");
OLVColumn dlvc04 = new OLVColumn("Vaste Vrijwilliger", "VrijwillgersVasteTaak");
//OLVColumn dlvc05 = new OLVColumn("Uitgevoerd", "VrijwillgersTaakUitgevoerd");
OLVColumn dlvc06 = new OLVColumn("Toelichting", "VrijwillgersToelichting");
// Toernooien
OLVColumn dlvc12 = new OLVColumn("Ranglijst", "IsRanglijstSpeler");
OLVColumn dlvc13 = new OLVColumn("Toernooi", "IsToernooiSpeler");
OLVColumn dlvc14 = new OLVColumn("LB", "LidBond");
OLVColumn dlvc15 = new OLVColumn("CG", "CompGerechtigd");
dlvc01.Width = 180;
dlvc02.Width = 60;
dlvc03.Width = 60;
dlvc04.Width = 60;
//dlvc05.Width = 60;
dlvc06.Width = 180;
dlvc12.Width = 60;
dlvc13.Width = 60;
dlvc14.Width = 60;
dlvc15.Width = 60;
//dlvc01.UseInitialLetterForGroup = true;
//dlvc02.UseInitialLetterForGroup = true;
//dlvc03.UseInitialLetterForGroup = true;
//dlvc04.UseInitialLetterForGroup = true;
//dlvc05.UseInitialLetterForGroup = true;
//dlvc06.UseInitialLetterForGroup = true;
dlvc02.CheckBoxes = true;
dlvc03.CheckBoxes = true;
dlvc04.CheckBoxes = true;
//dlvc05.CheckBoxes = true;
dlvc12.CheckBoxes = true;
dlvc13.CheckBoxes = true;
dlvc14.CheckBoxes = true;
dlvc15.CheckBoxes = true;
dlvc02.HeaderTextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc02.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc03.HeaderTextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc03.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc04.HeaderTextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc04.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
//dlvc05.HeaderTextAlign = System.Windows.Forms.HorizontalAlignment.Center;
//dlvc05.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc12.HeaderTextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc12.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc13.HeaderTextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc13.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc14.HeaderTextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc14.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc15.HeaderTextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc15.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
//dlvc16.CheckBoxes = true;
//dlvc16.HeaderTextAlign = System.Windows.Forms.HorizontalAlignment.Center;
//dlvc16.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
//dlvc16.ToolTipText = "Is dit contact toegevoegd via Leden administratie?";
//dlvc16.TriStateCheckBoxes = true;
//dlvc16.HeaderCheckBox = true;
if (lijstType == tblParameters.LedenLijstType.Vrijwilligers)
{
olvVrijwilligers.Columns.Add(dlvc01);
olvVrijwilligers.Columns.Add(dlvc02);
olvVrijwilligers.Columns.Add(dlvc03);
olvVrijwilligers.Columns.Add(dlvc04);
//olvVrijwilligers.Columns.Add(dlvc05);
olvVrijwilligers.Columns.Add(dlvc06);
pnlGrid.Width = 561;
this.Text = "Vrijwilligers Overzicht";
}
else if (lijstType == tblParameters.LedenLijstType.Toernooien)
{
olvVrijwilligers.Columns.Add(dlvc01);
olvVrijwilligers.Columns.Add(dlvc12);
olvVrijwilligers.Columns.Add(dlvc13);
olvVrijwilligers.Columns.Add(dlvc14);
olvVrijwilligers.Columns.Add(dlvc15);
this.Text = "Toernooi Overzicht";
pnlGrid.Width = 441;
}
else if (lijstType == tblParameters.LedenLijstType.Selected)
{
dlvc01.Width = 600;
olvVrijwilligers.Columns.Add(dlvc01);
this.Text = "Leden Overzicht";
pnlGrid.Width = 621;
}
else
{
return;
}
#endregion
olvVrijwilligers.SetObjects(leden);
olvVrijwilligers.ModelFilter = new FilterSelectSenOrJun(rbuSenioren.Checked);
_windowState = new PersistWindowState(this, @"Leden\LedenOverzicht");
}
public frmRekeningOverzicht2(DataAdapters da, object l)
{
InitializeComponent();
param = new tblParameters();
dataAdaptor = da;
_windowState = new PersistWindowState(this, @"Leden\RekeningOverzicht");
PersistControlValue.ReadControlValue(txtStornoKosten);
rduStornoBrief.Checked = true;
SetChangeMode(false);
cboTypeRekening.Items.AddRange(tblRekening.RekeningTypeDescriptions);
InitializeDataListView(olvRekeningen);
#region Create Columns
OLVColumn dlvc00 = new OLVColumn("Nr", "RekeningSeqNr");
OLVColumn dlvc01 = new OLVColumn("Datum", "AanmaakDatum");
OLVColumn dlvc02 = new OLVColumn("Verstuurd", "Verstuurd");
OLVColumn dlvc03 = new OLVColumn("Storno", "Gestorneerd");
OLVColumn dlvc04 = new OLVColumn("Omschrijving", "Omschrijving");
OLVColumn dlvc05 = new OLVColumn("Bedrag", "TotaalBedrag");
dlvc00.Width = 30;
dlvc01.Width = 70;
dlvc02.Width = 30;
dlvc03.Width = 30;
dlvc04.Width = 300;
dlvc05.Width = 60;
dlvc00.UseInitialLetterForGroup = true;
dlvc00.HeaderTextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc00.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
//
dlvc01.UseInitialLetterForGroup = true;
dlvc01.AspectGetter = delegate(object row)
{
return(((tblRekening)row).AanmaakDatum.ToShortDateString());
};
//
dlvc02.UseInitialLetterForGroup = true;
dlvc02.CheckBoxes = false;
dlvc02.IsEditable = false;
dlvc02.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc02.AspectGetter = delegate(object row)
{
if (((tblRekening)row).Verstuurd)
{
return("Verstuurd");
}
return("");
};
dlvc02.Renderer = new MappedImageRenderer(new Object[] { "Verstuurd", Resources.tick16 });
//
dlvc03.UseInitialLetterForGroup = true;
dlvc03.CheckBoxes = true;
dlvc03.IsEditable = false;
dlvc03.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
dlvc03.AspectGetter = delegate(object row)
{
if (((tblRekening)row).Gestorneerd)
{
return("Gestorneerd");
}
return("");
};
dlvc03.Renderer = new MappedImageRenderer(new Object[] { "Gestorneerd", Resources.star16 });
//
dlvc04.UseInitialLetterForGroup = true;
dlvc05.UseInitialLetterForGroup = true;
dlvc05.AspectToStringFormat = "{0:C}";
dlvc05.TextAlign = HorizontalAlignment.Right;
//dlvc16.CheckBoxes = true;
//dlvc16.HeaderTextAlign = System.Windows.Forms.HorizontalAlignment.Center;
//dlvc16.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
//dlvc16.ToolTipText = "Is dit contact toegevoegd via Leden administratie?";
olvRekeningen.Columns.Add(dlvc00);
olvRekeningen.Columns.Add(dlvc01);
olvRekeningen.Columns.Add(dlvc02);
olvRekeningen.Columns.Add(dlvc03);
olvRekeningen.Columns.Add(dlvc04);
olvRekeningen.Columns.Add(dlvc05);
#endregion
rekeningen = da.VulRekeningRecords();
ReportRoutines.CreateRekeningingenReport("Aangemaakte contributie rekeningen", rekeningen, @"D:\temp\zz.csv", true);
if (l is tblLid)
{
leden = new LedenLijst();
tblLid lid = (tblLid)l;
leden.Add(lid);
lboLeden.Items.Add(lid.VolledigeNaam);
}
if (l is LedenLijst)
{
leden = (LedenLijst)l;
foreach (tblLid lid in leden)
{
lboLeden.Items.Add(lid.VolledigeNaam);
}
}
lboLeden.SelectedIndex = 0;
olvRekeningen.SetObjects(rekeningen);
lboLeden_SelectedIndexChanged(this, null);
lboLeden.Focus();
}
public frmBetalingInhoud(DataAdapters da)
{
#region Initialize
InitializeComponent();
_windowState = new PersistWindowState(this, @"Leden\BetalingInhoud");
localRekeningen = da.VulBetalingRecords();
param = new tblParameters();
var reks = from rek in localRekeningen where !rek.Verstuurd orderby rek.AanmaakDatum select rek;
// het gebruik van rekeningen geeft een cast error! Daarom maar reks
// weer een mooie Linq. Alleen de OrderBy heeft waarschijnlijk ruzie met grouping van OLV
InitializeDataListView(olvVCard);
#endregion
#region Create Columns
OLVColumn colNaam = new OLVColumn("Naam", "IBAN_Creditor");
OLVColumn colDatum = new OLVColumn("Datum", "AanmaakDatum");
OLVColumn dlvc03 = new OLVColumn("Omschrijving", "Omschrijving");
OLVColumn dlvc04 = new OLVColumn("End To End Id", "EndToEndId");
OLVColumn colBedrag = new OLVColumn("Bedrag", "TotaalBedrag");
OLVColumn colType = new OLVColumn("Type", "TypeBetaling");
OLVColumn colVerwerkingsDatum = new OLVColumn("Verw, Datun", "GewensteVerwerkingsDatum");
colNaam.Width = 170;
colDatum.Width = 90;
dlvc03.Width = 210;
dlvc04.Width = 150;
colBedrag.Width = 70;
colType.Width = 90;
colVerwerkingsDatum.Width = 90;
colNaam.UseInitialLetterForGroup = true;
colBedrag.UseInitialLetterForGroup = true;
colBedrag.AspectToStringFormat = "{0:C}";
colBedrag.TextAlign = HorizontalAlignment.Right;
// dlvc03.UseInitialLetterForGroup = true;
colDatum.Sortable = true;
colDatum.TextAlign = HorizontalAlignment.Right;
colDatum.UseInitialLetterForGroup = true;
colVerwerkingsDatum.Sortable = true;
colVerwerkingsDatum.TextAlign = HorizontalAlignment.Right;
colVerwerkingsDatum.UseInitialLetterForGroup = true;
colType.UseInitialLetterForGroup = true;
olvVCard.Columns.Add(colType);
olvVCard.Columns.Add(colNaam);
olvVCard.Columns.Add(dlvc03);
olvVCard.Columns.Add(dlvc04);
olvVCard.Columns.Add(colBedrag);
olvVCard.Columns.Add(colDatum);
olvVCard.Columns.Add(colVerwerkingsDatum);
colType.AspectGetter = delegate(object row)
{
if (((tblBetaling)row).TypeBetaling == 0)
{
return("Overig");
}
return("Overig"); // Voor het geval er nog meer komen :o)
};
colDatum.AspectGetter = delegate(object row)
{
return(((tblBetaling)row).AanmaakDatum.ToShortDateString());
};
colVerwerkingsDatum.AspectGetter = delegate(object row)
{
return(((tblBetaling)row).GewensteVerwerkingsDatum.ToShortDateString());
};
#endregion
olvVCard.SecondarySortColumn = colDatum;
olvVCard.SetObjects(reks);
}
