public bsRecord vulDefaultBs()
{
pf pf = new pf();
bsRecord bsRec = new bsRecord();
bsRec.Bstl_StatusId = 120009;
bsRec.Bstl_DispStatus = "Bestelling-record is leeg / Tabelinitrecord";
bsRec.Bstl_BgnrId = 1;
bsRec.Bstl_DispBgnr = "NL59ONBB0000000000";
bsRec.Bstl_KlBgId = 1;
bsRec.Bstl_DispKlBg = "Klant-Begunstigde";
bsRec.Bstl_VerwerkperiodeId = 1;
bsRec.Bstl_valutadatum = DateTime.Parse("2000-01-01 00:00:00");
bsRec.Bstl_Bestelbedrag = 0;
bsRec.Bstl_Diversen = 0;
bsRec.Bstl_DiversenId = 121009;
bsRec.Bstl_DispDiversen = "Bstl_Div-Leeg";
bsRec.Bstl_Verschil = 0;
bsRec.Bstl_VerschilId = 122009;
bsRec.Bstl_DispVerschil = "Bstl_Vschl-Leeg";
bsRec.Bstl_Vastekostenperbestelling = 0;
bsRec.Bstl_BonnengevraagdJN = 1;
bsRec.Bstl_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
bsRec.Bstl_Opmerking = "";
return(bsRec);
}
public kbRecord vulDefaultKb()
{
pf pf = new pf();
kbRecord kbRec = new kbRecord();
kbRec.KlBg_StatusId = 10009;
kbRec.KlBg_DispStatus = "KlBgId - Onbekend";
kbRec.KlBg_KlantJN = 1;
kbRec.KlBg_BegunstigdeJN = 0;
kbRec.KlBg_SysteemKlBgJN = 0;
kbRec.KlBg_Scipio_Lokaalnr = 0;
kbRec.KlBg_DebNr = "";
kbRec.KlBg_CredNr = "";
kbRec.KlBg_Voorvoegsel = "";
kbRec.KlBg_Voorletter = "";
kbRec.KlBg_Tussenvoegsel = "";
kbRec.KlBg_Achternaam = "";
kbRec.KlBg_VVTA = "VVTA";
kbRec.KlBg_AVVT = "AVVT";
kbRec.KlBg_Straatnaam = "";
kbRec.KlBg_Huisnummer = "";
kbRec.KlBg_Huisnummertoevoeging = "";
kbRec.KlBg_Adres = "";
kbRec.KlBg_Postcode = "";
kbRec.KlBg_Woonplaats = "";
kbRec.KlBg_Telefoonnummer = "";
kbRec.KlBg_Emailadres = "";
kbRec.KlBg_Extra_Informatie = "";
kbRec.KlBg_SysteemKlBgDispJN = "N";
kbRec.KlBg_KlDispJN = "J";
kbRec.KlBg_BgDispJN = "N";
kbRec.KlBg_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
kbRec.KlBg_Opmerking = "";
return(kbRec);
}
private void frmCmbap_Activated(object sender, EventArgs e)
{
pf pf = new pf();
pf.Init_vars();
// Variabelen initialiseren
// globalVars.Variabelen Vars = new globalVars.Variabelen();
// ProcFunc.PF PF = new ProcFunc.PF();
// Startscherm op maximaal zetten
this.WindowState = FormWindowState.Maximized;
this.MinimumSize = this.Size;
this.MaximumSize = this.Size;
this.lblProgrammakeuze.Text = "Hoofdmenu";
// Systeemdatum invullen op middelste veld van systeembalk
this.lblSysteemdatum.Text = DateTime.Now.ToLongDateString();
// Breedte van lblLicentie aanpassen
this.lblLicentie.Width = 460;
// Databases openen
// dbsLi = Licentiebestand met licentie- en modulegegevens van een gebruiker
// dbsDa = Databestand met gebruikers- en programmagegevens
//pF.dbsLi(gV.sDatapad + "Cmbap-Licentie.db");
//pF.dbsDa(gV.sDatapad + "Cmbap-Data.db");
// Controleren of licentiebestand goed is (1 actief record).
pf.zoekLicentie();
this.lblLicentie.Text = gv.actieveLicentie.Nr + " / " + gv.actieveLicentie.Displaynaamlh;
zetMenu();
// Menubalk volle breedte zetten
this.pnlMenu.Width = this.pnlSysteembalk.Width;
}
public int newPdRecord()
{
pf pf = new pf();
pdRecord dPd = new pdRecord();
dPd = vulDefaultPd();
int newPdId = new int();
string sCs = "Data Source=" + gv.sDataFilePad + ";Version=3;New=False;";
using (SQLiteConnection dbcDa = new SQLiteConnection(sCs))
{
dbcDa.Open();
string findstring = pf.randomString(6);
string sqlStr = "Insert Into Product (Prod_StatusId, Prod_DispStatus, Prod_Naamkort, Prod_Naamlang, " +
"Prod_Kleur, Prod_Code, Prod_Soort, Prod_ActiefJN, Prod_Dispactief, Prod_Waarde, " +
"Prod_Aantaleenhedenperproduct, Prod_Verzamelnaam, Prod_Waardepereenheid, Prod_Mutatiedatum, " +
"Prod_Opmerking) Values (@2, @3, @4, @5, @6, @7, @8, @9, @10, @11, @12, @13, @14, @15, @16)";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
SQLiteParameter p2 = new SQLiteParameter(); p2.ParameterName = "@2"; p2.Value = 170009; sqlCmd.Parameters.Add(p2);
SQLiteParameter p3 = new SQLiteParameter(); p3.ParameterName = "@3"; p3.Value = "Product-record is leeg / Tabelinitrecord"; sqlCmd.Parameters.Add(p3);
SQLiteParameter p4 = new SQLiteParameter(); p4.ParameterName = "@4"; p4.Value = "Prod_kort"; sqlCmd.Parameters.Add(p4);
SQLiteParameter p5 = new SQLiteParameter(); p5.ParameterName = "@5"; p5.Value = "Prod_lang"; sqlCmd.Parameters.Add(p5);
SQLiteParameter p6 = new SQLiteParameter(); p6.ParameterName = "@6"; p6.Value = "Kleur"; sqlCmd.Parameters.Add(p6);
SQLiteParameter p7 = new SQLiteParameter(); p7.ParameterName = "@7"; p7.Value = "Prod_code"; sqlCmd.Parameters.Add(p7);
SQLiteParameter p8 = new SQLiteParameter(); p8.ParameterName = "@8"; p8.Value = "B"; sqlCmd.Parameters.Add(p8);
SQLiteParameter p9 = new SQLiteParameter(); p9.ParameterName = "@9"; p9.Value = 0; sqlCmd.Parameters.Add(p9);
SQLiteParameter p10 = new SQLiteParameter(); p10.ParameterName = "@10"; p10.Value = "Nee"; sqlCmd.Parameters.Add(p10);
SQLiteParameter p11 = new SQLiteParameter(); p11.ParameterName = "@11"; p11.Value = 0; sqlCmd.Parameters.Add(p11);
SQLiteParameter p12 = new SQLiteParameter(); p12.ParameterName = "@12"; p12.Value = 20; sqlCmd.Parameters.Add(p12);
SQLiteParameter p13 = new SQLiteParameter(); p13.ParameterName = "@13"; p13.Value = "vel"; sqlCmd.Parameters.Add(p13);
SQLiteParameter p14 = new SQLiteParameter(); p14.ParameterName = "@14"; p14.Value = 0; sqlCmd.Parameters.Add(p14);
SQLiteParameter p15 = new SQLiteParameter(); p15.ParameterName = "@15"; p15.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p15);
SQLiteParameter p16 = new SQLiteParameter(); p16.ParameterName = "@16"; p16.Value = findstring; sqlCmd.Parameters.Add(p16);
sqlCmd.ExecuteNonQuery();
dbcDa.Close();
}
// Zoek toegevoegde record
tblPd pd = new tblPd();
pd.zoekProductRecord("Prod_Opmerking = " + "\"" + findstring + "\"");
newPdId = pd.lstProductRecord[0].Prod_Id;
// Verwijder infor uit Opmerking-veld
dbcDa.Open();
sqlStr = "Update Product set Prod_Opmerking=@16 where Prod_Id = @1;";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
sqlCmd.Parameters.AddWithValue("@1", newPdId);
sqlCmd.Parameters.AddWithValue("@16", "");
sqlCmd.ExecuteNonQuery();
}
dbcDa.Close();
return(newPdId);
}
}
public int newIlRecord()
{
pf pf = new pf();
ilRecord dIl = new ilRecord();
dIl = vulDefaultIl();
int newIlId = new int();
string sCs = "Data Source=" + gv.sDataFilePad + ";Version=3;New=False;";
using (SQLiteConnection dbcDa = new SQLiteConnection(sCs))
{
dbcDa.Open();
string findstring = pf.randomString(6);
string sqlStr = "Insert Into Instellingen (Instl_Systeemsetting, Instl_StatusId, Instl_DispStatus, Instl_Naam, Instl_Gegtype, " +
"Instl_Actief, Instl_String, Instl_JN, Instl_Integer, Instl_Real, Instl_Memo, Instl_Datum, Instl_Tijd" +
"Instl_Mutatiedatum, Instl_Opmerking) Values (@2, @3, @4, @5, @6, @7, @8, @9, @10, @11, @12, @13, @14, @15, @16)";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
SQLiteParameter p2 = new SQLiteParameter(); p2.ParameterName = "@2"; p2.Value = 0; sqlCmd.Parameters.Add(p2);
SQLiteParameter p3 = new SQLiteParameter(); p3.ParameterName = "@3"; p3.Value = 195009; sqlCmd.Parameters.Add(p3);
SQLiteParameter p4 = new SQLiteParameter(); p4.ParameterName = "@4"; p4.Value = "Instl-record is zijn leeg / Tabelinitrecord"; sqlCmd.Parameters.Add(p4);
SQLiteParameter p5 = new SQLiteParameter(); p5.ParameterName = "@5"; p5.Value = "Instelling"; sqlCmd.Parameters.Add(p5);
SQLiteParameter p6 = new SQLiteParameter(); p6.ParameterName = "@6"; p6.Value = 0; sqlCmd.Parameters.Add(p6);
SQLiteParameter p7 = new SQLiteParameter(); p7.ParameterName = "@7"; p7.Value = 0; sqlCmd.Parameters.Add(p7);
SQLiteParameter p8 = new SQLiteParameter(); p8.ParameterName = "@8"; p8.Value = ""; sqlCmd.Parameters.Add(p8);
SQLiteParameter p9 = new SQLiteParameter(); p9.ParameterName = "@9"; p9.Value = 0; sqlCmd.Parameters.Add(p9);
SQLiteParameter p10 = new SQLiteParameter(); p10.ParameterName = "@10"; p10.Value = 0; sqlCmd.Parameters.Add(p10);
SQLiteParameter p11 = new SQLiteParameter(); p11.ParameterName = "@11"; p5.Value = 0; sqlCmd.Parameters.Add(p11);
SQLiteParameter p12 = new SQLiteParameter(); p12.ParameterName = "@12"; p6.Value = ""; sqlCmd.Parameters.Add(p12);
SQLiteParameter p13 = new SQLiteParameter(); p13.ParameterName = "@13"; p7.Value = DateTime.Parse("2000-01-01 00:00:00");; sqlCmd.Parameters.Add(p13);
SQLiteParameter p14 = new SQLiteParameter(); p14.ParameterName = "@14"; p8.Value = DateTime.Parse("2000-01-01 00:00:00");; sqlCmd.Parameters.Add(p14);
SQLiteParameter p15 = new SQLiteParameter(); p15.ParameterName = "@15"; p9.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p15);
SQLiteParameter p16 = new SQLiteParameter(); p16.ParameterName = "@10"; p10.Value = findstring; sqlCmd.Parameters.Add(p16);
sqlCmd.ExecuteNonQuery();
dbcDa.Close();
}
// Zoek toegevoegde record
tblIl il = new tblIl();
il.zoekInstellingenRecord("Instl_Opmerking = " + "\"" + findstring + "\"");
newIlId = il.lstInstellingenRecord[0].Instl_Id;
// Verwijder infor uit Opmerking-veld
dbcDa.Open();
sqlStr = "Update Instellingen set Instl_Opmerking=@8 where Instl_Id = @1;";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
sqlCmd.Parameters.AddWithValue("@1", newIlId);
sqlCmd.Parameters.AddWithValue("@8", "");
sqlCmd.ExecuteNonQuery();
}
dbcDa.Close();
return(newIlId);
}
}
public int newBlRecord()
{
pf pf = new pf();
blRecord dBl = new blRecord();
dBl = vulDefaultBl();
int newBlId = new int();
string sCs = "Data Source=" + gv.sDataFilePad + ";Version=3;New=False;";
using (SQLiteConnection dbcDa = new SQLiteConnection(sCs))
{
dbcDa.Open();
string findstring = pf.randomString(6);
string sqlStr = "Insert Into Bestelregel (Bstlr_BstlId, Bstlr_StatusId, Bstlr_DispStatus, Bstlr_ProdId, Bstlr_DispProduct, " +
"Bstlr_Aantal, Bstlr_Beginnr, Bstlr_Eindnr, Bstlr_Voorraad, Bstlr_Extranr1, Bstlr_Extranr2, Bstlr_Extranr3, " +
"Bstlr_Mutatiedatum, Bstlr_Opmerking) Values (@2, @3, @4, @5, @6, @7, @8, @9, @10, @11, @12, @13, @14, @15)";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
SQLiteParameter p2 = new SQLiteParameter(); p2.ParameterName = "@2"; p2.Value = 1; sqlCmd.Parameters.Add(p2);
SQLiteParameter p3 = new SQLiteParameter(); p3.ParameterName = "@3"; p3.Value = 135009; sqlCmd.Parameters.Add(p3);
SQLiteParameter p4 = new SQLiteParameter(); p4.ParameterName = "@4"; p4.Value = "Bestelregel-record is leeg / Tabelinitrecord"; sqlCmd.Parameters.Add(p4);
SQLiteParameter p5 = new SQLiteParameter(); p5.ParameterName = "@5"; p5.Value = 1; sqlCmd.Parameters.Add(p5);
SQLiteParameter p6 = new SQLiteParameter(); p6.ParameterName = "@6"; p6.Value = "Productnaam"; sqlCmd.Parameters.Add(p6);
SQLiteParameter p7 = new SQLiteParameter(); p7.ParameterName = "@7"; p7.Value = 0; sqlCmd.Parameters.Add(p7);
SQLiteParameter p8 = new SQLiteParameter(); p8.ParameterName = "@8"; p8.Value = 0; sqlCmd.Parameters.Add(p8);
SQLiteParameter p9 = new SQLiteParameter(); p9.ParameterName = "@9"; p9.Value = 0; sqlCmd.Parameters.Add(p9);
SQLiteParameter p10 = new SQLiteParameter(); p10.ParameterName = "@10"; p10.Value = 0; sqlCmd.Parameters.Add(p10);
SQLiteParameter p11 = new SQLiteParameter(); p11.ParameterName = "@11"; p11.Value = 0; sqlCmd.Parameters.Add(p11);
SQLiteParameter p12 = new SQLiteParameter(); p12.ParameterName = "@12"; p12.Value = 0; sqlCmd.Parameters.Add(p12);
SQLiteParameter p13 = new SQLiteParameter(); p13.ParameterName = "@13"; p13.Value = 0; sqlCmd.Parameters.Add(p13);
SQLiteParameter p14 = new SQLiteParameter(); p14.ParameterName = "@14"; p14.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p14);
SQLiteParameter p15 = new SQLiteParameter(); p15.ParameterName = "@15"; p15.Value = findstring; sqlCmd.Parameters.Add(p15);
sqlCmd.ExecuteNonQuery();
dbcDa.Close();
}
// Zoek toegevoegde record
tblBl bl = new tblBl();
bl.zoekBestelregelRecord("Bstlr_Opmerking = " + "\"" + findstring + "\"");
newBlId = bl.lstBestelregelRecord[0].Bstlr_Id;
// Verwijder infor uit Opmerking-veld
dbcDa.Open();
sqlStr = "Update Bestelregel set Bstlr_Opmerking=@16 where Bstlr_Id = @1;";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
sqlCmd.Parameters.AddWithValue("@1", newBlId);
sqlCmd.Parameters.AddWithValue("@16", "");
sqlCmd.ExecuteNonQuery();
}
dbcDa.Close();
return(newBlId);
}
}
public int newUgRecord()
{
pf pf = new pf();
ugRecord dUg = new ugRecord();
dUg = vulDefaultUg();
int newUgId = new int();
string sCs = "Data Source=" + gv.sDataFilePad + ";Version=3;New=False;";
using (SQLiteConnection dbcDa = new SQLiteConnection(sCs))
{
dbcDa.Open();
string findstring = pf.randomString(6);
string sqlStr = "Insert Into Uitgaven (Ugv_StatusId, Ugv_DispStatus, Ugv_KlBgId, Ugv_DispKlBg, Ugv_HusId, Ugv_DispHus," +
"Ugv_SusId, Ugv_DispSus, Ugv_Datum, Ugv_Kasbewijsnr, Ugv_Bedrag, Ugv_Mutatiedatum, Ugv_Opmerking) Values " +
"(@2, @3, @4, @5, @6, @7, @8, @9, @10, @11, @12, @13, @14)";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
SQLiteParameter p2 = new SQLiteParameter(); p2.ParameterName = "@2"; p2.Value = 140009; sqlCmd.Parameters.Add(p2);
SQLiteParameter p3 = new SQLiteParameter(); p3.ParameterName = "@3"; p3.Value = "Uitgave-record is zijn leeg / Tabelinitrecord"; sqlCmd.Parameters.Add(p3);
SQLiteParameter p4 = new SQLiteParameter(); p4.ParameterName = "@4"; p4.Value = 1; sqlCmd.Parameters.Add(p4);
SQLiteParameter p5 = new SQLiteParameter(); p5.ParameterName = "@5"; p5.Value = "Klant-begunstigde"; sqlCmd.Parameters.Add(p5);
SQLiteParameter p6 = new SQLiteParameter(); p6.ParameterName = "@6"; p6.Value = 1; sqlCmd.Parameters.Add(p6);
SQLiteParameter p7 = new SQLiteParameter(); p7.ParameterName = "@7"; p7.Value = ""; sqlCmd.Parameters.Add(p7);
SQLiteParameter p8 = new SQLiteParameter(); p8.ParameterName = "@8"; p8.Value = 1; sqlCmd.Parameters.Add(p8);
SQLiteParameter p9 = new SQLiteParameter(); p9.ParameterName = "@9"; p9.Value = ""; sqlCmd.Parameters.Add(p9);
SQLiteParameter p10 = new SQLiteParameter(); p10.ParameterName = "@10"; p10.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p10);
SQLiteParameter p11 = new SQLiteParameter(); p11.ParameterName = "@11"; p11.Value = "0"; sqlCmd.Parameters.Add(p11);
SQLiteParameter p12 = new SQLiteParameter(); p12.ParameterName = "@12"; p12.Value = 0; sqlCmd.Parameters.Add(p12);
SQLiteParameter p13 = new SQLiteParameter(); p13.ParameterName = "@13"; p13.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p13);
SQLiteParameter p14 = new SQLiteParameter(); p14.ParameterName = "@14"; p14.Value = findstring; sqlCmd.Parameters.Add(p14);
sqlCmd.ExecuteNonQuery();
dbcDa.Close();
}
// Zoek toegevoegde record
tblUg ug = new tblUg();
ug.zoekUitgavenRecord("Ugv_Opmerking = " + "\"" + findstring + "\"");
newUgId = ug.lstUitgavenRecord[0].Ugv_Id;
// Verwijder infor uit Opmerking-veld
dbcDa.Open();
sqlStr = "Update Uitgaven set Ugv_Opmerking=@8 where Ugv_Id = @1;";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
sqlCmd.Parameters.AddWithValue("@1", newUgId);
sqlCmd.Parameters.AddWithValue("@8", "");
sqlCmd.ExecuteNonQuery();
}
dbcDa.Close();
return(newUgId);
}
}
public int newAgRecord()
{
pf pf = new pf();
agRecord dAg = new agRecord();
dAg = vulDefaultAg();
int newAgId = new int();
string sCs = "Data Source=" + gv.sDataFilePad + ";Version=3;New=False;";
using (SQLiteConnection dbcDa = new SQLiteConnection(sCs))
{
dbcDa.Open();
string findstring = pf.randomString(6);
string sqlStr = "Insert Into Adresgegevens (Adrsgeg_StatusId, Adrsgeg_DispStatus, Adrsgeg_KlBgId, Adrsgeg_DispKlBg, " +
"Adrsgeg_Straatnaam, Adrsgeg_Huisnummer, Adrsgeg_Huisnummertoevoeging, Adrsgeg_Adres, Adrsgeg_Postcode, " +
"Adrsgeg_Woonplaats, Adrsgeg_Mutatiedatum, Adrsgeg_Opmerking) " +
"Values (@2, @3, @4, @5, @6, @7, @8, @9, @10, @11, @12, @13)";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
SQLiteParameter p2 = new SQLiteParameter(); p2.ParameterName = "@2"; p2.Value = 20009; sqlCmd.Parameters.Add(p2);
SQLiteParameter p3 = new SQLiteParameter(); p3.ParameterName = "@3"; p3.Value = "Adresgegevens-record is leeg / Tabelinitrecord"; sqlCmd.Parameters.Add(p3);
SQLiteParameter p4 = new SQLiteParameter(); p4.ParameterName = "@4"; p4.Value = 1; sqlCmd.Parameters.Add(p4);
SQLiteParameter p5 = new SQLiteParameter(); p5.ParameterName = "@5"; p5.Value = "Klant-begunstigde"; sqlCmd.Parameters.Add(p5);
SQLiteParameter p6 = new SQLiteParameter(); p6.ParameterName = "@6"; p6.Value = "Straatnaam"; sqlCmd.Parameters.Add(p6);
SQLiteParameter p7 = new SQLiteParameter(); p7.ParameterName = "@7"; p7.Value = 0; sqlCmd.Parameters.Add(p7);
SQLiteParameter p8 = new SQLiteParameter(); p8.ParameterName = "@8"; p8.Value = ""; sqlCmd.Parameters.Add(p8);
SQLiteParameter p9 = new SQLiteParameter(); p9.ParameterName = "@9"; p9.Value = "Straatnaam 0"; sqlCmd.Parameters.Add(p9);
SQLiteParameter p10 = new SQLiteParameter(); p10.ParameterName = "@10"; p10.Value = "0000 AA"; sqlCmd.Parameters.Add(p10);
SQLiteParameter p11 = new SQLiteParameter(); p11.ParameterName = "@11"; p11.Value = "Woonplaats"; sqlCmd.Parameters.Add(p11);
SQLiteParameter p12 = new SQLiteParameter(); p12.ParameterName = "@12"; p12.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p12);
SQLiteParameter p13 = new SQLiteParameter(); p13.ParameterName = "@13"; p13.Value = findstring; sqlCmd.Parameters.Add(p13);
sqlCmd.ExecuteNonQuery();
dbcDa.Close();
}
// Zoek toegevoegde record
tblAg ag = new tblAg();
ag.zoekAdresgegevensRecord("Adrsgeg_Opmerking = " + "\"" + findstring + "\"");
newAgId = ag.lstAdrsgegRecord[0].Adrsgeg_Id;
// Verwijder infor uit Opmerking-veld
dbcDa.Open();
sqlStr = "Update Adresgegevens set Adrsgeg_Opmerking=@16 where Adrsgeg_Id = @1;";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
sqlCmd.Parameters.AddWithValue("@1", newAgId);
sqlCmd.Parameters.AddWithValue("@16", "");
sqlCmd.ExecuteNonQuery();
}
dbcDa.Close();
return(newAgId);
}
}
public int newBgRecord()
{
pf pf = new pf();
bgRecord dBg = new bgRecord();
dBg = vulDefaultBg();
int newBgId = new int();
string sCs = "Data Source=" + gv.sDataFilePad + ";Version=3;New=False;";
using (SQLiteConnection dbcDa = new SQLiteConnection(sCs))
{
dbcDa.Open();
string findstring = pf.randomString(6);
string sqlStr = "Insert Into Bankgironr (Bgnr_StatusId, Bgnr_DispStatus, Bgnr_SysteemBgnrJN, Bgnr_KlBgId, Bgnr_DispKlBg, " +
"Bgnr_Tnv, Bgnr_Kort, Bgnr_Iban, Bgnr_IbanBankGiroKas, Bgnr_Mutatiedatum, Bgnr_Opmerking) Values " +
"(@2, @3, @4, @5, @6, @7, @8, @9, @10, @11, @12)";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
SQLiteParameter p2 = new SQLiteParameter(); p2.ParameterName = "@2"; p2.Value = 110009; sqlCmd.Parameters.Add(p2);
SQLiteParameter p3 = new SQLiteParameter(); p3.ParameterName = "@3"; p3.Value = "Bankgironr-record is zijn leeg / Tabelinitrecord"; sqlCmd.Parameters.Add(p3);
SQLiteParameter p4 = new SQLiteParameter(); p4.ParameterName = "@4"; p4.Value = 0; sqlCmd.Parameters.Add(p4);
SQLiteParameter p5 = new SQLiteParameter(); p5.ParameterName = "@5"; p5.Value = 1; sqlCmd.Parameters.Add(p5);
SQLiteParameter p6 = new SQLiteParameter(); p6.ParameterName = "@6"; p6.Value = "Klant-Begunstigde"; sqlCmd.Parameters.Add(p6);
SQLiteParameter p7 = new SQLiteParameter(); p7.ParameterName = "@7"; p7.Value = ""; sqlCmd.Parameters.Add(p7);
SQLiteParameter p8 = new SQLiteParameter(); p8.ParameterName = "@8"; p8.Value = "000000000"; sqlCmd.Parameters.Add(p8);
SQLiteParameter p9 = new SQLiteParameter(); p9.ParameterName = "@9"; p9.Value = "NL59ONBB0000000000"; sqlCmd.Parameters.Add(p9);
SQLiteParameter p10 = new SQLiteParameter(); p10.ParameterName = "@10"; p10.Value = "I"; sqlCmd.Parameters.Add(p10);
SQLiteParameter p11 = new SQLiteParameter(); p11.ParameterName = "@11"; p11.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p11);
SQLiteParameter p12 = new SQLiteParameter(); p12.ParameterName = "@12"; p12.Value = findstring; sqlCmd.Parameters.Add(p12);
sqlCmd.ExecuteNonQuery();
dbcDa.Close();
}
// Zoek toegevoegde record
tblBg bg = new tblBg();
bg.zoekBankgironrRecord("Bgnr_Opmerking = " + "\"" + findstring + "\"");
newBgId = bg.lstBankgironrRecord[0].Bgnr_Id;
// Verwijder infor uit Opmerking-veld
dbcDa.Open();
sqlStr = "Update Bankgironr set Bgnr_Opmerking=@8 where Bgnr_Id = @1;";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
sqlCmd.Parameters.AddWithValue("@1", newBgId);
sqlCmd.Parameters.AddWithValue("@8", "");
sqlCmd.ExecuteNonQuery();
}
dbcDa.Close();
return(newBgId);
}
}
public int newScRecord()
{
pf pf = new pf();
scRecord dSc = new scRecord();
dSc = vulDefaultSc();
int newScId = new int();
string sCs = "Data Source=" + gv.sDataFilePad + ";Version=3;New=False;";
using (SQLiteConnection dbcDa = new SQLiteConnection(sCs))
{
dbcDa.Open();
string findstring = pf.randomString(6);
string sqlStr = "Insert Into Subcategorie (Scat_StatusId, Scat_DispStatus, Scat_Kort, Scat_Lang, Scat_HcatId, Scat_DispHcat, " +
"Scat_Code, Scat_WijzigentoegestaanJN, Scat_Mutatiedatum, Scat_Opmerking) Values " +
"(@2, @3, @4, @5, @6, @7, @8, @9, @10, @11)";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
SQLiteParameter p2 = new SQLiteParameter(); p2.ParameterName = "@2"; p2.Value = 160009; sqlCmd.Parameters.Add(p2);
SQLiteParameter p3 = new SQLiteParameter(); p3.ParameterName = "@3"; p3.Value = "Scat-record is zijn leeg / Tabelinitrecord"; sqlCmd.Parameters.Add(p3);
SQLiteParameter p4 = new SQLiteParameter(); p4.ParameterName = "@4"; p4.Value = "Scat_kort"; sqlCmd.Parameters.Add(p4);
SQLiteParameter p5 = new SQLiteParameter(); p5.ParameterName = "@5"; p5.Value = "Scat_lang"; sqlCmd.Parameters.Add(p5);
SQLiteParameter p6 = new SQLiteParameter(); p6.ParameterName = "@6"; p6.Value = 1; sqlCmd.Parameters.Add(p6);
SQLiteParameter p7 = new SQLiteParameter(); p7.ParameterName = "@7"; p7.Value = ""; sqlCmd.Parameters.Add(p7);
SQLiteParameter p8 = new SQLiteParameter(); p8.ParameterName = "@8"; p8.Value = ""; sqlCmd.Parameters.Add(p8);
SQLiteParameter p9 = new SQLiteParameter(); p9.ParameterName = "@9"; p9.Value = 1; sqlCmd.Parameters.Add(p9);
SQLiteParameter p10 = new SQLiteParameter(); p10.ParameterName = "@10"; p10.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p10);
SQLiteParameter p11 = new SQLiteParameter(); p11.ParameterName = "@11"; p11.Value = findstring; sqlCmd.Parameters.Add(p11);
sqlCmd.ExecuteNonQuery();
dbcDa.Close();
}
// Zoek toegevoegde record
tblSc sc = new tblSc();
sc.zoekSubcategorieRecord("Scat_Opmerking = " + "\"" + findstring + "\"");
newScId = sc.lstSubcategorieRecord[0].Scat_Id;
// Verwijder infor uit Opmerking-veld
dbcDa.Open();
sqlStr = "Update Subcategorie set Scat_Opmerking=@8 where Scat_Id = @1;";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
sqlCmd.Parameters.AddWithValue("@1", newScId);
sqlCmd.Parameters.AddWithValue("@8", "");
sqlCmd.ExecuteNonQuery();
}
dbcDa.Close();
return(newScId);
}
}
public huRecord vulDefaultHu()
{
pf pf = new pf();
huRecord huRec = new huRecord();
huRec.Hus_StatusId = 190009;
huRec.Hus_DispStatus = "Hus-record is leeg / Tabel-initrecord";
huRec.Hus_Kort = "Hus_kort";
huRec.Hus_Lang = "Hus_lang";
huRec.Hus_WijzigentoegestaanJN = 1;
huRec.Hus_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
huRec.Hus_Opmerking = "";
return(huRec);
}
public int newssRecord()
{
pf pf = new pf();
ssRecord dss = new ssRecord();
dss = vulDefaultSs();
int newssId = new int();
string sCs = "Data Source=" + gv.sDataFilePad + ";Version=3;New=False;";
using (SQLiteConnection dbcDa = new SQLiteConnection(sCs))
{
dbcDa.Open();
string findstring = pf.randomString(6);
string sqlStr = "Insert Into Saldostand (Saldostand_StatusId, Saldostand_DispStatus, Saldostand_JgegId, " +
"Saldostand_BgnrId, Saldostand_Datum, Saldostand_Saldo, Saldostand_Mutatiedatum, Saldostand_Opmerking) Values " +
"(@2, @3, @4, @5, @6, @7, @8, @9)";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
SQLiteParameter p2 = new SQLiteParameter(); p2.ParameterName = "@2"; p2.Value = 165009; sqlCmd.Parameters.Add(p2);
SQLiteParameter p3 = new SQLiteParameter(); p3.ParameterName = "@3"; p3.Value = "Saldostand-record is leeg / Tabelinitrecord"; sqlCmd.Parameters.Add(p3);
SQLiteParameter p4 = new SQLiteParameter(); p4.ParameterName = "@4"; p4.Value = 1; sqlCmd.Parameters.Add(p4);
SQLiteParameter p5 = new SQLiteParameter(); p5.ParameterName = "@5"; p5.Value = 1; sqlCmd.Parameters.Add(p5);
SQLiteParameter p6 = new SQLiteParameter(); p6.ParameterName = "@6"; p6.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p6);
SQLiteParameter p7 = new SQLiteParameter(); p7.ParameterName = "@7"; p7.Value = 0; sqlCmd.Parameters.Add(p7);
SQLiteParameter p8 = new SQLiteParameter(); p8.ParameterName = "@8"; p8.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p8);
SQLiteParameter p9 = new SQLiteParameter(); p9.ParameterName = "@9"; p9.Value = findstring; sqlCmd.Parameters.Add(p9);
sqlCmd.ExecuteNonQuery();
dbcDa.Close();
}
// Zoek toegevoegde record
tblSs ss = new tblSs();
ss.zoekSaldoStandRecord("Saldostand_Opmerking = " + "\"" + findstring + "\"");
newssId = ss.lstSaldoStandRecord[0].Saldostand_Id;
// Verwijder infor uit Opmerking-veld
dbcDa.Open();
sqlStr = "Update Saldostand set Saldostand_Opmerking=@8 where Saldostand_Id = @1;";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
sqlCmd.Parameters.AddWithValue("@1", newssId);
sqlCmd.Parameters.AddWithValue("@8", "");
sqlCmd.ExecuteNonQuery();
}
dbcDa.Close();
return(newssId);
}
}
public jgRecord vulDefaultPd()
{
pf pf = new pf();
jgRecord jgRec = new jgRecord();
jgRec.Jgeg_StatusId = 180009;
jgRec.Jgeg_DispStatus = "Jaargegevens-record is leeg / Tabelinitrecord";
jgRec.Jgeg_Omschrijving = "2000";
jgRec.Jgeg_Begindatum = DateTime.Parse("2000-01-01 00:00:00");
jgRec.Jgeg_Einddatum = DateTime.Parse("2000-12-31 00:00:00");
jgRec.Jgeg_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
jgRec.Jgeg_Opmerking = "";
return(jgRec);
}
public eaRecord vulDefaultEa()
{
pf pf = new pf();
eaRecord eaRec = new eaRecord();
eaRec.Ea_StatusId = 200009;
eaRec.Ea_DispStatus = "Emailadresgegevens zijn leeg / Tabelinitrecord";
eaRec.Ea_KlBgId = 1;
eaRec.Ea_DispKlBg = "Klant-Begunstigde";
eaRec.Ea_Emailadres = "*****@*****.**";
eaRec.Ea_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
eaRec.Ea_Opmerking = "";
return(eaRec);
}
public int newHcRecord()
{
pf pf = new pf();
hcRecord dHc = new hcRecord();
dHc = vulDefaultHc();
int newHcId = new int();
string sCs = "Data Source=" + gv.sDataFilePad + ";Version=3;New=False;";
using (SQLiteConnection dbcDa = new SQLiteConnection(sCs))
{
dbcDa.Open();
string findstring = pf.randomString(6);
string sqlStr = "Insert Into Hoofdcategorie (Hcat_StatusId, Hcat_DispStatus, Hcat_Prefix, Hcat_Kort, Hcat_Lang, " +
"Hcat_WijzigentoegestaanJN, Hcat_Mutatiedatum, Hcat_Opmerking) Values " +
"(@2, @3, @4, @5, @6, @7, @8, @9)";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
SQLiteParameter p2 = new SQLiteParameter(); p2.ParameterName = "@2"; p2.Value = 195009; sqlCmd.Parameters.Add(p2);
SQLiteParameter p3 = new SQLiteParameter(); p3.ParameterName = "@3"; p3.Value = "Hcat-record is zijn leeg / Tabelinitrecord"; sqlCmd.Parameters.Add(p3);
SQLiteParameter p4 = new SQLiteParameter(); p4.ParameterName = "@4"; p4.Value = "PFX"; sqlCmd.Parameters.Add(p4);
SQLiteParameter p5 = new SQLiteParameter(); p5.ParameterName = "@5"; p5.Value = "Hcat_kort"; sqlCmd.Parameters.Add(p5);
SQLiteParameter p6 = new SQLiteParameter(); p6.ParameterName = "@6"; p6.Value = "Hcat_lang"; sqlCmd.Parameters.Add(p6);
SQLiteParameter p7 = new SQLiteParameter(); p7.ParameterName = "@7"; p7.Value = 1; sqlCmd.Parameters.Add(p7);
SQLiteParameter p8 = new SQLiteParameter(); p8.ParameterName = "@8"; p8.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p8);
SQLiteParameter p9 = new SQLiteParameter(); p9.ParameterName = "@9"; p9.Value = findstring; sqlCmd.Parameters.Add(p9);
sqlCmd.ExecuteNonQuery();
dbcDa.Close();
}
// Zoek toegevoegde record
tblHc hc = new tblHc();
hc.zoekHoofdcategorieRecord("Hcat_Opmerking = " + "\"" + findstring + "\"");
newHcId = hc.lstHoofdcategorieRecord[0].Hcat_Id;
// Verwijder infor uit Opmerking-veld
dbcDa.Open();
sqlStr = "Update Hoofdcategorie set Hcat_Opmerking=@8 where Hcat_Id = @1;";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
sqlCmd.Parameters.AddWithValue("@1", newHcId);
sqlCmd.Parameters.AddWithValue("@8", "");
sqlCmd.ExecuteNonQuery();
}
dbcDa.Close();
return(newHcId);
}
}
public tlRecord vulDefaultTl()
{
pf pf = new pf();
tlRecord tlRec = new tlRecord();
tlRec.Tlf_StatusId = 105009;
tlRec.Tlf_DispStatus = "Telefoonnummergegevens zijn leeg / Tabelinitrecord";
tlRec.Tlf_KlBgId = 1;
tlRec.Tlf_DispKlBg = "Klant-Begunstigde";
tlRec.Tlf_Telefoonnr = "000-000000";
tlRec.Tlf_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
tlRec.Tlf_Opmerking = "";
return(tlRec);
}
public jsRecord vulDefaultSs()
{
pf pf = new pf();
jsRecord jsRec = new jsRecord();
jsRec.Jsal_StatusId = 181009;
jsRec.Jsal_DispStatus = "Jaarsaldo-record is leeg / Tabelinitrecord";
jsRec.Jsal_JgegId = 1;
jsRec.Jsal_BgnrId = 1;
jsRec.Jsal_Beginsaldo = 0;
jsRec.Jsal_Eindsaldo = 0;
jsRec.Jsal_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
jsRec.Jsal_Opmerking = "";
return(jsRec);
}
public ssRecord vulDefaultSs()
{
pf pf = new pf();
ssRecord ssRec = new ssRecord();
ssRec.Saldostand_StatusId = 165009;
ssRec.Saldostand_DispStatus = "Saldostand-record is leeg / Tabelinitrecord";
ssRec.Saldostand_JgegId = 1;
ssRec.Saldostand_BgnrId = 1;
ssRec.Saldostand_Datum = DateTime.Parse("2000-01-01 00:00:00");
ssRec.Saldostand_Saldo = 0;
ssRec.Saldostand_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
ssRec.Saldostand_Opmerking = "";
return(ssRec);
}
public hcRecord vulDefaultHc()
{
pf pf = new pf();
hcRecord hcRec = new hcRecord();
hcRec.Hcat_StatusId = 195009;
hcRec.Hcat_DispStatus = "Hcat-record is leeg / Tabel-initrecord";
hcRec.Hcat_Prefix = "PFX";
hcRec.Hcat_Kort = "Hcat_kort";
hcRec.Hcat_Lang = "Hcat_lang";
hcRec.Hcat_WijzigentoegestaanJN = 1;
hcRec.Hcat_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
hcRec.Hcat_Opmerking = "";
return(hcRec);
}
public int newTlRecord()
{
pf pf = new pf();
tlRecord dTl = new tlRecord();
dTl = vulDefaultTl();
int newTlId = new int();
string sCs = "Data Source=" + gv.sDataFilePad + ";Version=3;New=False;";
using (SQLiteConnection dbcDa = new SQLiteConnection(sCs))
{
dbcDa.Open();
string findstring = pf.randomString(6);
string sqlStr = "Insert Into Telefoonnr (Tlf_StatusId, Tlf_DispStatus, Tlf_KlBgId, Tlf_DispKlBg, " +
"Tlf_Telefoonnr, Tlf_Mutatiedatum, Tlf_Opmerking) Values (@2, @3, @4, @5, @6, @7, @8)";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
SQLiteParameter p2 = new SQLiteParameter(); p2.ParameterName = "@2"; p2.Value = 105009; sqlCmd.Parameters.Add(p2);
SQLiteParameter p3 = new SQLiteParameter(); p3.ParameterName = "@3"; p3.Value = "Telefoonnummergegevens zijn leeg / Tabelinitrecord"; sqlCmd.Parameters.Add(p3);
SQLiteParameter p4 = new SQLiteParameter(); p4.ParameterName = "@4"; p4.Value = 1; sqlCmd.Parameters.Add(p4);
SQLiteParameter p5 = new SQLiteParameter(); p5.ParameterName = "@5"; p5.Value = "Klant-Begunstigde"; sqlCmd.Parameters.Add(p5);
SQLiteParameter p6 = new SQLiteParameter(); p6.ParameterName = "@6"; p6.Value = "000-000000"; sqlCmd.Parameters.Add(p6);
SQLiteParameter p7 = new SQLiteParameter(); p7.ParameterName = "@7"; p7.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p7);
SQLiteParameter p8 = new SQLiteParameter(); p8.ParameterName = "@8"; p8.Value = findstring; sqlCmd.Parameters.Add(p8);
sqlCmd.ExecuteNonQuery();
dbcDa.Close();
}
// Zoek toegevoegde record
tblTl tl = new tblTl();
tl.zoekTelefoonnrRecord("Tlf_Opmerking = " + "\"" + findstring + "\"");
newTlId = tl.lstTelefoonnrRecord[0].Tlf_Id;
// Verwijder infor uit Opmerking-veld
dbcDa.Open();
sqlStr = "Update Telefoonnr set Tlf_Opmerking=@8 where Tlf_Id = @1;";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
sqlCmd.Parameters.AddWithValue("@1", newTlId);
sqlCmd.Parameters.AddWithValue("@8", "");
sqlCmd.ExecuteNonQuery();
}
dbcDa.Close();
return(newTlId);
}
}
public int newEaRecord()
{
pf pf = new pf();
eaRecord dEa = new eaRecord();
dEa = vulDefaultEa();
int newEaId = new int();
string sCs = "Data Source=" + gv.sDataFilePad + ";Version=3;New=False;";
using (SQLiteConnection dbcDa = new SQLiteConnection(sCs))
{
dbcDa.Open();
string findstring = pf.randomString(6);
string sqlStr = "Insert Into Emailadres (Ea_StatusId, Ea_DispStatus, Ea_KlBgId, Ea_DispKlBg, " +
"Ea_Emailadres, Ea_Mutatiedatum, Ea_Opmerking) Values (@2, @3, @4, @5, @6, @7, @8)";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
SQLiteParameter p2 = new SQLiteParameter(); p2.ParameterName = "@2"; p2.Value = 200009; sqlCmd.Parameters.Add(p2);
SQLiteParameter p3 = new SQLiteParameter(); p3.ParameterName = "@3"; p3.Value = "Emailadrs-record is zijn leeg / Tabelinitrecord"; sqlCmd.Parameters.Add(p3);
SQLiteParameter p4 = new SQLiteParameter(); p4.ParameterName = "@4"; p4.Value = 1; sqlCmd.Parameters.Add(p4);
SQLiteParameter p5 = new SQLiteParameter(); p5.ParameterName = "@5"; p5.Value = "Klant-Begunstigde"; sqlCmd.Parameters.Add(p5);
SQLiteParameter p6 = new SQLiteParameter(); p6.ParameterName = "@6"; p6.Value = "*****@*****.**"; sqlCmd.Parameters.Add(p6);
SQLiteParameter p7 = new SQLiteParameter(); p7.ParameterName = "@7"; p7.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p7);
SQLiteParameter p8 = new SQLiteParameter(); p8.ParameterName = "@8"; p8.Value = findstring; sqlCmd.Parameters.Add(p8);
sqlCmd.ExecuteNonQuery();
dbcDa.Close();
}
// Zoek toegevoegde record
tblEa ea = new tblEa();
ea.zoekSubuitgavesoort("Ea_Opmerking = " + "\"" + findstring + "\"");
newEaId = ea.lstSubuitgavesoort[0].Ea_Id;
// Verwijder infor uit Opmerking-veld
dbcDa.Open();
sqlStr = "Update Emailadres set Ea_Opmerking=@8 where Ea_Id = @1;";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
sqlCmd.Parameters.AddWithValue("@1", newEaId);
sqlCmd.Parameters.AddWithValue("@8", "");
sqlCmd.ExecuteNonQuery();
}
dbcDa.Close();
return(newEaId);
}
}
public suRecord vulDefaultSu()
{
pf pf = new pf();
suRecord suRec = new suRecord();
suRec.Sus_StatusId = 155009;
suRec.Sus_DispStatus = "Sus-record is leeg / Tabel-initrecord";
suRec.Sus_Kort = "Sus_kort";
suRec.Sus_Lang = "Sus_lang";
suRec.Sus_WijzigentoegestaanJN = 1;
suRec.Sus_HusId = 1;
suRec.Sus_DispHus = "";
suRec.Sus_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
suRec.Sus_Opmerking = "";
return(suRec);
}
public scRecord vulDefaultSc()
{
pf pf = new pf();
scRecord scRec = new scRecord();
scRec.Scat_StatusId = 160009;
scRec.Scat_DispStatus = "Scat-record is leeg / Tabel-initrecord";
scRec.Scat_Kort = "Scat_kort";
scRec.Scat_Lang = "Scat_lang";
scRec.Scat_HcatId = 1;
scRec.Scat_DispHcat = "";
scRec.Scat_Code = "";
scRec.Scat_WijzigentoegestaanJN = 1;
scRec.Scat_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
scRec.Scat_Opmerking = "";
return(scRec);
}
public bgRecord vulDefaultBg()
{
pf pf = new pf();
bgRecord bgRec = new bgRecord();
bgRec.Bgnr_StatusId = 110009;
bgRec.Bgnr_DispStatus = "Bankgironummer-record is leeg / Tabel-initrecord";
bgRec.Bgnr_SysteemBgnrJN = 0;
bgRec.Bgnr_KlBgId = 1;
bgRec.Bgnr_DispKlBg = "Klant-Begunstigde";
bgRec.Bgnr_Tnv = "";
bgRec.Bgnr_Kort = "000000000";
bgRec.Bgnr_Iban = "NL59ONBB0000000000";
bgRec.Bgnr_IbanBankGiroKas = "I";
bgRec.Bgnr_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
bgRec.Bgnr_Opmerking = "";
return(bgRec);
}
public void start_calc()
{
Debug.Log("start2");
pf_container[,] cont = new pf_container[razm, razm];
for (int i = 0; i < razm; i++)
{
for (int j = 0; j < razm; j++)
{
cont[i, j] = new pf_container(mass[i, j], new indexv2(i, j));
}
}
pf p = new pf();
ArrayList path = p.calc(cont, new indexv2(6, 6), new indexv2(34, 34));
foreach (pf_container node in path)
{
node.go.GetComponent <Square>().color = 4;
}
}
public agRecord vulDefaultAg()
{
pf pf = new pf();
agRecord agRec = new agRecord();
agRec.Adrsgeg_StatusId = 20009;
agRec.Adrsgeg_DispStatus = "Adresgegevens zijn leeg / Tabel-initrecord";
agRec.Adrsgeg_KlBgId = 1;
agRec.Adrsgeg_DispKlBg = "Klant-begunstigde";
agRec.Adrsgeg_Straatnaam = "Straatnaam";
agRec.Adrsgeg_Huisnummer = "0";
agRec.Adrsgeg_Huisnummertoevoeging = "";
agRec.Adrsgeg_Adres = "Straatnaam 0";
agRec.Adrsgeg_Postcode = "0000 AA";
agRec.Adrsgeg_Woonplaats = "Woonplaats";
agRec.Adrsgeg_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
agRec.Adrsgeg_Opmerking = "";
return(agRec);
}
public ugRecord vulDefaultUg()
{
pf pf = new pf();
ugRecord ugRec = new ugRecord();
ugRec.Ugv_StatusId = 140009;
ugRec.Ugv_DispStatus = "Uitgave-record is leeg / Tabel-initrecord";
ugRec.Ugv_KlBgId = 1;
ugRec.Ugv_DispKlBg = "Klant-Begunstigde";
ugRec.Ugv_HusId = 1;
ugRec.Ugv_DispHus = "";
ugRec.Ugv_SusId = 1;
ugRec.Ugv_DispSus = "";
ugRec.Ugv_Datum = DateTime.Parse("2000-01-01 00:00:00");
ugRec.Ugv_Kasbewijsnr = "0";
ugRec.Ugv_Bedrag = 0;
ugRec.Ugv_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
ugRec.Ugv_Opmerking = "";
return(ugRec);
}
public blRecord vulDefaultBl()
{
pf pf = new pf();
blRecord blRec = new blRecord();
blRec.Bstlr_BstlId = 1;
blRec.Bstlr_StatusId = 135009;
blRec.Bstlr_DispStatus = "Bestelregel-record is leeg / Tabelinitrecord";
blRec.Bstlr_StatusId = 1;
blRec.Bstlr_DispStatus = "Productnaam";
blRec.Bstlr_Aantal = 0;
blRec.Bstlr_Beginnr = 0;
blRec.Bstlr_Eindnr = 0;
blRec.Bstlr_Voorraad = 0;
blRec.Bstlr_Extranr1 = 0;
blRec.Bstlr_Extranr2 = 0;
blRec.Bstlr_Extranr3 = 0;
blRec.Bstlr_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
blRec.Bstlr_Opmerking = "";
return(blRec);
}
public async void TestRun(SystemParametersInfo.Action action, pf passfail)
{
var loggerFactory = new LoggerFactory();
var logger = loggerFactory.CreateLogger <SystemParametersInfoSettingsFinalizer>();
callCount = 0;
SystemParametersInfoSettingFinalizerTests.passfail = passfail;
var finalizer = new SystemParametersInfoSettingsFinalizer(new SystemParametersInfoSettingFinalizerDescription(action), new MockSystemParametersInfo(), logger);
var result = await finalizer.Run();
if (passfail == pf.PASS)
{
Assert.True(result);
}
else
{
Assert.False(result);
}
Assert.Equal(1, callCount);
}
public pdRecord vulDefaultPd()
{
pf pf = new pf();
pdRecord pdRec = new pdRecord();
pdRec.Prod_StatusId = 170009;
pdRec.Prod_DispStatus = "Product-record is leeg / Tabelinitrecord";
pdRec.Prod_Naamkort = "Prod_kort";
pdRec.Prod_Naamlang = "Prod_lang";
pdRec.Prod_Kleur = "Kleur";
pdRec.Prod_Code = "Prod_code";
pdRec.Prod_Soort = "B";
pdRec.Prod_ActiefJN = 0;
pdRec.Prod_Dispactief = "Nee";
pdRec.Prod_Waarde = 0;
pdRec.Prod_Aantaleenhedenperproduct = 20;
pdRec.Prod_Verzamelnaam = "vel";
pdRec.Prod_Waardepereenheid = 0;
pdRec.Prod_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
pdRec.Prod_Opmerking = "";
return(pdRec);
}
