/// <summary>
/// Calls a SP to insert an new request in TotalGiro
/// </summary>
void SaveToDB(int LoginId, WSAccountRequestData requestdata)
{
IDalSession session = NHSessionFactory.CreateSession();
ArrayList parameters = new ArrayList();
parameters.Add(new NHSession.ParamInfo("LoginId", LoginId, NHibernate.NHibernateUtil.Int32)); // int,
parameters.Add(new NHSession.ParamInfo("Titel", requestdata.Applicant.Title, NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("Naam", requestdata.Applicant.LastName, NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("Tussenvoegsels", requestdata.Applicant.MiddleName, NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("Voorletters", requestdata.Applicant.Initials, NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("Geslacht", requestdata.Applicant.Sex, NHibernate.NHibernateUtil.String));// varchar(1) = '',
parameters.Add(new NHSession.ParamInfo("Nationaliteit", requestdata.Applicant.Nationality, NHibernate.NHibernateUtil.String));// varchar(30) = '',
//ModelPortfolio
if (requestdata.Applicant.ContactDetails != null && requestdata.Applicant.ContactDetails.ResidentialAddress != null)
{
parameters.Add(new NHSession.ParamInfo("Straat", requestdata.Applicant.ContactDetails.ResidentialAddress.Street, NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("Huisnummer", requestdata.Applicant.ContactDetails.ResidentialAddress.HouseNumber, NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("HuisnummerToevoeging", requestdata.Applicant.ContactDetails.ResidentialAddress.HouseNumberSuffix, NHibernate.NHibernateUtil.String));// varchar(7) = '',
parameters.Add(new NHSession.ParamInfo("Postcode", requestdata.Applicant.ContactDetails.ResidentialAddress.PostalCode, NHibernate.NHibernateUtil.String));// varchar(7) = '',
parameters.Add(new NHSession.ParamInfo("Plaats", requestdata.Applicant.ContactDetails.ResidentialAddress.City, NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("Land", requestdata.Applicant.ContactDetails.ResidentialAddress.Country, NHibernate.NHibernateUtil.String));// varchar(30) = '',
}
else
{
parameters.Add(new NHSession.ParamInfo("Straat", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("Huisnummer", "", NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("HuisnummerToevoeging", "", NHibernate.NHibernateUtil.String));// varchar(7) = '',
parameters.Add(new NHSession.ParamInfo("Postcode", "", NHibernate.NHibernateUtil.String));// varchar(7) = '',
parameters.Add(new NHSession.ParamInfo("Plaats", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("Land", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
}
if (requestdata.Applicant.ContactDetails != null && requestdata.Applicant.ContactDetails.PostAddress != null)
{
parameters.Add(new NHSession.ParamInfo("PostStraat", requestdata.Applicant.ContactDetails.PostAddress.Street, NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("PostHuisnummer", requestdata.Applicant.ContactDetails.PostAddress.HouseNumber, NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("PostHuisnummerToevoeging", requestdata.Applicant.ContactDetails.PostAddress.HouseNumberSuffix, NHibernate.NHibernateUtil.String));// varchar(7) = '',
parameters.Add(new NHSession.ParamInfo("PostPostcode", requestdata.Applicant.ContactDetails.PostAddress.PostalCode, NHibernate.NHibernateUtil.String));// varchar(7) = '',
parameters.Add(new NHSession.ParamInfo("PostPlaats", requestdata.Applicant.ContactDetails.PostAddress.City, NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("PostLand", requestdata.Applicant.ContactDetails.PostAddress.Country, NHibernate.NHibernateUtil.String));// varchar(30) = '',
}
else
{
parameters.Add(new NHSession.ParamInfo("PostStraat", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("PostHuisnummer", "", NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("PostHuisnummerToevoeging", "", NHibernate.NHibernateUtil.String));// varchar(7) = '',
parameters.Add(new NHSession.ParamInfo("PostPostcode", "", NHibernate.NHibernateUtil.String));// varchar(7) = '',
parameters.Add(new NHSession.ParamInfo("PostPlaats", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("PostLand", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
}
parameters.Add(new NHSession.ParamInfo("Geboortedatum", requestdata.Applicant.BirthDate, NHibernate.NHibernateUtil.DateTime));// datetime = null,
parameters.Add(new NHSession.ParamInfo("SOFI", requestdata.Applicant.SOFINumber, NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("Email", requestdata.Applicant.ContactDetails.EMail, NHibernate.NHibernateUtil.String));// varchar(50) = '',
parameters.Add(new NHSession.ParamInfo("Telefoon", requestdata.Applicant.ContactDetails.PhoneWork, NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("TelefoonAvond", requestdata.Applicant.ContactDetails.PhonePrivate, NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("Mobiel", requestdata.Applicant.ContactDetails.PhoneMobile, NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("Fax", requestdata.Applicant.ContactDetails.PhoneFax, NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("LegitimatieSoort", requestdata.Applicant.Identification.Type, NHibernate.NHibernateUtil.String));// varchar(20) = '',
parameters.Add(new NHSession.ParamInfo("LegitimatieNummer", requestdata.Applicant.Identification.Number, NHibernate.NHibernateUtil.String));// varchar(20) = '',
parameters.Add(new NHSession.ParamInfo("LegitimatieGeldigTot", requestdata.Applicant.Identification.ValidityPeriod, NHibernate.NHibernateUtil.DateTime));// datetime = null,
if (requestdata.SecondApplicant != null)
{
parameters.Add(new NHSession.ParamInfo("PTitel", requestdata.SecondApplicant.Title, NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("PNaam", requestdata.SecondApplicant.LastName, NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("PTussenvoegsels", requestdata.SecondApplicant.MiddleName, NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("PVoorletters", requestdata.SecondApplicant.Initials, NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("PGeslacht", requestdata.SecondApplicant.Sex, NHibernate.NHibernateUtil.String));// varchar(1) = '',
}
else
{
parameters.Add(new NHSession.ParamInfo("PTitel", "", NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("PNaam", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("PTussenvoegsels", "", NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("PVoorletters", "", NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("PGeslacht", "", NHibernate.NHibernateUtil.String));// varchar(1) = '',
}
if (requestdata.SecondApplicant != null && requestdata.SecondApplicant.ContactDetails != null && requestdata.SecondApplicant.ContactDetails.ResidentialAddress != null)
{
parameters.Add(new NHSession.ParamInfo("PStraat", requestdata.SecondApplicant.ContactDetails.ResidentialAddress.Street, NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("PHuisnummer", requestdata.SecondApplicant.ContactDetails.ResidentialAddress.HouseNumber, NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("PHuisnummerToevoeging", requestdata.SecondApplicant.ContactDetails.ResidentialAddress.HouseNumberSuffix, NHibernate.NHibernateUtil.String));// varchar(7) = '',
parameters.Add(new NHSession.ParamInfo("PPostcode", requestdata.SecondApplicant.ContactDetails.ResidentialAddress.PostalCode, NHibernate.NHibernateUtil.String));// varchar(7) = '',
parameters.Add(new NHSession.ParamInfo("PPlaats", requestdata.SecondApplicant.ContactDetails.ResidentialAddress.City, NHibernate.NHibernateUtil.String));// varchar(30) = '',
}
else
{
parameters.Add(new NHSession.ParamInfo("PStraat", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("PHuisnummer", "", NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("PHuisnummerToevoeging", "", NHibernate.NHibernateUtil.String));// varchar(7) = '',
parameters.Add(new NHSession.ParamInfo("PPostcode", "", NHibernate.NHibernateUtil.String));// varchar(7) = '',
parameters.Add(new NHSession.ParamInfo("PPlaats", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
}
if (requestdata.SecondApplicant != null)
{
parameters.Add(new NHSession.ParamInfo("PGeboortedatum", requestdata.SecondApplicant.BirthDate, NHibernate.NHibernateUtil.DateTime));// datetime = null,
parameters.Add(new NHSession.ParamInfo("PSOFI", requestdata.SecondApplicant.SOFINumber, NHibernate.NHibernateUtil.String));// varchar(12) = '',
if (requestdata.SecondApplicant.ContactDetails != null)
{
parameters.Add(new NHSession.ParamInfo("PEmail", requestdata.SecondApplicant.ContactDetails.EMail, NHibernate.NHibernateUtil.String));// varchar(50) = '',
parameters.Add(new NHSession.ParamInfo("PTelefoon", requestdata.SecondApplicant.ContactDetails.PhoneWork, NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("PTelefoonAvond", requestdata.SecondApplicant.ContactDetails.PhonePrivate, NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("PMobiel", requestdata.SecondApplicant.ContactDetails.PhoneMobile, NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("PFax", requestdata.SecondApplicant.ContactDetails.PhoneFax, NHibernate.NHibernateUtil.String));// varchar(12) = '',
}
else
{
parameters.Add(new NHSession.ParamInfo("PEmail", "", NHibernate.NHibernateUtil.String));// varchar(50) = '',
parameters.Add(new NHSession.ParamInfo("PTelefoon", "", NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("PTelefoonAvond", "", NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("PMobiel", "", NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("PFax", "", NHibernate.NHibernateUtil.String));// varchar(12) = '',
}
}
else
{
parameters.Add(new NHSession.ParamInfo("PGeboortedatum", null, NHibernate.NHibernateUtil.DateTime));// datetime = null,
parameters.Add(new NHSession.ParamInfo("PSOFI", "", NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("PEmail", "", NHibernate.NHibernateUtil.String));// varchar(50) = '',
parameters.Add(new NHSession.ParamInfo("PTelefoon", "", NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("PTelefoonAvond", "", NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("PMobiel", "", NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("PFax", "", NHibernate.NHibernateUtil.String));// varchar(12) = '',
}
if (requestdata.SecondApplicant != null && requestdata.SecondApplicant.Identification != null)
{
parameters.Add(new NHSession.ParamInfo("PLegitimatieSoort", requestdata.SecondApplicant.Identification.Type, NHibernate.NHibernateUtil.String));// varchar(20) = '',
parameters.Add(new NHSession.ParamInfo("PLegitimatieNummer", requestdata.SecondApplicant.Identification.Number, NHibernate.NHibernateUtil.String));// varchar(20) = '',
parameters.Add(new NHSession.ParamInfo("PLegitimatieGeldigTot", requestdata.SecondApplicant.Identification.ValidityPeriod, NHibernate.NHibernateUtil.DateTime));// datetime = null,
}
else
{
parameters.Add(new NHSession.ParamInfo("PLegitimatieSoort", "", NHibernate.NHibernateUtil.String));// varchar(20) = '',
parameters.Add(new NHSession.ParamInfo("PLegitimatieNummer", "", NHibernate.NHibernateUtil.String));// varchar(20) = '',
parameters.Add(new NHSession.ParamInfo("PLegitimatieGeldigTot", null, NHibernate.NHibernateUtil.String));// datetime = null,
}
if (requestdata.SecondApplicant != null)
{
parameters.Add(new NHSession.ParamInfo("PNationaliteit", requestdata.SecondApplicant.Nationality, NHibernate.NHibernateUtil.String));// varchar(30) = '',
}
else
{
parameters.Add(new NHSession.ParamInfo("PNationaliteit", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
}
parameters.Add(new NHSession.ParamInfo("TegenRekening", requestdata.MoneyAccount, NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("Onttrekking", requestdata.PeriodicWithdrawal == true ? "Y" : "N", NHibernate.NHibernateUtil.String));// varchar(1) = '',
parameters.Add(new NHSession.ParamInfo("OnttrekkingBedrag", requestdata.PeriodicWithdrawalAmount.ToString(), NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("TegenRekeningTNV", requestdata.MoneyAccountHolder, NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("TegenRekeningPlaats", requestdata.MoneyAccountBankCity, NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("TegenRekeningBank", requestdata.MoneyAccountBank, NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("VerpandSoort", "", NHibernate.NHibernateUtil.String));// varchar(50) = '',
parameters.Add(new NHSession.ParamInfo("Pandhouder", requestdata.Ledger, NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("EersteInleg", requestdata.FirstDeposit.ToString(), NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("PeriodeInleg", "", NHibernate.NHibernateUtil.String));// varchar(1) = '',
parameters.Add(new NHSession.ParamInfo("PeriodiekeInleg", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("BNaam", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("BRechtsvorm", "", NHibernate.NHibernateUtil.String));// varchar(50) = '',
parameters.Add(new NHSession.ParamInfo("BStraat", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("BHuisnummer", "", NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("BHuisnummerToevoeging", "", NHibernate.NHibernateUtil.String));// varchar(7) = '',
parameters.Add(new NHSession.ParamInfo("BPostcode", "", NHibernate.NHibernateUtil.String));// varchar(7) = '',
parameters.Add(new NHSession.ParamInfo("BPlaats", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("BLand", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("DatumOprichting", null, NHibernate.NHibernateUtil.DateTime));// datetime = null,
parameters.Add(new NHSession.ParamInfo("KVK", "", NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("BEmail", "", NHibernate.NHibernateUtil.String));// varchar(50) = '',
parameters.Add(new NHSession.ParamInfo("BTelefoon", "", NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("BTelefoonAvond", "", NHibernate.NHibernateUtil.String));// varchar(12)='',
parameters.Add(new NHSession.ParamInfo("BMobiel", "", NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("BFax", "", NHibernate.NHibernateUtil.String));// varchar(12) = '',
parameters.Add(new NHSession.ParamInfo("BRekHouderTitel1", "", NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("BRekHouder1", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("BRekHouderTussenv1", "", NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("BRekHouderVoorl1", "", NHibernate.NHibernateUtil.String));// varchar(20) = '',
parameters.Add(new NHSession.ParamInfo("BRekHouderGeslacht1", "M", NHibernate.NHibernateUtil.String));// varchar(1) = '',
parameters.Add(new NHSession.ParamInfo("BBevoegdheid1", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("BRekHouderTitel2", "", NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("BRekHouder2", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
parameters.Add(new NHSession.ParamInfo("BRekHouderTussenv2", "", NHibernate.NHibernateUtil.String));// varchar(10) = '',
parameters.Add(new NHSession.ParamInfo("BRekHouderVoorl2", "", NHibernate.NHibernateUtil.String));// varchar(20) = '',
parameters.Add(new NHSession.ParamInfo("BRekHouderGeslacht2", "", NHibernate.NHibernateUtil.String));// varchar(1) = '',
parameters.Add(new NHSession.ParamInfo("BBevoegdheid2", "", NHibernate.NHibernateUtil.String));// varchar(30) = '',
/* Hardcoded to Vierlander */
parameters.Add(new NHSession.ParamInfo("Bedrijfafkorting", "VL", NHibernate.NHibernateUtil.String));// char(2) = ''
parameters.Add(new NHSession.ParamInfo("ModelPortfolio", requestdata.ModelPortfolio, NHibernate.NHibernateUtil.String));// char(50) = ''
parameters.Add(new NHSession.ParamInfo("IncludeOPALData", requestdata.IncludeOPALData, NHibernate.NHibernateUtil.Int16));// bit = 0
if (requestdata.Questionnaire != null)
{
// Write xml questionnaire to userprofle
XmlSerializer s = new XmlSerializer(typeof(WSQuestionnaire));
StringWriter sw = new StringWriter();
s.Serialize(sw,requestdata.Questionnaire);
parameters.Add(new NHSession.ParamInfo("UserProfile", sw.ToString(), NHibernate.NHibernateUtil.StringClob));// text
}
else
parameters.Add(new NHSession.ParamInfo("UserProfile", "", NHibernate.NHibernateUtil.StringClob));// text
if (requestdata.OPALData != null)
{
// Write xml questionnaire to userprofle
XmlSerializer s = new XmlSerializer(typeof(WSOPALData));
StringWriter sw = new StringWriter();
s.Serialize(sw, requestdata.OPALData);
parameters.Add(new NHSession.ParamInfo("OPALData", sw.ToString(), NHibernate.NHibernateUtil.StringClob));// text
}
else
parameters.Add(new NHSession.ParamInfo("OPALData", "", NHibernate.NHibernateUtil.StringClob));// text
session.ExecuteStoredProcedureParam(@"EXEC dbo.insertEGAanvraag_Finix
@LoginId = :LoginId,
@Titel = :Titel,
@Naam = :Naam,
@Tussenvoegsels = :Tussenvoegsels,
@Voorletters = :Voorletters,
@Geslacht = :Geslacht,
@Nationaliteit = :Nationaliteit,
@Straat = :Straat,
@Huisnummer = :Huisnummer,
@HuisnummerToevoeging = :HuisnummerToevoeging,
@Postcode = :Postcode,
@Plaats = :Plaats,
@Land = :Land,
@PostStraat = :PostStraat,
@PostHuisnummer = :PostHuisnummer,
@PostHuisnummerToevoeging = :PostHuisnummerToevoeging,
@PostPostcode = :PostPostcode,
@PostPlaats = :PostPlaats,
@PostLand = :PostLand,
@Geboortedatum = :Geboortedatum,
@SOFI = :SOFI,
@Email = :Email,
@Telefoon = :Telefoon,
@TelefoonAvond =:TelefoonAvond,
@Mobiel = :Mobiel,
@Fax = :Fax,
@LegitimatieSoort = :LegitimatieSoort,
@LegitimatieNummer = :LegitimatieNummer,
@LegitimatieGeldigTot = :LegitimatieGeldigTot,
@PTitel = :PTitel,
@PNaam = :PNaam,
@PTussenvoegsels = :PTussenvoegsels,
@PVoorletters = :PVoorletters,
@PGeslacht = :PGeslacht,
@PStraat = :PStraat,
@PHuisnummer = :PHuisnummer,
@PHuisnummerToevoeging = :PHuisnummerToevoeging,
@PPostcode = :PPostcode,
@PPlaats = :PPlaats,
@PGeboortedatum = :PGeboortedatum,
@PSOFI = :PSOFI,
@PEmail = :PEmail,
@PTelefoon = :PTelefoon,
@PTelefoonAvond = :PTelefoonAvond,
@PMobiel = :PMobiel,
@PFax = :PFax,
@PLegitimatieSoort = :PLegitimatieSoort,
@PLegitimatieNummer = :PLegitimatieNummer,
@PLegitimatieGeldigTot = :PLegitimatieGeldigTot,
@PNationaliteit = :PNationaliteit,
@TegenRekening = :TegenRekening,
@Onttrekking = :Onttrekking,
@OnttrekkingBedrag = :OnttrekkingBedrag,
@TegenRekeningTNV = :TegenRekeningTNV,
@TegenRekeningPlaats = :TegenRekeningPlaats,
@TegenRekeningBank = :TegenRekeningBank,
@VerpandSoort = :VerpandSoort,
@Pandhouder = :Pandhouder,
@EersteInleg = :EersteInleg,
@PeriodeInleg = :PeriodeInleg,
@PeriodiekeInleg = :PeriodiekeInleg,
@BNaam = :BNaam,
@BRechtsvorm = :BRechtsvorm,
@BStraat = :BStraat,
@BHuisnummer = :BHuisnummer,
@BHuisnummerToevoeging = :BHuisnummerToevoeging,
@BPostcode = :BPostcode,
@BPlaats = :BPlaats,
@BLand = :BLand,
@DatumOprichting = :DatumOprichting,
@KVK = :KVK,
@BEmail = :BEmail,
@BTelefoon = :BTelefoon,
@BTelefoonAvond = :BTelefoonAvond,
@BMobiel = :BMobiel,
@BFax = :BFax,
@BRekHouderTitel1 = :BRekHouderTitel1,
@BRekHouder1 = :BRekHouder1,
@BRekHouderTussenv1 = :BRekHouderTussenv1,
@BRekHouderVoorl1 = :BRekHouderVoorl1,
@BRekHouderGeslacht1 = :BRekHouderGeslacht1,
@BBevoegdheid1 = :BBevoegdheid1,
@BRekHouderTitel2 = :BRekHouderTitel2,
@BRekHouder2 = :BRekHouder2,
@BRekHouderTussenv2 = :BRekHouderTussenv2,
@BRekHouderVoorl2 = :BRekHouderVoorl2,
@BRekHouderGeslacht2 = :BRekHouderGeslacht2,
@BBevoegdheid2 = :BBevoegdheid2,
@Bedrijfafkorting = :Bedrijfafkorting,
@ModelPortfolio = :ModelPortfolio,
@IncludeOPALData = :IncludeOPALData,
@UserProfile = :UserProfile,
@OPALData = :OPALData
", parameters);
session.Close();
}
protected void createTestRequest()
{
WSRequest request = new WSRequest();
request.Version = "1.0";
request.Username = "******";
request.Password = "******";
WSAccountRequestData ard = new WSAccountRequestData();
ard.IncludeOPALData = 1;
ard.AccountNumber = "EGVL999999";
ard.FirstDeposit = 123456.34f;
ard.ModelPortfolio = "J";
ard.MoneyAccount = "P12345678";
ard.MoneyAccountHolder = "Kribbe";
ard.PeriodicWithdrawal = true;
ard.PeriodWithdrawal = "year";
ard.PeriodicWithdrawalAmount = 50f;
ard.Remisier = "Finix";
WSPerson person = new WSPerson();
person.BirthDate = new DateTime(1970, 6, 24);
person.LastName = "Kribbe";
person.Initials = "S";
person.Sex = "M";
person.Title = "ing";
person.SOFINumber = "179218773";
WSIdentification id = new WSIdentification();
id.Number = "999888777";
id.Type = "Paspoort";
id.ValidityPeriod = new DateTime(2010, 10, 10);
person.Identification = id;
WSAddress postaddress = new WSAddress("Herengracht", "199", "b", "1017EL", "Amsterdam", "Netherlands");
WSContactDetails contactdetails = new WSContactDetails();
contactdetails.PhoneMobile = "+31628785883";
contactdetails.PostAddress = postaddress;
person.ContactDetails = contactdetails;
ard.Applicant = person;
WSPerson person2 = new WSPerson();
person2.BirthDate = new DateTime(1968, 9, 24);
person2.LastName = "Partner";
person2.Initials = "B";
person2.Sex = "M";
person2.Title = "ir";
person2.SOFINumber = "782387678";
WSIdentification id2 = new WSIdentification();
id2.Number = "111222333";
id2.Type = "Rijbewijs";
id2.ValidityPeriod = new DateTime(2010, 10, 10);
person2.Identification = id2;
WSAddress postaddress2 = new WSAddress("Keizersgracht", "222", "", "1017AB", "Amsterdam", "Netherlands");
WSContactDetails contactdetails2 = new WSContactDetails();
contactdetails2.PhoneMobile = "+3162347802";
contactdetails2.PostAddress = postaddress2;
person2.ContactDetails = contactdetails2;
ard.SecondApplicant = person2;
request.UpdateRequestData = ard;
WSOPALData opaldata = new WSOPALData();
WSOPALInput opalinput = new WSOPALInput();
Results results = new Results();
results.SchemaName = "steven.xsd";
//results.Version = "1.0";
opalinput.outputresults = results;
opaldata.OpalInput = opalinput;
WSOPALOutput opaloutput = new WSOPALOutput();
Project project = new Project();
project.ProjectName = "project1";
opaloutput.OutputProject = project;
opaldata.OpalOutput = opaloutput;
request.UpdateRequestData.OPALData = opaldata;
// Serialize the request
XmlSerializer s = new XmlSerializer(typeof(WSRequest));
FileStream w = new FileStream("c:\\temp\\wsrequest.xml", FileMode.Create);
s.Serialize(w, request);
w.Close();
}
