public static Personal GetPersonal(AccountOpeningRequest c)
{
Personal u = new Personal();
u.MAINTENANCE_SEQ_NO = Commons.Helpers.Utility.GetReferenceNo();
u.CUSTOMER_PREFIX = c.CUSTOMER_PREFIX;
u.FIRST_NAME = c.FIRST_NAME;
u.MIDDLE_NAME = c.MIDDLE_NAME;
u.LAST_NAME = c.LAST_NAME;
u.DATE_OF_BIRTH = c.DATE_OF_BIRTH;
u.MINOR = c.MINOR;
u.SEX = c.SEX;
u.D_ADDRESS1 = c.D_ADDRESS1;
u.D_ADDRESS2 = c.D_ADDRESS2;
u.D_ADDRESS3 = c.D_ADDRESS3;
u.CONVERSION_STATUS_FLAG = "U";
//u.MAINTENANCE_SEQ_NO = "";
u.PASSPORT_NO = c.PASSPORT_NO;
u.PPT_ISS_DATE = c.PPT_ISS_DATE;
u.PPT_EXP_DATE = c.PPT_EXP_DATE;
u.TELEPHONE = c.TELEPHONE;
u.FAX = c.FAX;
u.E_MAIL = c.E_MAIL;
u.P_ADDRESS1 = c.P_ADDRESS1;
u.P_ADDRESS3 = c.P_ADDRESS3;
u.P_ADDRESS2 = c.P_ADDRESS2;
u.D_COUNTRY = c.COUNTRY;
u.P_COUNTRY = c.COUNTRY;
return(u);
}
public static Customer GetCustomer(AccountOpeningRequest c)
{
Customer u = new Customer();
u.SOURCE_CODE = "CUST_UPD";
u.MAINTENANCE_SEQ_NO = Commons.Helpers.Utility.GetReferenceNo();// = helper.GetReferenceNo();
u.CUSTOMER_NO = "AUTO";
u.CUSTOMER_TYPE = c.CUSTOMER_TYPE;
u.CUSTOMER_NAME1 = c.CUSTOMER_NAME;
u.ADDRESS_LINE1 = c.D_ADDRESS1;
u.ADDRESS_LINE3 = c.D_ADDRESS3;
u.ADDRESS_LINE2 = c.D_ADDRESS2;
u.ADDRESS_LINE4 = c.D_ADDRESS4;
u.COUNTRY = c.COUNTRY;
u.SHORT_NAME = c.SHORT_NAME;
u.NATIONALITY = c.NATIONALITY;
u.LANGUAGE = c.LANGUAGE;
u.EXPOSURE_COUNTRY = c.COUNTRY;
u.LOCAL_BRANCH = c.BRANCH_CODE;
u.LIABILITY_NO = "AUTO";
u.FROZEN = "N";
u.DECEASED = "N";
u.WHEREABOUTS_UNKNOWN = "N";
u.CUSTOMER_CATEGORY = c.CUSTOMER_CATEGORY;
u.FX_CUST_CLEAN_RISK_LIMIT = "0";
u.OVERALL_LIMIT = "0";
u.FX_CLEAN_RISK_LIMIT = "0";
u.CREDIT_RATING = "";
u.REVISION_DATE = DateTime.Now.ToString();
u.LIMIT_CCY = "CDF";
u.CAS_CUST = "N";
u.CONVERSION_STATUS_FLAG = "U";
u.SEC_CLEAN_RISK_LIMIT = "0";
u.SEC_CUST_PSTL_RISK_LIMIT = "0";
u.SEC_PSTL_RISK_LIMIT = "0";
u.SWIFT_CODE = "";
u.LIAB_BR = "";
u.LIAB_NODE = "DRCONGDB";
u.DEFAULT_MEDIA = "SWIFT";
u.SHORT_NAME2 = "";
u.SSN = "";
u.ACTION_CODE = "NEW";
u.UTILITY_PROVIDER = "N";
u.MAILERS_REQUIRED = "N";
u.AML_REQUIRED = "N";
u.FT_ACCTING_AS_OF = "N";
u.CUST_UNADVISED = "N";
u.LIAB_UNADVISED = "N";
u.CONSOL_TAX_CERT_REQD = "N";
u.INDIVIDUAL_TAX_CERT_REQD = "N";
u.UNIQUE_ID_NAME = c.UNIQUE_ID_NAME;
u.UNIQUE_ID_VALUE = c.UNIQUE_ID_VALUE;
u.FAX_NUMBER = c.FAX;
u.SEC_CUST_CLEAN_RISK_LIMIT = "0";
return(u);
}
public async Task <IActionResult> create([FromBody] AccountOpeningRequest request, bool customerOnly = false)
{
AccountOpeningResponse aor = new AccountOpeningResponse();
List <string> messages = new List <string>();
ExecuteCustomer e = new ExecuteCustomer()
{
BranchCode = request.BRANCH_CODE,
BranchNode = "DRCONGDB",
UserId = "SYSTEM",
SourceCode = "CUST_UPD"
};
try
{
if (!ModelState.IsValid)
{
return(BadRequest(Commons.Helpers.Utility.GetResponse(ModelState)));
}
if (!string.IsNullOrEmpty(request.CUSTOMER_NO))
{
bool customerExists = await _orclRepo.CustomerExist(request.CUSTOMER_NO);
if (customerExists)
{
aor = await CreateAccount(request, e, request.CUSTOMER_NO);
}
}
else
{
var tuple = await CreateCustomer(request, e);
if (tuple.Item1)
{
if (customerOnly)
{
return(CreatedAtAction("create", await _orclRepo.GetAccountOpeningResponseCustomerOnly(tuple.Item2.MAINTENANCE_SEQ_NO)));
}
aor = await CreateAccount(request, e, tuple.Item2.MAINTENANCE_SEQ_NO);
}
}
}
catch (Exception ex)
{
//_logger.LogError(ex.ToString(), a);
return(StatusCode((int)HttpStatusCode.InternalServerError, Commons.Helpers.Utility.GetResponse(ex)));
}
return(CreatedAtAction("create", aor));
}
public AccountOpeningResponse ProcessAccountOpening(AccountOpeningRequest objaccrequest)
{
try
{
{
objaccresp.accopeningresponse = objclsDashboard.GetAccountOpeningData(objaccrequest.accdatetime);
return(objaccresp);
}
}
catch (Exception)
{
return(objaccresp);
}
finally
{
objaccresp = null;
objclsDashboard = null;
}
}
private async Task <Tuple <bool, Customer> > CreateCustomer(AccountOpeningRequest request, ExecuteCustomer e)
{
Customer c = new Customer();
Personal p = new Personal();
bool isCustomerAdded = false;
bool isCustomerExecuted = false;
try
{
//Get Customer
c = Utility.GetCustomer(request);
_logger.LogInformation("requested upload customer");
//Get Personal
p = Utility.GetPersonal(request);
_logger.LogInformation("requested upload personal");
//Insert Customer Details
isCustomerAdded = await _orclRepo.AddCustomer(p, c);
_logger.LogInformation($"requested add customer with output: {isCustomerAdded}");
//Execute New Customer
isCustomerExecuted = await _orclRepo.ExecuteNewCustomer(e);
_logger.LogInformation($"requested execute customer with output: {isCustomerExecuted}");
}
catch (Exception ex)
{
_logger.LogError(ex.ToString());
}
return(new Tuple <bool, Customer>(isCustomerAdded && isCustomerExecuted, c));
}
private async Task <AccountOpeningResponse> CreateAccount(AccountOpeningRequest request, ExecuteCustomer e, string param)
{
bool isAccountAdded = false;
bool isAccountExecuted = false;
Account u = new Account();
AccountOpeningRequest req = null;
AccountOpeningResponse res = new AccountOpeningResponse();
try
{
//Get Account
if (!string.IsNullOrEmpty(request.CUSTOMER_NO))
{
req = await _orclRepo.GetCustomerByNumber(param, request.ACCOUNT_CLASS);
}
else
{
req = await _orclRepo.GetCustomer(param, request.ACCOUNT_CLASS);
}
//Remove Debugger on go live
_logger.LogInformation($"MAINTENANCE_SEQ_NO : {param} ACCOUNT_CLASS " +
$": {request.ACCOUNT_CLASS} CustomerNo: {req.CUSTOMER_NO} CR_HO_LINE: {req.CR_HO_LINE} " +
$"DR_HO_LINE: {req.DR_HO_LINE}");
request.CUSTOMER_NO = req?.CUSTOMER_NO;
request.DR_CB_LINE = req?.DR_CB_LINE;
request.CR_CB_LINE = req?.CR_CB_LINE;
request.CR_HO_LINE = req?.CR_HO_LINE;
request.DR_HO_LINE = req?.DR_HO_LINE;
request.DR_GL = req?.DR_GL;
request.CR_GL = req?.CR_GL;
e.SourceCode = "CUSTACC_UPLOAD";
u = Utility.GetAccount(request);
_logger.LogInformation("requested upload account");
//InsertAccount Detail
isAccountAdded = await _orclRepo.AddAccount(u);
_logger.LogInformation($"requested add account with output: {isAccountAdded}");
//Execute New Customer
isAccountExecuted = await _orclRepo.ExecuteNewAccount(e);
_logger.LogInformation($"requested execute customer with output: {isAccountExecuted}");
}
catch (Exception ex)
{
_logger.LogError(ex.ToString());
}
if (isAccountAdded && isAccountExecuted)
{
try
{
res = await _orclRepo.GetAccountOpeningResponse(u.MAINTENANCE_SEQ_NO);
}
catch (Exception ex)
{
_logger.LogError(ex.ToString());
}
}
return(res);
}
public static Account GetAccount(AccountOpeningRequest c)
{
Account u = new Account();
u.MAINTENANCE_SEQ_NO = Commons.Helpers.Utility.GetReferenceNo(); //=helper.GetReferenceNo();
u.SOURCE_CODE = "CUSTACC_UPLOAD";
u.BRANCH_CODE = c.BRANCH_CODE;
u.CUST_AC_NO = "AUTO";
u.AC_DESC = c.CUSTOMER_NAME;
u.CUST_NO = c.CUSTOMER_NO;
u.CCY = c.AMOUNTS_CCY;
u.ACCOUNT_CLASS = c.ACCOUNT_CLASS;
u.AC_STAT_NO_DR = "N";
u.AC_STAT_NO_CR = "N";
u.AC_STAT_BLOCK = "N";
u.AC_STAT_STOP_PAY = "N";
u.AC_STAT_DORMANT = "N";
u.JOINT_AC_INDICATOR = "S";
u.AC_OPEN_DATE = DateTime.Parse("23-JUL-2018"); //DateTime.Parse(DateTime.Now.ToString("dd-MMM-yyyy"));// DateTime.Parse("11-JAN-2019"); //DateTime.Now;//23-JUL-2018
u.AC_STMT_DAY = 31;
u.AC_STMT_CYCLE = "M";
u.ACC_STMT_DAY2 = 31;
u.AC_STMT_CYCLE2 = "M";
u.ACC_STMT_TYPE2 = "D";
u.CHEQUE_BOOK_FACILITY = "Y";
u.ATM_FACILITY = "Y";
u.PASSBOOK_FACILITY = "Y";
u.AC_STMT_TYPE = "D";
u.GEN_STMT_ONLY_ON_MVMT2 = "N";
u.GEN_STMT_ONLY_ON_MVMT3 = "N";
u.ACC_STMT_DAY3 = 31;
u.AC_STMT_CYCLE3 = "M";
u.ACC_STMT_TYPE3 = "D";
u.DR_HO_LINE = c.DR_HO_LINE;
u.CR_HO_LINE = c.CR_HO_LINE;
u.CR_CB_LINE = c.CR_CB_LINE;
u.DR_CB_LINE = c.DR_CB_LINE;
u.DR_GL = c.DR_GL;
u.CR_GL = c.CR_GL;
u.ADDRESS1 = c.D_ADDRESS1;
u.ADDRESS2 = c.D_ADDRESS2;
u.ADDRESS3 = c.D_ADDRESS3;
u.ADDRESS4 = c.D_ADDRESS4;
u.ACC_STATUS = "NORM";
u.ACTION_CODE = "";
u.INHERIT_REPORTING = "Y";
u.STATUS_SINCE = DateTime.Parse("23-JUL-2018"); // DateTime.Parse(DateTime.Now.ToString("dd-MMM-yyyy"));
u.TYPE_OF_CHQ = "C";
u.GEN_STMT_ONLY_ON_MVMT = "N";
u.AC_STAT_DE_POST = "Y";
u.DISPLAY_IBAN_IN_ADVICES = "N";
u.REG_CC_AVAILABILITY = "N";
u.MT210_REQD = "N";
u.SWEEP_TYPE = "-1";
u.DORMANT_PARAM = "B";
u.POSITIVE_PAY_AC = "N";
u.TRACK_RECEIVABLE = "N";
u.NETTING_REQUIRED = "N";
u.LODGEMENT_BOOK_FACILITY = "N";
u.REFERRAL_REQUIRED = "N";
u.EXCL_SAMEDAY_RVRTRNS_FM_STMT = "N";
u.ALLOW_BACK_PERIOD_ENTRY = "Y";
u.PROV_CCY_TYPE = "L";
u.DEFER_RECON = "N";
u.CONSOLIDATION_REQD = "N";
u.FUNDING = "N";
u.ALT_AC_NO = Commons.Helpers.Utility.GetReferenceNo();
u.AUTO_PROV_REQD = "N";
return(u);
}
