private DataGridViewRow CreateRow(DataGridView dgv)
{
try
{
dgv.Rows.Add();
DataGridViewRow r = dgv.Rows[dgv.RowCount - 1];
r.Cells["Bondsnummer"].Value = "Onbekend";
r.Cells["Naam"].Value = "Onbekend";
r.Cells["CG Admin"].Value = false;
r.Cells["LB Admin"].Value = false;
r.Cells["Lic Admin"].Value = string.Empty;
r.Cells["Team NAS"].Value = false;
r.Cells["CG NAS"].Value = false;
r.Cells["LB NAS"].Value = false;
r.Cells["Lic NAS"].Value = string.Empty;
r.Cells["Email NAS"].Value = string.Empty;
r.Cells["Niet in Admin"].Value = false;
r.Height = 18;
return(r);
}
catch (Exception ex)
{
GuiRoutines.ShowMessage(ex);
return(null);
}
}
private void CreateRows()
{
try
{
dgView.Rows.Clear();
dgView.AllowUserToResizeRows = false;
foreach (tblLid lid in leden)
{
DataGridViewRow r = CreateRow(dgView);
r.Cells["Bondsnummer"].Value = lid.BondsNr;
r.Cells["Naam"].Value = lid.VolledigeNaam;
r.Cells["CG Admin"].Value = lid.CompGerechtigd;
r.Cells["LB Admin"].Value = lid.LidBond;
r.Cells["Lic Admin"].Value = lid.LicentieJun.Trim() + lid.LicentieSen.Trim();
r.Tag = lid;
r.ReadOnly = false;
}
}
catch (Exception ex)
{
GuiRoutines.ShowMessage(ex);
}
}
private void txtNASteamindeling_TextChanged(object sender, EventArgs e)
{
try
{
// We zetten alle cellen op false. nodig omdat er anders kans is een true op true blijft staan bij een wijziging
disableEventCellUpdate = true;
foreach (DataGridViewRow r in dgView.Rows)
{
r.Cells["Team NAS"].Value = false;
r.Cells["Niet in Admin"].Value = false;
}
disableEventCellUpdate = false;
foreach (string s in txtNASteamindeling.Lines)
{
string line = s.Replace("\t", " ");
bool found = false;
if (line.Length < 8)
{
continue;
}
line = line.Substring(0, 8);
line = line.Trim();
if (line.IsNumeric())
{
foreach (DataGridViewRow r in dgView.Rows)
{
if (r.Cells["Bondsnummer"].Value.ToString() == line)
{
r.Cells["Team NAS"].Value = found = true;
}
}
// je hebt een bondsnr in de teamindeling gevonden die niet in je admin staat.
if (!found)
{
disableEventCellUpdate = true;
DataGridViewRow r = CreateRow(dgView);
r.Cells["Bondsnummer"].Value = line;
r.Cells["Team NAS"].Value = true;
r.Cells["Niet in Admin"].Value = true;
r.ReadOnly = true;
disableEventCellUpdate = false;
}
}
}
Compare();
}
catch (Exception ex)
{
GuiRoutines.ShowMessage(ex);
}
}
private void cmdShowLogfileMail_Click(object sender, EventArgs e)
{
try
{
StreamReader sr = new StreamReader(EmailLogFile);
GuiRoutines.ShowMessage(sr.ReadToEnd(), EmailLogFile);
sr.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmdOutput_Click(object sender, EventArgs e)
{
try
{
StreamReader sr = new StreamReader(reportFileName);
GuiRoutines.ShowMessage(sr.ReadToEnd(), reportFileName);
sr.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
try
{
dataAdaptor.UpdateLeden(leden);
dataAdaptor.CommitTransaction(true);
toolStripStatusLabel1.Text = "Bewaard";
}
catch (Exception ex)
{
GuiRoutines.ShowMessage(ex);
}
}
private void dgView_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
if (disableEventCellUpdate)
{
return;
}
DataGridViewRow row = ((DataGridView)sender).CurrentRow;
if (row.Tag != null)
{
try
{
tblLid lid = (tblLid)row.Tag;
lid.CompGerechtigd = (bool)row.Cells["CG Admin"].Value;
lid.LidBond = (bool)row.Cells["LB Admin"].Value;
lid.LicentieJun = lid.LicentieSen = string.Empty;
string l = (string)row.Cells["Lic Admin"].Value;
if (l != null)
{
l = l.Trim().ToUpper();
if (l.Length == 2)
{
if (!lid.Is_SEN1_65_SEN) // Alleen jun kunnen een dubbele licentie hebben
{
lid.LicentieJun = l.Substring(0, 1);
lid.LicentieSen = l.Substring(1, 1);
}
else
{
lid.LicentieJun = string.Empty;
lid.LicentieSen = l.Substring(1, 1);
}
}
else
if (lid.Is_SEN1_65_SEN)
{
lid.LicentieSen = l.Trim();
}
else
{
lid.LicentieJun = l.Trim();
}
}
Compare();
}
catch (Exception ex)
{
GuiRoutines.ShowMessage(ex);
}
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
try
{
dataAdaptor.UpdateCrediteuren(crediteuren);
dataAdaptor.CommitTransaction(true);
toolStripStatusLabel1.Text = "Bewaard";
}
catch (Exception ex)
{
GuiRoutines.ShowMessage(ex);
// MessageBox.Show("Er zijn nog openstaande rekeningen voor dit lid", "Waarschuwing", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public static tblCompResult CreateCompResultRecord(tblLid lid)
{
tblCompResult CompResult = new tblCompResult();
try
{
CompResult.LidNr = lid.LidNr;
CompResult.Lid = lid;
}
catch (Exception ex)
{
GuiRoutines.ShowMessage(ex);
}
return(CompResult);
}
public tblBetaling(BetalingenLijst Betalingen)
{
try
{
for (int i = 0; i < Betalingen.Count; i++)
{
if (Betalingen[i].BetalingsSeqNr > _BetalingsSeqNr)
{
_BetalingsSeqNr = Betalingen[i].BetalingsSeqNr;
}
}
_BetalingsSeqNr++;
}
catch (Exception ex)
{
GuiRoutines.ShowMessage(ex);
}
_IBAN_Creditor = string.Empty;
_BIC_Creditor = string.Empty;
_Omschrijving = string.Empty;
_EndToEndId = string.Empty;
_TotaalBedrag = 0;
_TypeBetaling = 0;
_AanmaakDatum = DateTime.Now;
_Verstuurd = false;
_VerstuurdDatum = DateTime.Now;
_GewensteVerwerkingsDatum = DateTime.Now;
_Extra1 = 0;
_Extra2 = 0;
_Extra3 = 0;
_Crediteur = string.Empty;
_ExtraB = string.Empty;
_ExtraC = string.Empty;
_isDirty = true;
Betalingen.Add(this);
}
public static tblRekening CreateRekeningRecord(tblLid lid, RekeningenLijst rekeningen)
{
tblRekening rekening = new tblRekening();
try
{
for (int i = 0; i < rekeningen.Count; i++)
{
if (rekeningen[i].RekeningSeqNr > rekening.RekeningSeqNr &&
rekeningen[i].LidNr == lid.LidNr)
{
rekening.RekeningSeqNr = rekeningen[i].RekeningSeqNr;
}
}
rekening.RekeningSeqNr++;
rekening.Lid = lid;
rekening.LidNr = lid.LidNr;
}
catch (Exception ex)
{
GuiRoutines.ShowMessage(ex);
}
return(rekening);
}
private tblCompResult ScrapeTTKaart(string bondsnummer, int jaar, string seizoen)
{
try
{
// Scrape the website
WebClient client = new WebClient();
//this is the important bit...
client.Headers.Add("User-Agent", "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.4) Gecko/20060508 Firefox/1.5.0.4");
client.Headers.Add("Accept-Language", "en-us,en;q=0.5");
//end of the important bit...
client.UseDefaultCredentials = true;
IWebProxy theProxy = client.Proxy;
if (theProxy != null)
{
theProxy.Credentials = CredentialCache.DefaultCredentials;
}
client.Proxy = WebRequest.DefaultWebProxy;
byte[] data = null;
try
{
string url = @"http://ttkaart.nl/spelers/" + bondsnummer + @"/";
data = client.DownloadData(url);
}
catch
{
//GuiRoutines.ShowMessage("Bondsnummer niet gevonden: " + bondsnummer);
return(null);
}
// Zet de byte-array om in een string
StringReader sr = new StringReader(Encoding.UTF8.GetString(data, 0, data.Length));
tblCompResult cr = null;
int j = 0;
string seiz = string.Empty;
string klasse = string.Empty;
string type = string.Empty;
int perc = 0;
HtmlTag tag;
HtmlParser parse = new HtmlParser(sr.ReadToEnd());
parse.ParseNext("tbody", out tag);
if (parse.ParseNext("tbody", out tag))
{
parse.ParseNext("td", out tag);
if (parse.ParseNext("td", out tag))
{
string s = parse.ParseTagValue();
j = int.Parse(s.Substring(0, 4));
seiz = s.Substring(6, 1).ToUpper();
}
parse.ParseNext("td", out tag); //Jeugd
type = parse.ParseTagValue();
parse.ParseNext("td", out tag); // Midden
if (parse.ParseNext("td", out tag))
{
if (parse.ParseNext("a", out tag))
{
klasse = parse.ParseTagValue().Substring(0, 11);
switch (klasse)
{
case "Kampioensgr": klasse = "K"; break;
case "Landelijk A": klasse = "A"; break;
case "Landelijk B": klasse = "B"; break;
case "Landelijk C": klasse = "C"; break;
case "Starterskla": klasse = "S"; break;
case "1e Divisie ": klasse = "1D"; break;
case "2e Divisie ": klasse = "2D"; break;
case "3e Divisie ": klasse = "3D"; break;
case "Duo 1e Klas": klasse = "D1"; break;
case "Duo 2e Klas": klasse = "D2"; break;
case "Duo 3e Klas": klasse = "D3"; break;
case "Duo 4e Klas": klasse = "D4"; break;
case "Duo 5e Klas": klasse = "D5"; break;
case "Duo 6e Klas": klasse = "D6"; break;
default:
if (klasse.Substring(0, 1).IsNumeric())
{
klasse = klasse.Substring(0, 1);
}
break;
}
;
}
}
parse.ParseNext("td", out tag); // Aantal wedstrijden
parse.ParseNext("td", out tag); // gewonnen
if (parse.ParseNext("td", out tag))
{
perc = int.Parse(parse.ParseTagValue());
}
if (j == jaar && seiz == seizoen)
{
cr = new tblCompResult();
cr.Klasse = klasse;
cr.Percentage = perc;
cr.CompetitieType = type;
}
}
return(cr);
}
catch (Exception ex)
{
GuiRoutines.ShowMessage(ex);
return(null);
}
}
private void txtNASLeden_TextChanged(object sender, EventArgs e)
{
try
{
// We zetten alle cellen op false. nodig omdat er anders kans is een true op true blijft staan bij een wijziging
disableEventCellUpdate = true;
foreach (DataGridViewRow r in dgView.Rows)
{
r.Cells["LB NAS"].Value = false;
r.Cells["CG NAS"].Value = false;
}
disableEventCellUpdate = false;
foreach (string s in txtNASLeden.Lines)
{
bool found = false;
string line = s.Replace("\t", " ");
string[] values = line.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
if (values.Length < 10)
{
continue;
}
string lic = string.Empty;
string email = string.Empty;
int zoeknaam = 0;
for (int i = 2; i < values.Length; i++)
{
string l = values[i];
if ((l == "A" || l == "B" || l == "C" || l == "D" || l == "E" || l == "F" || l == "G" || l == "H") && l.Length == 1)
{
lic += l;
}
if (values[i].Contains("@"))
{
email = values[i];
}
// Als er NAS een bondsnummer staat die niet in onze admin staat dan moeten we iets in de naam invullen
// De best guess is dat de naam diect na het geslacht komt
if (zoeknaam == 0 && (values[i] == "M" || values[i] == "V") && values[i].Length == 1)
{
zoeknaam = i + 1;
}
}
foreach (DataGridViewRow r in dgView.Rows)
{
if (r.Cells["Bondsnummer"].Value.ToString() == values[1])
{
r.Cells["LB NAS"].Value = found = true;
r.Cells["CG NAS"].Value = (values[2] == "J");
r.Cells["Lic NAS"].Value = lic;
r.Cells["Email NAS"].Value = email;
}
}
if (!found)
{
disableEventCellUpdate = true;
DataGridViewRow r = CreateRow(dgView);
r.Cells["Bondsnummer"].Value = values[1];
r.Cells["Naam"].Value = values[zoeknaam] + values[zoeknaam + 1];
r.Cells["Lic NAS"].Value = lic;
r.Cells["CG NAS"].Value = (values[2] == "J");
r.Cells["LB NAS"].Value = true;
r.Cells["Niet in Admin"].Value = true;
r.Cells["Niet in Admin"].Style.BackColor = System.Drawing.Color.Red;
r.Cells["LB NAS"].ReadOnly = true;
r.Cells["LB Admin"].ReadOnly = true;
r.Cells["Email NAS"].ReadOnly = true;
r.Cells["Email NAS"].Value = string.Empty;
r.ReadOnly = true;
disableEventCellUpdate = false;
}
}
Compare();
}
catch (Exception ex)
{
GuiRoutines.ShowMessage(ex);
}
}
private void Compare()
{
try
{
foreach (DataGridViewRow r in dgView.Rows)
{
bool CGAdmin = (bool)r.Cells["CG Admin"].Value;
bool LBAdmin = (bool)r.Cells["LB Admin"].Value;
bool inTeam = (bool)r.Cells["Team NAS"].Value;
bool CGNas = (bool)r.Cells["CG NAS"].Value;
bool LBNas = (bool)r.Cells["LB NAS"].Value;
bool NietInAdmin = (bool)r.Cells["Niet in Admin"].Value;
string LicAdmin = (string)r.Cells["Lic Admin"].Value;
string LicNAS = (string)r.Cells["Lic NAS"].Value;
string EmailNas = (string)r.Cells["Email NAS"].Value;
if ((CGAdmin != CGNas) || (CGAdmin != inTeam) || (CGNas != inTeam))
{
r.Cells["CG Admin"].Style.BackColor = System.Drawing.Color.Red;
r.Cells["Team NAS"].Style.BackColor = System.Drawing.Color.Red;
r.Cells["CG NAS"].Style.BackColor = System.Drawing.Color.Red;
}
else
{
r.Cells["CG Admin"].Style.BackColor = System.Drawing.Color.White;
r.Cells["Team NAS"].Style.BackColor = System.Drawing.Color.White;
r.Cells["CG NAS"].Style.BackColor = System.Drawing.Color.White;
}
if (LBNas != LBAdmin)
{
r.Cells["LB Admin"].Style.BackColor = System.Drawing.Color.Red;
r.Cells["LB NAS"].Style.BackColor = System.Drawing.Color.Red;
}
else
{
r.Cells["LB Admin"].Style.BackColor = System.Drawing.Color.White;
r.Cells["LB NAS"].Style.BackColor = System.Drawing.Color.White;
}
if (NietInAdmin)
{
r.Cells["Niet in Admin"].Style.BackColor = System.Drawing.Color.Red;
}
else
{
r.Cells["Niet in Admin"].Style.BackColor = System.Drawing.Color.White;
}
if (LicAdmin != LicNAS)
{
r.Cells["Lic Admin"].Style.BackColor = System.Drawing.Color.Red;
r.Cells["Lic NAS"].Style.BackColor = System.Drawing.Color.Red;
}
else
{
r.Cells["Lic Admin"].Style.BackColor = System.Drawing.Color.White;
r.Cells["Lic NAS"].Style.BackColor = System.Drawing.Color.White;
}
if ((r.Tag != null) && ((tblLid)r.Tag).MainEmailAdress != EmailNas)
{
r.Cells["Email NAS"].Style.BackColor = System.Drawing.Color.Red;
}
else
{
r.Cells["Email NAS"].Style.BackColor = System.Drawing.Color.White;
}
}
}
catch (Exception ex)
{
GuiRoutines.ShowMessage(ex);
}
}
private tblVCard Import()
{
tblVCard newVCardLijst = new tblVCard();
int aantal = 0;
string filename = Util.Forms.GuiRoutines.GetOpenFileName(openFileDialog1, "vcf");
if (filename == string.Empty)
{
return(null);
}
try
{
using (StreamReader sr = File.OpenText(filename))
{
string line = string.Empty;
string prefix = string.Empty;
VCard vCard = null;
while (!sr.EndOfStream)
{
line = sr.ReadLine();
prefix = "BEGIN:VCARD";
if (line.StartsWith(prefix))
{
vCard = new VCard();
newVCardLijst.Add(vCard);
aantal++;
}
prefix = "N:";
if (line.StartsWith(prefix))
{
line = line.Replace(prefix, string.Empty);
string[] naamdelen = line.Split(new char[] { ';' });
if (naamdelen[0] != null)
{
vCard.Achternaam = naamdelen[0];
}
if (naamdelen[1] != null)
{
vCard.Voornaam = naamdelen[1];
}
if (naamdelen[2] != null)
{
vCard.Tussenvoegsel = naamdelen[2];
}
}
prefix = "N;";
if (line.StartsWith(prefix))
{
vCard.Achternaam = "Onbekend";
}
//prefix = "FN:";
//if (line.StartsWith(prefix))
//{
// vCard.NetteNaam = line.Replace(prefix, string.Empty);
//}
prefix = "ORG:";
if (line.StartsWith(prefix))
{
vCard.Organisatie = line.Replace(prefix, string.Empty);
}
prefix = "BDAY:";
if (line.StartsWith(prefix))
{
vCard.GeboorteDatum = line.Replace(prefix, string.Empty);
}
prefix = "NOTE:";
if (line.StartsWith(prefix))
{
vCard.Note = line.Replace(prefix, string.Empty);
}
prefix = "TITLE:";
if (line.StartsWith(prefix))
{
vCard.Title = line.Replace(prefix, string.Empty);
}
prefix = "ADR";
if (line.StartsWith(prefix))
{
line = line.Replace(prefix, string.Empty);
if (line.StartsWith(";HOME"))
{
vCard.adresLijst.Add(ExtractAddress("HOME", line));
}
if (line.StartsWith(";WORK"))
{
vCard.adresLijst.Add(ExtractAddress("WORK", line));
}
if (line.StartsWith(";PREF"))
{
vCard.adresLijst.Add(ExtractAddress("", line));
}
if (line.StartsWith(":"))
{
vCard.adresLijst.Add(ExtractAddress("", line));
}
}
prefix = "TEL";
if (line.StartsWith(prefix))
{
//Console.WriteLine(line);
line = line.Replace(prefix, string.Empty);
if (line.StartsWith(";HOME"))
{
vCard.telefoonNummerLijst.Add(ExtractTelephoneNumber("HOME", line));
}
if (line.StartsWith(";WORK"))
{
vCard.telefoonNummerLijst.Add(ExtractTelephoneNumber("WORK", line));
}
if (line.StartsWith(";CELL"))
{
vCard.telefoonNummerLijst.Add(ExtractTelephoneNumber("CELL", line));
}
if (line.StartsWith(";PREF"))
{
vCard.telefoonNummerLijst.Add(ExtractTelephoneNumber("", line));
}
if (line.StartsWith(":"))
{
vCard.telefoonNummerLijst.Add(ExtractTelephoneNumber("", line));
}
}
prefix = "EMAIL";
if (line.StartsWith(prefix))
{
line = line.Replace(prefix, string.Empty);
if (line.StartsWith(";HOME"))
{
vCard.emailLijst.Add(ExtractEmailAddress("HOME", line));
}
if (line.StartsWith(";WORK"))
{
vCard.emailLijst.Add(ExtractEmailAddress("WORK", line));
}
if (line.StartsWith(":"))
{
vCard.emailLijst.Add(ExtractEmailAddress("", line));
}
if (line.StartsWith(";PREF"))
{
vCard.emailLijst.Add(ExtractEmailAddress("", line));
}
}
}
}
toolStripStatusLabel1.Text = "VCards ingelezen (" + aantal.ToString() + ")";
}
catch (Exception ex)
{
GuiRoutines.ShowMessage(ex);
}
return(newVCardLijst);
}