private string BuildAddress1(NameAndAddress nameAndAddress)
{
if (!string.IsNullOrWhiteSpace(nameAndAddress.Address.Address1))
{
return(nameAndAddress.Address.Address1);
}
else
{
StringBuilder sb = new StringBuilder();
if (!string.IsNullOrWhiteSpace(nameAndAddress.CustomerAddress.HouseName))
{
sb.Append(nameAndAddress.CustomerAddress.HouseName);
sb.Append(", ");
}
if (!string.IsNullOrWhiteSpace(nameAndAddress.CustomerAddress.HouseNumber))
{
sb.Append(nameAndAddress.CustomerAddress.HouseNumber);
sb.Append(", ");
}
if (!string.IsNullOrWhiteSpace(nameAndAddress.CustomerAddress.Street))
{
sb.Append(nameAndAddress.CustomerAddress.Street);
sb.Append(", ");
}
if (!string.IsNullOrWhiteSpace(nameAndAddress.CustomerAddress.Street1))
{
sb.Append(nameAndAddress.CustomerAddress.Street1);
}
return(sb.ToString().Trim().TrimEnd(','));;
}
}
public List <CustomerMatchInfoDetails> GetMatchingCustomers(NameAndAddress nameAndAddress, SuppressionOptions suppressionOptions, string matchType)
{
CustomerMatchParameter customerMatchParameter = new CustomerMatchParameter();
customerMatchParameter.MatchType = matchType;
customerMatchParameter.Address1 = nameAndAddress.Address.Address1;
customerMatchParameter.Address2 = nameAndAddress.Address.Address2;
customerMatchParameter.Address3 = nameAndAddress.Address.Address3;
customerMatchParameter.Address4 = nameAndAddress.Address.Address4;
customerMatchParameter.Postcode = nameAndAddress.Address.Postcode;
customerMatchParameter.Dob = nameAndAddress.Dob;
customerMatchParameter.Phone = nameAndAddress.Phone;
customerMatchParameter.Email = nameAndAddress.Email;
customerMatchParameter.FirstName = nameAndAddress.FirstName;
customerMatchParameter.Surname = nameAndAddress.Surname;
customerMatchParameter.Title = nameAndAddress.Title;
List <MatchedCustomer> matchedCustomers = _customerDataAccess.GetMatchingCustomers(customerMatchParameter);
List <CustomerMatchInfoDetails> customerMatchDetails = new List <CustomerMatchInfoDetails>();
foreach (var c in matchedCustomers)
{
customerMatchDetails.Add(_customerDataAccess.GetCustomerMatchDetails(c.CustomerId, suppressionOptions));
}
return(customerMatchDetails);
}
public virtual CreateOrderRequest WithShipTo(NameAndAddress value)
{
Ensure.That(value, "value").IsNotNull();
ShipTo = value;
return(this);
}
public static void PopulateFromModel(this NameAndAddress sageNameAndAddress, Models.Data.NameAndAddress nameAndAddress)
{
if (nameAndAddress == null)
{
return;
}
sageNameAndAddress.Name = nameAndAddress.Name;
sageNameAndAddress.Address.PopulateFromModel(nameAndAddress.Address);
}
public NameAndAddressParameter()
{
NameAndAddress = new NameAndAddress();
ReturnMe = new ReturnMe();
ResponseRequestedItems = new List <string>();
AccessControl = new AccessControl();
SuppressionOptions = new SuppressionOptions {
IgnoreSuppression = true
};
}
public virtual CreateOrderRequest WithShipTo(Action <NameAndAddress> config)
{
Ensure.That(config, "config").IsNotNull();
var value = new NameAndAddress();
config(value);
return(WithShipTo(value));
}
public dynamic GetTravelSummary(int numeroId, NameAndAddress nameAndAddress = null)
{
//TravelSummaryStub stub = new TravelSummaryStub();
//return stub.Get();
int?pKey = 0;
if (nameAndAddress != null)
{
pKey = GetPersistantKey(nameAndAddress);
}
using (var conn = new SqlConnection(MciCrDbConnectionString))
{
using (var cmd = new SqlCommand("[MCC].[get_travel_summary]", conn))
{
try
{
cmd.Connection.Open();
var param = new SqlParameter("@p_numero_id", SqlDbType.Int);
param.SqlValue = numeroId;
cmd.Parameters.Add(param);
var param1 = new SqlParameter("@p_pkey", SqlDbType.Int);
param1.SqlValue = pKey;
cmd.Parameters.Add(param1);
cmd.CommandType = CommandType.StoredProcedure;
var ds = new DataSet();
var adapter = new SqlDataAdapter(cmd);
adapter.Fill(ds);
if (ds.Tables.Count == 0)
{
return("No Travel summary records found for the customer");
}
return(BuildTravelSummary(ds));
}
catch (SqlException ex)
{
_logger.Info("TravelSummary.GetTravelSummary (SqlException) :" + "ErrorTag: " + ErrorTagProvider.ErrorTagDatabase + " -- " + ex.Message, ex);
throw new Exception(string.Format(DatabaseMessage.DatabaseException, ErrorTagProvider.ErrorTagDatabase));
}
catch (Exception ex)
{
_logger.Info("TravelSummary.GetTravelSummary :" + "ErrorTag: " + ErrorTagProvider.ErrorTagDatabase + " -- " + ex.Message, ex);
throw new Exception(string.Format(DatabaseMessage.DatabaseException, ErrorTagProvider.ErrorTagDatabase));
}
}
}
}
private NameAndAddress ParseFrom(NameValueCollection d, string prefix)
{
var p = prefix;
var n = new NameAndAddress();
n.BusinessName = d.Pluck(p + "business_name");
n.Name = d.Pluck(p + "name");
n.Street = d.Pluck(p + "street");
n.Phone = d.Pluck(p + "phone");
n.City = d.Pluck(p + "city");
n.Zip = d.Pluck(p + "zip");
n.State = d.Pluck(p + "state");
n.Country = d.Pluck(p + "country");
n.CountryCode = d.Pluck(p + "country_code");
return(n);
}
public string Serialize()
{
var ret = new StringBuilder();
ret.Append(Utils.GetPaddingString(AccountNumber, 20, true));
ret.Append(Utils.GetPaddingString(AccountType, 2));
ret.Append(Utils.GetPaddingString(StartDate));
ret.Append(Utils.GetPaddingString(CloseDate));
ret.Append(Utils.GetPaddingString(MonthlyPayment, 6));
ret.Append(Utils.GetPaddingString(RepaymentPeriod, 3));
ret.Append(Utils.GetPaddingString(CurrentBalance, 7));
ret.Append(Utils.GetPaddingString(CreditBalanceIndicator, 1));
ret.Append(Utils.GetPaddingString(AccountStatus, 1));
ret.Append(Utils.GetPaddingString(SpecialInstructionIndicator, 1));
ret.Append(Utils.GetPaddingString(String.Empty, 150));
ret.Append(Utils.GetPaddingString(PaymentAmount, 6));
ret.Append(Utils.GetPaddingString(CreditBalanceIndicator, 1));
ret.Append(Utils.GetPaddingString(PreviousStatementBalance, 6));
ret.Append(Utils.GetPaddingString(PreviousStatementBalanceIndicator, 1));
ret.Append(Utils.GetPaddingString(NumberCashAdvances, 2));
ret.Append(Utils.GetPaddingString(ValueCashAdvances, 6));
ret.Append(Utils.GetPaddingString(PaymentCode, 1));
ret.Append(Utils.GetPaddingString(PromotionActivityFlag, 1));
ret.Append(Utils.GetPaddingString(String.Empty, 31));
ret.Append(Utils.GetPaddingString(TransientAssociationFlag, 1));
ret.Append(Utils.GetPaddingString(AirtimeFlag, 1));
ret.Append(Utils.GetPaddingString(FlagSettings, 1));
ret.Append(NameAndAddress.Serialize());
ret.Append(Utils.GetPaddingString(CreditLimit, 7));
ret.Append(Utils.GetPaddingString(DateBirth));
ret.Append(Utils.GetPaddingString(String.Empty, 1));
ret.Append(Utils.GetPaddingString(TransferredCollectionAccountFlag, 1));
ret.Append(Utils.GetPaddingString(BalanceType, 1));
ret.Append(Utils.GetPaddingString(CreditTurnover, 9));
ret.Append(Utils.GetPaddingString(PrimaryAccountIndicator, 1));
ret.Append(Utils.GetPaddingString(DefaultSatisfactionDate));
ret.Append(Utils.GetPaddingString(TransactionFlag, 1));
ret.Append(Utils.GetPaddingString(String.Empty, 25));
ret.Append(Utils.GetPaddingString(OriginalDefaultBalance, 7));
ret.Append(Utils.GetPaddingString(PaymentFrequency, 1));
ret.Append(Utils.GetPaddingString(NewAccountNumber, 20, true));
return(ret.ToString());
}
private int?GetPersistantKey(NameAndAddress nameAndAddress)
{
CustomerMatchParameter param = new CustomerMatchParameter();
param.FirstName = nameAndAddress.FirstName;
param.Surname = nameAndAddress.Surname;
param.Dob = nameAndAddress.Dob;
param.Title = nameAndAddress.Title;
param.Email = nameAndAddress.Email;
param.Phone = nameAndAddress.Phone;
param.Address1 = nameAndAddress.Address.Address1;
param.Address2 = nameAndAddress.Address.Address2;
param.Address3 = nameAndAddress.Address.Address3;
param.Address4 = nameAndAddress.Address.Address4;
param.Postcode = nameAndAddress.Address.Postcode;
param.MatchType = "NAME_AND_ADDRESS";
var matchedCustomers = _customerDataAccess.GetMatchingCustomers(param).FirstOrDefault();
return(matchedCustomers?.CustomerId);
}
public int?GetPersistantKey(NameAndAddress nameAndAddress)
{
CustomerMatchParameter param = new CustomerMatchParameter();
param.FirstName = nameAndAddress.FirstName;
param.Surname = nameAndAddress.Surname;
param.Dob = nameAndAddress.Dob;
param.Title = nameAndAddress.Title;
param.Email = nameAndAddress.Email;
param.Phone = nameAndAddress.Phone;
param.Address1 = nameAndAddress.Address.Address1;
param.Address2 = nameAndAddress.Address.Address2;
param.Address3 = nameAndAddress.Address.Address3;
param.Address4 = nameAndAddress.Address.Address4;
param.Postcode = nameAndAddress.Address.Postcode;
// GICTS-3 Customer Matching on first character : Don't set a default match type
//
param.MatchType = nameAndAddress.MatchType;
// changed for ACSU-113 to use passed value or default to POSTCODE_AND_NAME
/*
* if (string.IsNullOrEmpty(param.MatchType) == true)
* {
* // default to POSTCODE_AND_NAME
* param.MatchType = MatchType.POSTCODE_AND_NAME.ToString();
* }
* else
* {
* param.MatchType = nameAndAddress.MatchType;
* }
*/
var matchedCustomers = _mailingHistoryDataAccess.GetMatchingCustomers(param).FirstOrDefault();
return(matchedCustomers?.CustomerId);
}
public dynamic GetPermission(NameAndAddress nameAndAddress = null, IEnumerable <int> customerIdList = null)
{
return(_dataAccess.GetCustomerPermission(null, customerIdList, null, null));
}
public dynamic GetPermission(ReturnMePermissions parameter, NameAndAddress nameAndAddress, KeyValue keyValue)
{
return(_dataAccess.GetCustomerPermission(parameter, nameAndAddress, keyValue));
}
public MembershipParameters()
{
CustNameAndAddress = new NameAndAddress();
AccessControl = new AccessControl();
}
public List <MatchedCustomer> GetMatchedTemporaryMember(NameAndAddress p)
{
return(_dataAccess.GetMatchedTemporaryMember(p));
}
public dynamic GetMailingHistoryList(Models.MailingHistory.MailingHistory mailingHistory = null, NameAndAddress nameAndAddress = null, IEnumerable <int> customerIdList = null)
{
CustomerMatchParameter parameter = new CustomerMatchParameter();
if (nameAndAddress != null)
{
parameter.MatchType = "NAME_AND_ADDRESS";
parameter.Address1 = nameAndAddress.Address.Address1;
parameter.Address2 = nameAndAddress.Address.Address2;
parameter.Address3 = nameAndAddress.Address.Address3;
parameter.Address4 = nameAndAddress.Address.Address4;
parameter.Postcode = nameAndAddress.Address.Postcode;
parameter.Dob = nameAndAddress.Dob;
parameter.Phone = nameAndAddress.Phone;
parameter.Email = nameAndAddress.Email;
parameter.FirstName = nameAndAddress.FirstName;
parameter.Surname = nameAndAddress.Surname;
parameter.Title = nameAndAddress.Title;
if (mailingHistory != null)
{
parameter.FromDate = mailingHistory.FromDate;
parameter.ToDate = mailingHistory.ToDate;
parameter.Product = mailingHistory.Product;
}
}
List <ExpandoObject> expandoObject = new List <ExpandoObject>();
try
{
List <MatchedCustomer> customerIds = new List <MatchedCustomer>();
if (customerIdList == null)
{
customerIds = _dataAccess.GetMatchingCustomers(parameter);
}
else
{
foreach (var id in customerIdList)
{
customerIds.Add(new MatchedCustomer {
CustomerId = id
});
}
}
List <int> ids = new List <int>();
foreach (var item in customerIds)
{
ids.Add(item.CustomerId);
}
List <MailingHistoryResult> list = new List <MailingHistoryResult>();
if (mailingHistory != null)
{
list = _dataAccess.GetCustomerMailingHistory(null, ids, mailingHistory.Product,
mailingHistory.FromDate, mailingHistory.ToDate, string.Empty);
if (mailingHistory.FieldsTobeReturned.Contains(null) || mailingHistory.FieldsTobeReturned.Count == 0)
{
return(list);
}
}
else
{
list = _dataAccess.GetCustomerMailingHistory(null, ids, string.Empty,
null, null, null);
return(list);
}
DataShapedObject dataShapedObject = new DataShapedObject();
foreach (var item in list)
{
if (mailingHistory.FieldsTobeReturned != null &&
mailingHistory.FieldsTobeReturned.Count != 0)
{
expandoObject.Add(dataShapedObject.Create(item, mailingHistory.FieldsTobeReturned));
}
}
}
catch (Exception ex)
{
_logger.Info("MailingHistoryService.GetMailingHistoryList " + ex.Message, ex);
throw new Exception(ex.Message);
}
return(expandoObject);
}
public MembershipDataInputModel()
{
CustNameAndAddress = new NameAndAddress();
}
public Models.Customer.TravelSummary GetTravelSummary(int numeroId, NameAndAddress nameAndAddress = null)
{
return(_travelSummaryDataAccess.GetTravelSummary(numeroId, nameAndAddress));
}
public int?GetPersistantKey(NameAndAddress nameAndAddress)
{
var pkey = _mciRequestDataAccess.GetPersistantKey(nameAndAddress);
return(pkey);
}
private NameAndAddress ParseFrom(NameValueCollection d, string prefix)
{
var p = prefix;
var n = new NameAndAddress();
n.BusinessName = d.Pluck(p + "business_name");
n.Name = d.Pluck(p + "name");
n.Street = d.Pluck(p + "street");
n.Phone = d.Pluck(p + "phone");
n.City = d.Pluck(p + "city");
n.Zip = d.Pluck(p + "zip");
n.State = d.Pluck(p + "state");
n.Country = d.Pluck(p + "country");
n.CountryCode = d.Pluck(p + "country_code");
return n;
}
public void Setup()
{
_nameAndAddressValidator = new NameAndAddressValidator();
_nameAndAddress = new NameAndAddress();
}
public dynamic GetPermission(ReturnMePermissions parameter, NameAndAddress nameAndAddress, int customerId)
{
return(_dataAccess.GetCustomerPermission(parameter, nameAndAddress, customerId));
}
