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