public IEnumerable <ParameterResponseModel> GetStatus(AS400AppSettingModel appSettings)
{
string[] cond = new string[1];
cond[0] = "CP3UIC = '1'";
return(GetParameter(appSettings, cond));
}
public IEnumerable <ParameterResponseModel> Get(string lang = "EN")
{
string _value;
switch (lang)
{
case "TH":
_value = ConfigurationManager.AppSettings[nameof(AppSettings.AccountTypeTHValue)].ToString();
break;
case "EN":
_value = ConfigurationManager.AppSettings[nameof(AppSettings.AccountTypeENValue)].ToString();
break;
default:
_value = ConfigurationManager.AppSettings[nameof(AppSettings.AccountTypeENValue)].ToString();
break;
}
AS400AppSettingModel appSettings = new AS400AppSettingModel()
{
File = ConfigurationManager.AppSettings[nameof(AppSettings.AccountTypeFile)].ToString(),
Key = ConfigurationManager.AppSettings[nameof(AppSettings.AccountTypeKey)].ToString(),
Value = _value
};
return(_service.GetAccountType(appSettings));
}
public IEnumerable <ParameterResponseModel> Get(string lang = "EN")
{
string _value;
switch (lang)
{
case "TH":
_value = ConfigurationManager.AppSettings[nameof(AppSettings.FatcaDescriptionTHValue)].ToString();
break;
case "EN":
_value = ConfigurationManager.AppSettings[nameof(AppSettings.FatcaDescriptionENValue)].ToString();
break;
default:
_value = ConfigurationManager.AppSettings[nameof(AppSettings.FatcaDescriptionENValue)].ToString();
break;
}
AS400AppSettingModel appSetting = new AS400AppSettingModel()
{
File = ConfigurationManager.AppSettings[nameof(AppSettings.FatcaDescriptionFile)].ToString(),
Key = ConfigurationManager.AppSettings[nameof(AppSettings.FatcaDescriptionKey)].ToString(),
Value = _value
};
return(service.GetFatcaDescription(appSetting));
}
public IEnumerable <ParameterResponseModel> GetState(AS400AppSettingModel appSettings)
{
var keyconcat = "TRIM(TRIM(SSSCOC) CONCAT '' CONCAT SSSTAC)";
string[] cond =
{
"SSSCOC = 'TH'"
};
return(GetParameter(appSettings, cond, keyconcat));
}
public IEnumerable <ParameterResponseModel> GetPurposeOfAccountOpenCorp(AS400AppSettingModel appSettings)
{
string[] cond =
{
"CP9XIA = 'CF'",
"CP9XIT = 'KYC'",
"CP9XST = 'DEPPURNON'",
"CP9VTY = 'M'"
};
return(GetParameter(appSettings, cond));
}
public IEnumerable <ParameterResponseModel> Get()
{
AS400AppSettingModel appSetting = new AS400AppSettingModel()
{
File = ConfigurationManager.AppSettings[nameof(AppSettings.DocTypeFile)].ToString(),
Key = ConfigurationManager.AppSettings[nameof(AppSettings.DocTypeKey)].ToString(),
Value = ConfigurationManager.AppSettings[nameof(AppSettings.DocTypeValue)].ToString()
};
return(service.GetDocumentType(appSetting));
}
public IEnumerable <ParameterResponseModel> Get()
{
AS400AppSettingModel appSetting = new AS400AppSettingModel()
{
File = ConfigurationManager.AppSettings[nameof(AppSettings.KYCParameterFile)].ToString(),
Key = ConfigurationManager.AppSettings[nameof(AppSettings.KYCParameterKey)].ToString(),
Value = ConfigurationManager.AppSettings[nameof(AppSettings.KYCParameterValue)].ToString()
};
return(service.GetPurposeOfAccountOpen(appSetting));
}
public IEnumerable <ParameterResponseModel> Corporate()
{
AS400AppSettingModel appSetting = new AS400AppSettingModel()
{
File = ConfigurationManager.AppSettings[nameof(AppSettings.KYCParameterFile)].ToString(),
Key = ConfigurationManager.AppSettings[nameof(AppSettings.KYCParameterKey)].ToString(),
Value = ConfigurationManager.AppSettings[nameof(AppSettings.KYCParameterValue)].ToString()
};
return(service.GetSourceOfDepositCorp(appSetting));
}
public IEnumerable <ParameterResponseModel> Get()
{
AS400AppSettingModel appSetting = new AS400AppSettingModel()
{
File = ConfigurationManager.AppSettings[nameof(AppSettings.BOTOccuFile)].ToString(),
Key = ConfigurationManager.AppSettings[nameof(AppSettings.BOTOccuKey)].ToString(),
Value = ConfigurationManager.AppSettings[nameof(AppSettings.BOTOccuValue)].ToString()
};
return(service.GetBOTOccupation(appSetting));
}
public IEnumerable <ParameterResponseModel> Get()
{
AS400AppSettingModel appSetting = new AS400AppSettingModel()
{
File = ConfigurationManager.AppSettings[nameof(AppSettings.CountryRiskFile)].ToString(),
Key = ConfigurationManager.AppSettings[nameof(AppSettings.CountryRiskKey)].ToString(),
Value = ConfigurationManager.AppSettings[nameof(AppSettings.CountryRiskValue)].ToString()
};
return(service.GetCountryRisk(appSetting));
}
public IEnumerable <ParameterResponseModel> Get()
{
AS400AppSettingModel appSettings = new AS400AppSettingModel()
{
File = ConfigurationManager.AppSettings[nameof(AppSettings.StateOfThailandFile)].ToString(),
Key = ConfigurationManager.AppSettings[nameof(AppSettings.StateOfThailandKey)].ToString(),
Value = ConfigurationManager.AppSettings[nameof(AppSettings.StateOfThailandValue)].ToString()
};
return(service.GetState(appSettings));
}
public IEnumerable <ParameterResponseModel> Get()
{
AS400AppSettingModel appSetting = new AS400AppSettingModel()
{
File = ConfigurationManager.AppSettings[nameof(AppSettings.EduLevelFile)].ToString(),
Key = ConfigurationManager.AppSettings[nameof(AppSettings.EduLevelKey)].ToString(),
Value = ConfigurationManager.AppSettings[nameof(AppSettings.EduLevelValue)].ToString()
};
return(service.GetEducationLevel(appSetting));
}
public IEnumerable <ParameterResponseModel> Get()
{
AS400AppSettingModel appSettings = new AS400AppSettingModel()
{
File = ConfigurationManager.AppSettings[nameof(AppSettings.KYCParameterFile)].ToString(),
Key = ConfigurationManager.AppSettings[nameof(AppSettings.KYCParameterKey)].ToString(),
Value = ConfigurationManager.AppSettings[nameof(AppSettings.KYCParameterValue)].ToString()
};
return(_service.GetSourceOfIncome(appSettings));
}
public IEnumerable <ParameterResponseModel> GetSourceOfIncome(AS400AppSettingModel appSettings)
{
string[] cond =
{
"CP9XIA = 'CF'",
"CP9XIT = 'KYC'",
"CP9XST = 'ASSETSRC'",
"CP9VTY = 'M'"
};
return(GetParameter(appSettings, cond));
}
public IEnumerable <ParameterResponseModel> GetSourceOfDepositCorp(AS400AppSettingModel appSettings)
{
string[] cond =
{
"CP9XIA = 'CF'",
"CP9XIT = 'KYC'",
"CP9XST = 'DEPSRCNON'",
"CP9VTY = 'M'"
};
return(GetParameter(appSettings, cond));
}
public IEnumerable <ParameterResponseModel> GetParameter(AS400AppSettingModel appSettings, string[] condition = null, string keyconcat = "")
{
LIB = appSettingService.GetLibrary(appSettings.File);
FILE = appSettings.File;
KEY = appSettings.Key;
VALUE = appSettings.Value;
if (!string.IsNullOrEmpty(keyconcat))
{
SQL = SQL
.Replace($"[{ nameof(AppSettings.KEY) }]", KEY)
.Replace($"TRIM({KEY})", $"{keyconcat}")
.Replace($"[{ nameof(AppSettings.VALUE) }]", VALUE)
.Replace($"[LIB]", LIB)
.Replace($"[FILE]", FILE);
}
else
{
SQL = SQL
.Replace($"[{ nameof(AppSettings.KEY) }]", KEY)
.Replace($"[{ nameof(AppSettings.VALUE) }]", VALUE)
.Replace($"[LIB]", LIB)
.Replace($"[FILE]", FILE);
}
if (condition != null)
{
if (condition.Length > 0)
{
for (int i = 0; i < condition.Length; i++)
{
if (i == 0)
{
SQL += " WHERE " + condition[i];
}
else
{
SQL += " AND " + condition[i];
}
}
}
}
return(ExecuteGetParameter(SQL));
}
public IEnumerable <ParameterResponseModel> GetCountryRisk(AS400AppSettingModel appSettings)
{
AS400AppSettingModel countrySetting = new AS400AppSettingModel()
{
File = ConfigurationManager.AppSettings[nameof(AppSettings.CountryFile)].ToString(),
Key = ConfigurationManager.AppSettings[nameof(AppSettings.CountryKey)].ToString(),
Value = ConfigurationManager.AppSettings[nameof(AppSettings.CountryValue)].ToString()
};
var countryList = GetParameter(countrySetting);
SQL = @"SELECT TRIM([KEY]) AS [KEY], TRIM([VALUE]) AS [VALUE] FROM [LIB].[FILE]";
string[] cond =
{
"KCPCNR = 'Y'"
};
var coutryRiskList = GetParameter(appSettings, cond);
return(countryList.Where(s => coutryRiskList.Any(x => x.Key.Equals(s.Key))));
}
public IEnumerable <ParameterResponseModel> GetFatcaDescription(AS400AppSettingModel appSettings)
{
return(GetParameter(appSettings));
}
public IEnumerable <ParameterResponseModel> GetOccupationRisk(AS400AppSettingModel appSettings)
{
return(GetParameter(appSettings));
}
public IEnumerable <ParameterResponseModel> GetPrefixName(AS400AppSettingModel appSettings)
{
var keyconcat = "TRIM(CFTTCD CONCAT '' CONCAT CFTTTP)";
return(GetParameter(appSettings, null, keyconcat));
}
public IEnumerable <ParameterResponseModel> GetEducationLevel(AS400AppSettingModel appSettings)
{
return(GetParameter(appSettings));
}
public IEnumerable <ParameterResponseModel> GetAddressType(AS400AppSettingModel appSettings)
{
return(GetParameter(appSettings));
}
public IEnumerable <ParameterResponseModel> GetCountry(AS400AppSettingModel appSettings)
{
return(GetParameter(appSettings));
}
