private void btnMigrate_Click(object sender, EventArgs e) { iFailed = 0; iSuccess = 0; iProcessed = 0; btnMigrate.Enabled = false; lblStatus.Text = "Started"; CustomerPINInfo _custPINInfo = new CustomerPINInfo(); if (bUpdateFromPINInfo) { _customerPINInfoList = _custPINInfo.GetRecords().ToList(); } migratePINS(); }
private bool InsertCustomerTPIN(string IdentityNumber, string EncryptedPIN, string ChannelID, string RelationShipNumber, string createdBy, string AuthorizedBy, string status, string retryAvailable) { string MethodName = MethodBase.GetCurrentMethod().Name; bool inserted = false; try { Logger.logDebug(ModuleName, MethodName, "**********Entered Method**********", Logger.LOGLEVEL.INFO); //check for IDNumber Masking. If should be maksed then do the masking // Logger.logDebug(ModuleName, MethodName, "Identity Number: " + IdentityNumber, Logger.LOGLEVEL.INFO); Logger.logDebug(ModuleName, MethodName, "Inserting Customer", Logger.LOGLEVEL.INFO); /* * [dbo].[CUSTOMER_PIN_AUTHEN]( * [CUSTOMER_ID] [varchar](50) NOT NULL, * [CHANNEL_GROUP_ID] [varchar](50) NOT NULL, * [RELATIONSHIP_NUM] [varchar](50) NOT NULL, * [TPIN] [varchar](50) NOT NULL, * [RETRY_AVAILABLE] [int] NOT NULL, * [MAX_RETRY_COUNT] [int] NOT NULL, * [LAST_PIN_ENTERED_DATE] [datetime] NULL, * [LAST_PIN_CHANGE_DATE] [datetime] NULL, * [TPIN_FLAG] [varchar](50) NULL, * [PIN_VALUE] [varchar](50) NULL, * [PIN_OFFSET] [varchar](50) NULL, * [RESERVED_1] [varchar](50) NULL, * [RESERVED_2] [varchar](50) NULL, * [RESERVED_3] [varchar](50) NULL, * [STATUS] [varchar](50) NOT NULL, * [CREATED_BY] [varchar](50) NOT NULL, * [CREATED_ON] [datetime] NOT NULL, * [UPDATED_BY] [varchar](50) NULL, * [UPDATED_ON] [datetime] NOT NULL, * [AUTHORIZED_BY] [varchar](50) NULL, * [AUTHORIZED_ON] [datetime] NULL, */ if (createdBy == "") { createdBy = "UNKNOWN SYSTEM GENERATED"; } string lastPinChangeDate = ""; string lastPinentryDate = ""; string lastSuccAuthDate = ""; string lastPinGenDate = ""; string lastStatusUpdateDate = ""; string createdOn = ""; string updatedBy = ""; string updatedOn = ""; try { if (bUpdateFromPINInfo) { CustomerPINInfo _tempCustPinInfo = _customerPINInfoList.Where(e => e.IDENTITY_NUMBER == RelationShipNumber).FirstOrDefault(); if (_tempCustPinInfo != null) { if (_tempCustPinInfo.PIN_TYPE_CODE != PIN_TYPE.SPIN.GetHashCode().ToString()) { retryAvailable = "0"; status = "MB"; } Logger.logDebug(ModuleName, MethodName, "Getting last pin change date", Logger.LOGLEVEL.WARNING); lastPinChangeDate = FormatDate(_tempCustPinInfo.LAST_PIN_CHANGE_DATE, DBSourceDateFormat, DBDestDateFormat); Logger.logDebug(ModuleName, MethodName, "Getting last pin entry date", Logger.LOGLEVEL.WARNING); lastPinentryDate = FormatDate(_tempCustPinInfo.LAST_PIN_ENTRY_DATE, DBSourceDateFormat, DBDestDateFormat); Logger.logDebug(ModuleName, MethodName, "Getting last auth date", Logger.LOGLEVEL.WARNING); lastSuccAuthDate = FormatDate(_tempCustPinInfo.LAST_SUCCESFUL_AUTH_DATE, DBSourceDateFormat, DBDestDateFormat); Logger.logDebug(ModuleName, MethodName, "Getting last pin generation date", Logger.LOGLEVEL.WARNING); lastPinGenDate = FormatDate(_tempCustPinInfo.LAST_PIN_GENERATION_DATE, DBSourceDateFormat, DBDestDateFormat); Logger.logDebug(ModuleName, MethodName, "Getting last status update date", Logger.LOGLEVEL.WARNING); lastStatusUpdateDate = FormatDate(_tempCustPinInfo.LAST_STATUS_UPDATE_DATE, DBSourceDateFormat, DBDestDateFormat); createdBy = _tempCustPinInfo.CREATED_BY; createdOn = FormatDate(_tempCustPinInfo.CREATED_ON, DBSourceDateFormat, DBDestDateFormat); updatedBy = _tempCustPinInfo.UPDATED_BY; updatedOn = FormatDate(_tempCustPinInfo.UPDATED_ON, DBSourceDateFormat, DBDestDateFormat); } } } catch (Exception ex) { } if (createdOn == null || createdOn == "") { createdOn = "getdate()"; } if (createdBy == null || createdBy == "") { createdBy = "MIGRATED"; } string sqlQuery = "INSERT INTO CUSTOMER_PIN_AUTHEN (CUSTOMER_ID, CHANNEL_GROUP_ID, RELATIONSHIP_NUM, TPIN, RETRY_AVAILABLE,MAX_RETRY_COUNT, STATUS,CREATED_BY, CREATED_ON, RESERVED_3, AUTHORIZED_BY, AUTHORIZED_ON"; string queryValues = "VALUES ('" + IdentityNumber + "'," + "'" + ChannelID + "'," + "'" + RelationShipNumber + "'," + "'" + EncryptedPIN + "'," + "" + retryAvailable + "," + "" + DefaultMaxRetryCount.ToString() + "," + "'" + status + "'," + "'" + createdBy + "'," + "getdate()," + "'MIGRATED'," + "'" + AuthorizedBy + "'," + "getdate()"; if (updatedOn != "") { sqlQuery += ", UPDATED_ON"; queryValues += ", '" + updatedOn + "'"; } if (updatedBy != "") { sqlQuery += ", UPDATED_BY"; queryValues += ", '" + updatedBy + "'"; } if (lastPinentryDate != "") { sqlQuery += ", LAST_PIN_ENTERED_DATE"; queryValues += ", '" + lastPinentryDate + "'"; } if (lastPinChangeDate != "") { sqlQuery += ", LAST_PIN_CHANGE_DATE"; queryValues += ", '" + lastPinChangeDate + "'"; } sqlQuery = sqlQuery + ")" + queryValues + ")"; Logger.logDebug(ModuleName, MethodName, "Executing Query : " + sqlQuery, Logger.LOGLEVEL.INFO); if (bInsertMigDB) { OledbSqlHelper _dbHelper = new OledbSqlHelper(DBDestConnString, bDBDestConnEncrypted); inserted = _dbHelper.ExecuteNonQuery(sqlQuery); } else { inserted = true; } if (inserted) { writeSuccessQueriestoFile(sqlQuery); } else { writeFailedQueriestoFile(sqlQuery); writeFailedCustomerswithQuerytoFile(IdentityNumber); } Logger.logDebug(ModuleName, MethodName, "Insert Result: " + inserted.ToString(), Logger.LOGLEVEL.INFO); return(inserted); } catch (Exception ex) { Logger.logDebug(ModuleName, MethodName, "Exception : " + ex.Message, Logger.LOGLEVEL.INFO); if (ex.InnerException != null) { Logger.logDebug(ModuleName, MethodName, "Inner Exception: " + ex.InnerException.Message, Logger.LOGLEVEL.INFO); } Logger.logDebug(ModuleName, MethodName, "**********Exiting Method**********", Logger.LOGLEVEL.INFO); MessageBox.Show(ex.Message); throw ex; } }