Hey guys i have a question about those 2 funtions
the error occures in 2 files my DataConnection. asmx.cs and Funtions.cs
error 1 is this il also paste a part of the code were the error is
DotNet.Function s' does not contain a definition for 'QuoteFix the filename were the code out is DataConnection. asmx.cs
my question about this is what thous the functie QuoteFix do
the next error is this in my DataConnection. asmx.cs file again
DotNet.Function s' does not contain a definition for 'chkValue
my question about this is what thous the functie chkValue do
I understand thats its a method and that i shud be in Functions.cs but i cant find those names anywere in the document with the search option. and i dont no what to do with it i dont whanne delete it right away thous anyone have on idee about what those functions cud do
Tanx Guys
the error occures in 2 files my DataConnection. asmx.cs and Funtions.cs
error 1 is this il also paste a part of the code were the error is
DotNet.Function s' does not contain a definition for 'QuoteFix the filename were the code out is DataConnection. asmx.cs
Code:
if (nieuw == true)
{
NoteID = "";
strNotes1 = "INSERT INTO offertesql (of_ref, of_datum, of_deb, of_klant, of_contact, of_straat, of_pcode, of_plaats, of_omschr, of_ordernr, of_uwref, of_totaalbtw_sql, of_btwbedr_sql, of_btw_sql, of_subtotaal_sql";
strNotes2 = "VALUES ('" + sReferentie + "', '" + sDatum + "', '" + sDebNr + "', '" + sKlant + "', '" + sContact + "', '" + sStraat + "', '" + sPcode + "', '" + sPlaats + "', '" + sOmschrijving + "', '" + sOrderNr + "', '" + sUwRef + "', " + dTotBTW + " , " + dBTW + " , " + dOf_BTW + " , " + dTotaal + " ";
if (iAant1 != "")
{
strNotes1 += ", of_dat1, of_art1, of_aant1, of_stuk_sql1, of_prijs_sql1";
strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat1)) + " , '" + sArt1 + "', " + iAant1 + " , " + dPStuk1 + " , " + dPrijs1;
}
if (iAant2 != "")
{
strNotes1 += ", of_dat2, of_art2, of_aant2, of_stuk_sql2, of_prijs_sql2";
strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat2)) + " , '" + sArt2 + "', " + iAant2 + " , " + dPStuk2 + " , " + dPrijs2;
}
if (iAant3 != "")
{
strNotes1 += ", of_dat3, of_art3, of_aant3, of_stuk_sql3, of_prijs_sql3";
strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat3)) + " , '" + sArt3 + "', " + iAant3 + " , " + dPStuk3 + " , " + dPrijs3;
}
if (iAant4 != "")
{
strNotes1 += ", of_dat4, of_art4, of_aant4, of_stuk_sql4, of_prijs_sql4";
strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat4)) + " , '" + sArt4 + "', " + iAant4 + " , " + dPStuk4 + " , " + dPrijs4;
}
if (iAant5 != "")
{
strNotes1 += ", of_dat5, of_art5, of_aant5, of_stuk_sql5, of_prijs_sql5";
strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat5)) + "', '" + sArt5 + "', " + iAant5 + " , " + dPStuk5 + " , " + dPrijs5;
}
if (iAant6 != "")
{
strNotes1 += ", of_dat6, of_art6, of_aant6, of_stuk_sql6, of_prijs_sql6";
strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat6)) + " , '" + sArt6 + "', " + iAant6 + " , " + dPStuk6 + " , " + dPrijs6;
}
if (iAant7 != "")
{
strNotes1 += ", of_dat7, of_art7, of_aant7, of_stuk_sql7, of_prijs_sql7";
strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat7)) + " , '" + sArt7 + "', " + iAant7 + " , " + dPStuk7 + " , " + dPrijs7;
}
if (iAant8 != "")
{
strNotes1 += ", of_dat8, of_art8, of_aant8, of_stuk_sql8, of_prijs_sql8";
strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat8)) + " , '" + sArt8 + "', " + iAant8 + " , " + dPStuk8 + " , " + dPrijs8;
}
if (iAant9 != "")
{
strNotes1 += ", of_dat9, of_art9, of_aant9, of_stuk_sql9, of_prijs_sql9";
strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat9)) + " , '" + sArt9 + "', " + iAant9 + " , " + dPStuk9 + " , " + dPrijs9;
}
if (iAant10 != "")
{
strNotes1 += ", of_dat10, of_art10, of_aant10, of_stuk_sql10, of_prijs_sql10";
strNotes2 += ", " + Functions.QuoteFix(Functions.DateToUS(sDat10)) + " , '" + sArt10 + "', " + iAant10 + " , " + dPStuk10 + " , " + dPrijs10;
}
strNotes1 = strNotes1 + ") " + strNotes2 + ")";
dbConn.Open();
SqlCommand SqlCmd = new SqlCommand(strNotes1, dbConn);
SqlCmd.ExecuteNonQuery();
dbConn.Close();
dbConn.Open();
SqlCommand SqlCmdID = new SqlCommand("SELECT MAX (NoteID) AS NoteID from offertesql", dbConn);
SqlDataReader SqlDrID = SqlCmdID.ExecuteReader(CommandBehavior.CloseConnection);
if(SqlDrID.Read())
{
NoteID = SqlDrID["NoteID"].ToString();
}
SqlDrID.Close();
dbConn.Close();
the next error is this in my DataConnection. asmx.cs file again
DotNet.Function s' does not contain a definition for 'chkValue
Code:
iAant1 = iAant1.Replace(",", ".");
iAant2 = iAant2.Replace(",", ".");
iAant3 = iAant3.Replace(",", ".");
iAant4 = iAant4.Replace(",", ".");
iAant5 = iAant5.Replace(",", ".");
iAant6 = iAant6.Replace(",", ".");
iAant7 = iAant7.Replace(",", ".");
iAant8 = iAant8.Replace(",", ".");
iAant9 = iAant9.Replace(",", ".");
iAant10 = iAant10.Replace(",", ".");
strSQL1 = "INSERT INTO Offerte (OfferteID, OfferteNr, Datum, DebNr, KlantNaam, Klantcontact, KlantStraat, KlantPcode, KlantPlaats, Omschrijving, OrderNr, ReferentieNr, BTW_bedr, SubTotaal, BTW, Totaal";
strSQL2 = "VALUES (" + NoteID + " , '" + sReferentie + "', '" + sDatum + "', '" + sDebNr + "', '" + sKlant + "', '" + sContact + "', '" + sStraat + "', '" + sPcode + "', '" + sPlaats + "', '" + sOmschrijving + "', '" + sOrderNr + "', '" + sUwRef + "', " + Functions.chkValue(dBTW) + " , " + Functions.chkValue(dTotaal) + " , " + Functions.chkValue(dOf_BTW) + " , " + Functions.chkValue(dTotBTW) + " ";
if (iAant1 != "")
{
strSQL1 += ", Datum1, Aantal1, Artikel1, PrijsStuk1, Prijs1";
strSQL2 += ", '" + sDat1 + "', " + iAant1 + " , '" + sArt1 + "', " + Functions.chkValue(dPStuk1) + " , " + Functions.chkValue(dPrijs1) + " ";
}
if (iAant2 != "")
{
strSQL1 += ", Datum2, Aantal2, Artikel2, PrijsStuk2, Prijs2";
strSQL2 += ", '" + sDat2 + "', " + iAant2 + " , '" + sArt2 + "', " + Functions.chkValue(dPStuk2) + " , " + Functions.chkValue(dPrijs2) + " ";
}
if (iAant3 != "")
{
strSQL1 += ", Datum3, Aantal3, Artikel3, PrijsStuk3, Prijs3";
strSQL2 += ", '" + sDat3 + "', " + iAant3 + " , '" + sArt3 + "', " + Functions.chkValue(dPStuk3) + " , " + Functions.chkValue(dPrijs3) + " ";
}
if (iAant4 != "")
{
strSQL1 += ", Datum4, Aantal4, Artikel4, PrijsStuk4, Prijs4";
strSQL2 += ", '" + sDat4 + "', " + iAant4 + " , '" + sArt4 + "', " + Functions.chkValue(dPStuk4) + " , " + Functions.chkValue(dPrijs4) + " ";
}
if (iAant5 != "")
{
strSQL1 += ", Datum5, Aantal5, Artikel5, PrijsStuk5, Prijs5";
strSQL2 += ", '" + sDat5 + "', " + iAant5 + " , '" + sArt5 + "', " + Functions.chkValue(dPStuk5) + " , " + Functions.chkValue(dPrijs5) + " ";
}
if (iAant6 != "")
{
strSQL1 += ", Datum6, Aantal6, Artikel6, PrijsStuk6, Prijs6";
strSQL2 += ", '" + sDat6 + "', " + iAant6 + " , '" + sArt6 + "', " + Functions.chkValue(dPStuk6) + " , " + Functions.chkValue(dPrijs6) + " ";
}
if (iAant7 != "")
{
strSQL1 += ", Datum7, Aantal7, Artikel7, PrijsStuk7, Prijs7";
strSQL2 += ", '" + sDat7 + "', " + iAant7 + " , '" + sArt7 + "', " + Functions.chkValue(dPStuk7) + " , " + Functions.chkValue(dPrijs7) + " ";
}
if (iAant8 != "")
{
strSQL1 += ", Datum8, Aantal8, Artikel8, PrijsStuk8, Prijs8";
strSQL2 += ", '" + sDat8 + "', " + iAant8 + " , '" + sArt8 + "', " + Functions.chkValue(dPStuk8) + " , " + Functions.chkValue(dPrijs8) + " ";
}
if (iAant9 != "")
{
strSQL1 += ", Datum9, Aantal9, Artikel9, PrijsStuk9, Prijs9";
strSQL2 += ", '" + sDat9 + "', " + iAant9 + " , '" + sArt9 + "', " + Functions.chkValue(dPStuk9) + " , " + Functions.chkValue(dPrijs9) + " ";
}
if (iAant10 != "")
{
strSQL1 += ", Datum10, Aantal10, Artikel10, PrijsStuk10, Prijs10";
strSQL2 += ", '" + sDat10 + "', " + iAant10 + " , '" + sArt10 + "', " + Functions.chkValue(dPStuk10) + " , " + Functions.chkValue(dPrijs10) + " ";
}
strSQL1 = strSQL1 + ") " + strSQL2 + ")";
dbConn.Open();
SqlCommand SQLCmd = new SqlCommand(strSQL1, dbConn);
SQLCmd.ExecuteReader(CommandBehavior.CloseConnection);
dbConn.Close();
I understand thats its a method and that i shud be in Functions.cs but i cant find those names anywere in the document with the search option. and i dont no what to do with it i dont whanne delete it right away thous anyone have on idee about what those functions cud do
Tanx Guys