private void SADADDataUpload(ulong agreementID, decimal amount, string remarks, string billNumber, string paymentRef) { try { #region Call stored Procedure using (var command = new Oracle.DataAccess.Client.OracleCommand()) { command.Connection = OraConnection.GetConnection(); if (command.Connection.State != ConnectionState.Open) { command.Connection.Open(); } command.CommandType = CommandType.StoredProcedure; command.CommandText = "SADAD_manual_data_upload"; command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("p_Agreementid", Oracle.DataAccess.Client.OracleDbType.Int64)).Value = agreementID; command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("p_Chqamount", Oracle.DataAccess.Client.OracleDbType.Double)).Value = amount; command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("p_remarks", Oracle.DataAccess.Client.OracleDbType.Varchar2, 100)).Value = remarks; Oracle.DataAccess.Client.OracleParameter errorcodeparam = new Oracle.DataAccess.Client.OracleParameter("Error_code", Oracle.DataAccess.Client.OracleDbType.Int32); errorcodeparam.Direction = ParameterDirection.Output; Oracle.DataAccess.Client.OracleParameter errormsgparam = new Oracle.DataAccess.Client.OracleParameter("Error_msg", Oracle.DataAccess.Client.OracleDbType.Varchar2, 100); errorcodeparam.Direction = ParameterDirection.Output; command.Parameters.Add(errorcodeparam); command.Parameters.Add(errormsgparam); command.ExecuteNonQuery(); string errorcode = command.Parameters["Error_code"].Value.ToString(); string errorMessage = command.Parameters["Error_msg"].Value.ToString(); if (!string.IsNullOrWhiteSpace(errorcode)) { if (errorcode.ToLower() != "null") { UnprocessedRec(billNumber, paymentRef); Logger.TrackLogs("Invalid Agreement ID: '" + agreementID + "' with amount : '" + amount + "' , Error Code Message : '" + errorcode + "' , Error Message : '" + errorMessage + "'", "after calling 'SADAD_manual_data_upload' Procedure"); } } else { Logger.TrackLogs("Agreement ID: '" + agreementID + "' with amount : '" + amount + "' Added Successfully", "after calling 'SADAD_manual_data_upload' Procedure"); } command.Connection.Close(); } #endregion } catch (Exception ex) { UnprocessedRec(billNumber, paymentRef); Logger.TrackLogs("Invalid Agreement ID: '" + agreementID + "' with amount : '" + amount + "' , Error Code Message : '" + ex.Source + "' , Error Message : '" + ex.Message + "'", "after calling 'SADAD_manual_data_upload' Procedure"); } }
private void BankChargeEntry(string transactionType, string channel, decimal amount, string cardType, string customerNo, string customerName, string billNumber, string paymentRef) { try { #region Call stored Procedure using (var command = new Oracle.DataAccess.Client.OracleCommand()) { command.Connection = OraConnection.GetConnection(); if (command.Connection.State != ConnectionState.Open) { command.Connection.Open(); } command.CommandType = CommandType.StoredProcedure; command.CommandText = "trx_bank_charge_entry"; command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("TRX_TYPE", Oracle.DataAccess.Client.OracleDbType.Varchar2)).Value = transactionType; command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("TRX_CHANEL", Oracle.DataAccess.Client.OracleDbType.Varchar2)).Value = channel; command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("TRX_AMT", Oracle.DataAccess.Client.OracleDbType.Decimal, 100)).Value = amount; command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("CARD_TYPE", Oracle.DataAccess.Client.OracleDbType.Varchar2)).Value = cardType; command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("customer_no", Oracle.DataAccess.Client.OracleDbType.Varchar2)).Value = customerNo; command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("CUSTOMER_NAME", Oracle.DataAccess.Client.OracleDbType.Varchar2)).Value = customerName; Oracle.DataAccess.Client.OracleParameter errorcodeparam = new Oracle.DataAccess.Client.OracleParameter("VERROR", Oracle.DataAccess.Client.OracleDbType.Varchar2); errorcodeparam.Direction = ParameterDirection.Output; command.Parameters.Add(errorcodeparam); command.ExecuteNonQuery(); string errorMessage = command.Parameters["VERROR"].Value.ToString(); if (!string.IsNullOrWhiteSpace(errorMessage)) { if (errorMessage.ToLower() != "null") { UnprocessedRec(billNumber, paymentRef); Logger.TrackLogs("Invalid Bank Charge Entry Process for Transaction Type : '" + transactionType + "' , Customer No : '" + customerNo + "' , Customer Name : '" + customerName + "' , Card Type :'" + cardType + "' , Error Message : '" + errorMessage + "'", "after calling 'trx_bank_charge_entry' Procedure"); } } else { Logger.TrackLogs("Transaction Type : '" + transactionType + "' , Customer No : '" + customerNo + "' , Customer Name : '" + customerName + "' , Card Type :'" + cardType + "' , Added Successfully", "after calling 'trx_bank_charge_entry' Procedure"); } command.Connection.Close(); } #endregion } catch (Exception ex) { UnprocessedRec(billNumber, paymentRef); Logger.TrackLogs("Invalid Bank Charge Entry Process for Transaction Type : '" + transactionType + "' , Customer No : '" + customerNo + "' , Customer Name : '" + customerName + "' , Card Type :'" + cardType + "' , Error Message : '" + ex.Message + "'", "after calling 'trx_bank_charge_entry' Procedure"); } }