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