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 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 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 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 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 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 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);
}