www.hkvforums.com

Hi Experts,

on row_inserting I need to call an external page to send sms and then return to row_inserting event.
Ex:
var kunderow = ew_ExecuteRow("SELECT * FROM KUNDER WHERE Kundeid = " + rsnew["kunde1"]);
var bilrow = ew_ExecuteRow("SELECT * FROM BILDATA WHERE BilId = " + rsnew["salgsbil"]);
var rno = ew_ExecuteScalar("SELECT MAX(sagsid) FROM bilsager");
var rnoo = Convert.ToInt32(rno) + 1;
int cchk = 1;
if (rsnew["betaling"].Equals(cchk))
{
}
else
{
string insertfkontrakt = "INSERT INTO finanskontrakter (eksternnr, leaspartner, bilid, kundenr, opretdato, startdato, slutdato, [sælger], udbetalingex, mndex, scrap, bonus, garant, ktype, sagsnr, aftaltkm) VALUES ('', 1, " + rsnew["salgsbil"] + ", " + rsnew["kunde1"]+ ", '" + rsnew["opdato"] + "', '" + rsnew["opdato"] + "', '" + rsnew["opdato"] + "', " + rsnew["saelger"] + ", 0, 0, 0, 0, 0, 2, " + rnoo + ", 0)";
ew_Execute(insertfkontrakt);
}
---------------------> call external url/sendsms.asp?paper=rnoo and then continue below

string insertarbkort = "INSERT INTO arbejdskort (kundenr, navn, adresse, pnrby, telefon, [email], bilsagsnr, [regnr], maerkemodel, stelnr, kmnu, [odato], opretaf, indlevdato, lovetfaerdig, medarbansv, [status], opgavetype, opgavetxt, afsluttxt) VALUES (" + rsnew["kunde1"]+ ", '" + kunderow["navn1"] + "', '" + kunderow["adresse1"] + "', '" + kunderow["pnrby"] + "', '" + kunderow["telefon"] + "', '" + kunderow["email"] + "', " + rnoo + ", '', '" + bilrow["maerke"] + "', '" + bilrow["stelnummer"] + "', " + bilrow["km"] + ", '" + rsnew["opdato"] + "',1 ,'" + rsnew["opdato"] + "', '" + rsnew["levdato"] + "', 1, 1, 3, '" + rsnew["exaftaler"] + "', '*'" + ")";
ew_Execute(insertarbkort);

string sUpdateSql = "UPDATE Bildata SET solgt = '" + rsnew["levdato"] + "', solgtaf = " + rsnew["saelger"] + ", tilsalgstatus = 4 WHERE Bilid = " + rsnew["salgsbil"];
ew_Execute(sUpdateSql);

Thanks in advance

Michael Fiil from Denmark

Did you mean you want to run an external Classic ASP page within a ASP.NET Core C# application? If so, google "C# HttpClient". Use it to access the Classic ASP page.

Thank you Motfs
Very simple when you know how :-)

var client = new WebClient();
var text = client.DownloadString("..../sms/sendsms.asp?sagnr=" + rnoo);

Best regards Michael