/// <summary>
/// Reads request for requestVAN and
/// parse input
/// </summary>
/// <param name="xmlRequest">XML request</param>
/// <returns>ENettRequestVAN</returns>
public static ENettRequestVAN ReadRequest(string xmlRequest)
{
//XML Serialization
ENettRequestVAN RequestObject = new ENettRequestVAN();
XmlRootAttribute xRoot = new XmlRootAttribute();
xRoot.ElementName = XMLHeaderRequestVAN;
xRoot.IsNullable = true;
XmlSerializer mySerializer = new XmlSerializer(typeof(ENettRequestVAN), xRoot);
using (TextReader tr = new StringReader(xmlRequest))
{
RequestObject = (ENettRequestVAN)mySerializer.Deserialize(tr);
}
return(RequestObject);
}
// END EGE-85532
/// <summary>
/// Prepare new ENett Virtual Account Number (VAN)
/// </summary>
/// <param name="user">User</param>
/// <param name="reader">ENettVANRequestReader</param>
/// <returns>CompleteIssueVNettVANRequest</returns>
/// The below method is used for RequestVAN
public static CompleteIssueVNettVANRequest GetENettVANRequest(UserInfo user, ENettRequestVAN reader)
{
// Let's request a new VAN
IssueVNettVANRequest amdReq = new IssueVNettVANRequest();
CompleteIssueVNettVANRequest retval = new CompleteIssueVNettVANRequest();
// Will be returned from ECN
// Get ECN details
int issuedECN = Util.ConvertStringToInt(reader.ECN);
// Generate a new reference
string referenceId = GenerateENettTransactionID();
retval.SetReferenceId(referenceId);
amdReq.IntegratorReference = referenceId;
amdReq.IntegratorCode = GetIntegratorCode();
amdReq.IntegratorAccessKey = GetIntegratorAccessKey();
amdReq.RequesterECN = GetRequestorECN();
amdReq.IssuedToEcn = issuedECN;
amdReq.CountryCode = reader.Market;
amdReq.CurrencyCode = reader.Currency;
amdReq.CardTypeName = CardTypeName;
amdReq.FundingCurrencyCode = reader.Currency;
amdReq.MaximumAuthorisationAmount = Util.ConvertStringToLong(reader.MaxAuthAmount);
string activationDate = Util.ConvertDateToString(Util.ConvertStringToDate(reader.ActivationDate, Const.ExpirationDateFormat), Const.DateFormat_yyyyMMdd);
amdReq.ActivationDate = activationDate;
amdReq.ExpiryDate = Util.ConvertDateToString(Util.ConvertStringToDate(reader.ExpiryDate, Const.ExpirationDateFormat), Const.DateFormat_yyyyMMdd);
amdReq.IsMultiUse = Util.ConvertStringToBool(reader.IsMultiUse);
long minumumAuthorisationAmount = Util.ConvertStringToLong(reader.MinAuthAmount);
if (amdReq.IsMultiUse)
{
amdReq.IsMultiUseSpecified = true;
amdReq.MultiUseClosePercentage = Util.ConvertStringToInt(reader.MultiUseClosePercentage);
amdReq.MultiUseClosePercentageSpecified = true;
minumumAuthorisationAmount = 0L;
}
amdReq.MinimumAuthorisationAmount = minumumAuthorisationAmount;
// Add user references
amdReq.MerchantCategoryName = reader.MerchantCategory;
amdReq.UserReference1 = referenceId;
amdReq.UserReference2 = reader.UserName;
amdReq.UserReference3 = reader.Product;
string travelerName = "Unknown";
string travelerPercode = "Unknown";
// We need here to return traveler code and name
// It depends on which Enett implementation we are
// in the phase 1, percode and traveler name are provided for one traveller
// <PerCode>2001</PerCode>
// <TravellerName>Sudhakar</TravellerName>
// in phase 2, multiple travallers are sent
// so we need to extract the main traveller
// <Travellers>
// <Traveller>
// <IsMainTraveller>true</IsMainTraveller>
// <Name>Claire Burns</Name>
// ...
// </Traveller>
// <//Travellers>
//
if (String.IsNullOrEmpty(reader.PerCode))
{
// We have on phase 2 with multiple travellers
// we need to find the main traveler
List <ENettRequestVAN.Traveller> travs = reader.Travellers;
foreach (ENettRequestVAN.Traveller trav in travs)
{
if (Util.ConvertStringToBool(trav.IsMainTraveller))
{
// This is the main traveller
travelerPercode = trav.Percode;
travelerName = trav.Name;
}
}
}
else
{
// We are in phase 1, only one traveler is provided
travelerPercode = reader.PerCode;
travelerName = reader.TravellerName;
}
amdReq.UserReference4 = travelerName;
amdReq.Username = reader.UserName;
UserReference[] str = new UserReference[5];
str[0] = new UserReference();
str[0].Value = travelerPercode;
str[1] = new UserReference();
str[1].Value = Util.ConvertDateToString(Util.ConvertStringToDate(reader.BookingDate, Const.ExpirationDateFormat), Const.DateFormat_yyyyMMdd);
// Payment ID
str[2] = new UserReference();
str[2].Value = reader.SupplierName;
// Username
str[3] = new UserReference();
str[3].Value = string.Empty;
//>>EGE-6880
// new User Refernce for Channel
str[4] = new UserReference();
str[4].Value = reader.Channel;
//<<EGE-6880
amdReq.UserReferences = str;
// Get message digest
StringBuilder builder = new StringBuilder();
builder.Append(GetClientAccessKey());
builder.Append(referenceId);
builder.Append(activationDate);
builder.Append(CardTypeName);
builder.Append(reader.Currency);
builder.Append(issuedECN);
builder.Append(reader.MaxAuthAmount);
builder.Append(minumumAuthorisationAmount);
builder.Append(reader.MerchantCategory);
builder.Append(referenceId);
builder.Append(reader.UserName);
// Send message digest
string msgDigest = builder.ToString();
byte[] arr = Encoding.Default.GetBytes(msgDigest);
amdReq.MessageDigest = SHA1HashEncode(arr);
retval.SetIssuedVNettRequest(amdReq);
return(retval);
}
/// <summary>
/// Log VCard request in the table
/// </summary>
/// <param name="reader">ENettRequestVAN detail</param>
/// <param name="response">CompleteIssueVNettVANResponse</param>
public void InsertNewRequest(ENettRequestVAN reader, ENettRequestVAN.Traveller traveller, CompleteIssueVNettVANResponse response)
{
InsertNewRequest(reader, traveller.TravellerOrder, traveller.Percode, traveller.Name, traveller.CC1, traveller.CC2,
traveller.CC3, reader.Channel, response);
}
/// <summary>
/// Log VCard request in the table
/// </summary>
/// <param name="reader">XML request</param>
/// <param name="travelerOrder">Traveler order</param>
/// <param name="percode">Traveler code</param>
/// <param name="travelerName">Traveler Name</param>
/// <param name="cc1">Cost center 1</param>
/// <param name="cc2">Cost center 2</param>
/// <param name="cc3">Cost center 3</param>
/// <param name="channel">channel</param>
/// <param name="response">CompleteIssueVNettVANResponse</param>
public void InsertNewRequest(ENettRequestVAN reader, int travelerOrder, string percode, string travelerName
, string cc1, string cc2, string cc3, string channel, CompleteIssueVNettVANResponse response)
{
string request = String.Format("INSERT INTO VCardBooking ("
+ "PaymentId ,TravelerOrder, PosCode, Comcode, BookerPercode, TravelerPercode, TravelerName, AdultCount, AgentLogin, "
+ "BookingDate, FundedAmount, Currency, CardActivationDate, CardExpirationDate, IsMultiUseCard, "
+ "TruncatedVAN, Product, Channel, ECN, MerchantCategory, MdCode, RefDossierType, RefDossierCode, OriginDate, OriginAddress, "
+ "OriginLocationCode, OriginCountryCode, EndDate, EndAddress, EndLocationCode, EndCountryCode, SupplierName, "
+ "CC1, CC2, CC3, RequestDate, TripName, FreeText1, FreeText2, FreeText3, HotelId, "
//>>EGE-60949
//+ "ErrorCode, ErrorDesc, CreationDate, CreatedBy, ModificationDate, ModifiedBy, SupportLogId, VNettTransactionID) "
+ "ErrorCode, ErrorDesc, CreationDate, CreatedBy, ModificationDate, ModifiedBy, SupportLogId, VNettTransactionID, PosCurrency, VanCountryCode) "
//<< EGE-60949
+ "VALUES ("
+ "@PaymentId ,@TravelerOrder, @PosCode, @Comcode, @BookerPercode, @TravelerPercode, @TravelerName, @AdultCount, @AgentLogin, "
+ "@BookingDate, @FundedAmount, @Currency, @CardActivationDate, @CardExpirationDate, @IsMultiUseCard, "
+ "@TruncatedVAN, @Product, @Channel, @ECN, @MerchantCategory, @MdCode, @RefDossierType, @RefDossierCode, @OriginDate, @OriginAddress, "
+ "@OriginLocationCode, @OriginCountryCode, @EndDate, @EndAddress, @EndLocationCode, @EndCountryCode, @SupplierName, "
+ "@CC1, @CC2, @CC3, @RequestDate, @TripName, @FreeText1, @FreeText2, @FreeText3, @HotelId, "
//>>EGE-60949
//+ "@ErrorCode, @ErrorDesc, @CreationDate, @CreatedBy, @ModificationDate, @ModifiedBy, @SupportLogId, @VNettTransactionID)");
+ "@ErrorCode, @ErrorDesc, @CreationDate, @CreatedBy, @ModificationDate, @ModifiedBy, @SupportLogId, @VNettTransactionID, @PosCurrency, @VanCountryCode)");
//<< EGE-60949
// objet command
SqlCommand command = new SqlCommand(request, GetConnection());
try
{
// Send parameters
command.Parameters.Add("@PaymentId", SqlDbType.VarChar, 16);
command.Parameters["@PaymentId"].Value = Util.Nvl(response.GetReferenceId(), DBNull.Value);
command.Parameters.Add("@SupportLogId", SqlDbType.VarChar, 256);
command.Parameters["@SupportLogId"].Value = Util.Nvl(response.GetIssuedVNettResponse().SupportLogId, DBNull.Value);
command.Parameters.Add("@VNettTransactionID", SqlDbType.VarChar, 100);
command.Parameters["@VNettTransactionID"].Value = Util.Nvl(response.GetIssuedVNettResponse().VNettTransactionID, DBNull.Value);
//<< EGE-60949
command.Parameters.Add("@PosCode", SqlDbType.VarChar, 2);
command.Parameters["@PosCode"].Value = Util.Nvl(reader.PosCountryCode, DBNull.Value);
command.Parameters.Add("@PosCurrency", SqlDbType.VarChar, 3);
command.Parameters["@PosCurrency"].Value = Util.Nvl(reader.PosCurrency, DBNull.Value);
command.Parameters.Add("@VanCountryCode ", SqlDbType.VarChar, 2);
command.Parameters["@VanCountryCode "].Value = Util.Nvl(reader.Market, DBNull.Value);
//<< EGE-60949
command.Parameters.Add("@TravelerOrder", SqlDbType.Int);
command.Parameters["@TravelerOrder"].Value = travelerOrder;
//<< EGE-60949
//command.Parameters.Add("@PosCode", SqlDbType.VarChar, 2);
//command.Parameters["@PosCode"].Value = Util.Nvl(reader.Market, DBNull.Value);
//<< EGE-60949
command.Parameters.Add("@Comcode", SqlDbType.Int);
command.Parameters["@Comcode"].Value = Util.TryConvertStringToInt(reader.ComCode, DBNull.Value);
command.Parameters.Add("@BookerPercode", SqlDbType.BigInt);
command.Parameters["@BookerPercode"].Value = Util.TryConvertStringToLong(reader.BookerPerCode, DBNull.Value);
command.Parameters.Add("@TravelerPercode", SqlDbType.BigInt);
command.Parameters["@TravelerPercode"].Value = Util.TryConvertStringToLong(percode, DBNull.Value);
command.Parameters.Add("@TravelerName", SqlDbType.VarChar, 512);
command.Parameters["@TravelerName"].Value = Util.Nvl(travelerName, DBNull.Value);
command.Parameters.Add("@AdultCount", SqlDbType.Int);
command.Parameters["@AdultCount"].Value = Util.TryConvertStringToInt(reader.AdultsCount, DBNull.Value);
command.Parameters.Add("@AgentLogin", SqlDbType.VarChar, 100);
command.Parameters["@AgentLogin"].Value = Util.Nvl(reader.UserName, DBNull.Value);
command.Parameters.Add("@BookingDate", SqlDbType.DateTime);
command.Parameters["@BookingDate"].Value = Util.ConvertStringToDate(reader.BookingDate, Const.ExpirationDateFormat);
command.Parameters.Add("@FundedAmount", SqlDbType.Money);
command.Parameters["@FundedAmount"].Value = response.GetIssuedVNettResponse().IsSuccessful ?response.GetIssuedVNettResponse().FundedAmount:0;
command.Parameters.Add("@Currency", SqlDbType.VarChar, 3);
command.Parameters["@Currency"].Value = Util.Nvl(reader.Currency, DBNull.Value);
command.Parameters.Add("@CardActivationDate", SqlDbType.DateTime);
command.Parameters["@CardActivationDate"].Value = Util.ConvertStringToDate(reader.ActivationDate, Const.ExpirationDateFormat);
command.Parameters.Add("@CardExpirationDate", SqlDbType.DateTime);
command.Parameters["@CardExpirationDate"].Value = Util.ConvertStringToDate(reader.ExpiryDate, Const.ExpirationDateFormat);
command.Parameters.Add("@IsMultiUseCard", SqlDbType.Bit);
command.Parameters["@IsMultiUseCard"].Value = Util.ConvertStringToBool(reader.IsMultiUse) ? 1 : 0;
command.Parameters.Add("@TruncatedVAN", SqlDbType.VarChar, 16);
command.Parameters["@TruncatedVAN"].Value = response.GetIssuedVNettResponse().IsSuccessful ? CreditCardVerifier.TruncatePan(response.GetIssuedVNettResponse().VirtualAccountNumber) : string.Empty;
command.Parameters.Add("@Product", SqlDbType.VarChar, 30);
command.Parameters["@Product"].Value = Util.Nvl(reader.Product, DBNull.Value);
command.Parameters.Add("@Channel", SqlDbType.VarChar, 10);
command.Parameters["@Channel"].Value = Util.Nvl(channel, DBNull.Value);
command.Parameters.Add("@ECN", SqlDbType.Int);
command.Parameters["@ECN"].Value = Util.TryConvertStringToInt(reader.ECN, DBNull.Value);
command.Parameters.Add("@MerchantCategory", SqlDbType.VarChar, 30);
command.Parameters["@MerchantCategory"].Value = Util.Nvl(reader.MerchantCategory, DBNull.Value);
command.Parameters.Add("@MdCode", SqlDbType.Int);
command.Parameters["@MdCode"].Value = Util.TryConvertStringToInt(reader.MdCode, DBNull.Value);
command.Parameters.Add("@RefDossierType", SqlDbType.VarChar, 10);
command.Parameters["@RefDossierType"].Value = Util.Nvl(reader.RefDossierType, DBNull.Value);
command.Parameters.Add("@RefDossierCode", SqlDbType.Int);
command.Parameters["@RefDossierCode"].Value = Util.TryConvertStringToInt(reader.RefDossierCode, DBNull.Value);
// Origin date is not available in verion 1 of the XML
command.Parameters.Add("@OriginDate", SqlDbType.DateTime);
if (String.IsNullOrEmpty(reader.OriginDate))
{
command.Parameters["@OriginDate"].Value = DBNull.Value;
}
else
{
command.Parameters["@OriginDate"].Value = Util.ConvertStringToDate(reader.OriginDate, Const.ExpirationDateFormat);
}
command.Parameters.Add("@OriginAddress", SqlDbType.VarChar, 2000);
command.Parameters["@OriginAddress"].Value = Util.Nvl(reader.OriginLocationName, DBNull.Value);
command.Parameters.Add("@OriginLocationCode", SqlDbType.VarChar, 30);
command.Parameters["@OriginLocationCode"].Value = Util.Nvl(reader.OriginLocationCode, DBNull.Value);
command.Parameters.Add("@OriginCountryCode", SqlDbType.VarChar, 3);
command.Parameters["@OriginCountryCode"].Value = Util.Nvl(reader.OriginCountryCode, DBNull.Value);
// Origin date is not available in verion 1 of the XML
command.Parameters.Add("@EndDate", SqlDbType.DateTime);
if (String.IsNullOrEmpty(reader.EndDate))
{
command.Parameters["@EndDate"].Value = DBNull.Value;
}
else
{
command.Parameters["@EndDate"].Value = Util.ConvertStringToDate(reader.EndDate, Const.ExpirationDateFormat);
}
command.Parameters.Add("@EndAddress", SqlDbType.VarChar, 2000);
command.Parameters["@EndAddress"].Value = Util.Nvl(reader.EndLocationName, DBNull.Value);
command.Parameters.Add("@EndLocationCode", SqlDbType.VarChar, 30);
command.Parameters["@EndLocationCode"].Value = Util.Nvl(reader.EndLocationCode, DBNull.Value);
command.Parameters.Add("@EndCountryCode", SqlDbType.VarChar, 3);
command.Parameters["@EndCountryCode"].Value = Util.Nvl(reader.EndCountryCode, DBNull.Value);
command.Parameters.Add("@SupplierName", SqlDbType.VarChar, 512);
command.Parameters["@SupplierName"].Value = Util.Nvl(reader.SupplierName, DBNull.Value);
command.Parameters.Add("@CC1", SqlDbType.VarChar, 100);
command.Parameters["@CC1"].Value = Util.Nvl(cc1, DBNull.Value);
command.Parameters.Add("@CC2", SqlDbType.VarChar, 100);
command.Parameters["@CC2"].Value = Util.Nvl(cc2, DBNull.Value);
command.Parameters.Add("@CC3", SqlDbType.VarChar, 100);
command.Parameters["@CC3"].Value = Util.Nvl(cc3, DBNull.Value);
command.Parameters.Add("@RequestDate", SqlDbType.DateTime);
command.Parameters["@RequestDate"].Value = DateTime.Now;
command.Parameters.Add("@TripName", SqlDbType.VarChar, 256);
command.Parameters["@TripName"].Value = Util.Nvl(reader.TripName, DBNull.Value);
command.Parameters.Add("@FreeText1", SqlDbType.VarChar, 1000);
command.Parameters["@FreeText1"].Value = Util.Nvl(reader.FreeText1, DBNull.Value);
command.Parameters.Add("@FreeText2", SqlDbType.VarChar, 1000);
command.Parameters["@FreeText2"].Value = Util.Nvl(reader.FreeText2, DBNull.Value);
command.Parameters.Add("@FreeText3", SqlDbType.VarChar, 1000);
command.Parameters["@FreeText3"].Value = Util.Nvl(reader.FreeText3, DBNull.Value);
command.Parameters.Add("@HotelId", SqlDbType.BigInt);
command.Parameters["@HotelId"].Value = Util.TryConvertStringToLong(reader.HotelID, 0L);
command.Parameters.Add("@ErrorCode", SqlDbType.VarChar, 50);
command.Parameters["@ErrorCode"].Value = response.GetIssuedVNettResponse().IsSuccessful?0:response.GetIssuedVNettResponse().ErrorCode;
command.Parameters.Add("@ErrorDesc", SqlDbType.VarChar, 256);
command.Parameters["@ErrorDesc"].Value = response.GetIssuedVNettResponse().IsSuccessful ? string.Empty : response.GetIssuedVNettResponse().ErrorDescription;
// Technical infos
command.Parameters.Add("@CreationDate", SqlDbType.DateTime);
command.Parameters["@CreationDate"].Value = DateTime.Now;
command.Parameters.Add("@CreatedBy", SqlDbType.VarChar, 256);
command.Parameters["@CreatedBy"].Value = Util.Nvl(reader.AgentLogIn, DBNull.Value);
command.Parameters.Add("@ModificationDate", SqlDbType.DateTime);
command.Parameters["@ModificationDate"].Value = DateTime.Now;
command.Parameters.Add("@ModifiedBy", SqlDbType.VarChar, 256);
command.Parameters["@ModifiedBy"].Value = Util.Nvl(reader.AgentLogIn, DBNull.Value);
// Execute ...
command.ExecuteNonQuery();
}
catch (Exception e)
{
// Something wen wrong
throw new Exception(GetMessages().GetString("VCardLogConnection.Save.Error", response.GetReferenceId(), e.Message, true));
}
finally
{
DisposeCommand(command);
}
}
/// <summary>
/// Return values from ENett API
/// and prepare response to caller
/// </summary>
/// <param name="user">user</param>
/// <param name="vNettresponse">CompleteIssueVNettVANResponse</param>
/// <param name="ENettRequestVAN">ENettRequestVAN</param>
public void SetValues(UserInfo user, CompleteIssueVNettVANResponse vNettResponse, ENettRequestVAN reader)
{
if (!vNettResponse.GetIssuedVNettResponse().IsSuccessful)
{
// The request failed
// we need to get support log id from ENett
SetSupportLogId(vNettResponse.GetIssuedVNettResponse().SupportLogId);
// The request was not succesfully processed
// Set the exception code and message
SetException(user, new CEEException(vNettResponse.GetIssuedVNettResponse().ErrorCode.ToString()
, vNettResponse.GetIssuedVNettResponse().ErrorDescription).GetCompleteExceptionMessage());
// No need to go further!
return;
}
// The response is success
// Let's extract and return to caller all information
SetVNettTransactionID(vNettResponse.GetIssuedVNettResponse().VNettTransactionID);
SetPaymentID(vNettResponse.GetReferenceId());
SetVAN(vNettResponse.GetIssuedVNettResponse().VirtualAccountNumber);
SetActivationDate(Util.ConvertStringToDate(vNettResponse.GetIssuedVNettResponse().ActivationDate, Const.DateFormat_yyyyMMdd));
/// EGE - 70723 ENett Response Expiry Date send to FO
SetExpirationDate(Util.ConvertStringToDate(vNettResponse.GetIssuedVNettResponse().ExpiryDate, Const.DateFormat_MMyyyy));
SetCardSecurityCode(vNettResponse.GetIssuedVNettResponse().CardSecurityCode);
SetCardHolderName(vNettResponse.GetIssuedVNettResponse().CardHolderName);
SetFundedAmount(vNettResponse.GetIssuedVNettResponse().FundedAmount);
SetMultiUse(Util.ConvertStringToBool(reader.IsMultiUse));
SetCurrency(vNettResponse.GetIssuedVNettResponse().CurrencyCode);
}
