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); }