private static bool CheckConnectionRedis()
{
bool isConnected = Connection.IsConnected;
if (!isConnected)
{
logger.Error(DALConst.A("CheckConnectionRedis", "Not connection!", DALConst.REDIS_HOST, DALConst.REDIS_PORT, DALConst.REDIS_PASS));
}
return(isConnected);
}
/// <summary>
/// Insert phone change telco Gateway
/// </summary>
/// <param name="storedName"></param>
/// <param name="keyValues"></param>
/// <returns></returns>
public async Task <IDictionary <string, object> > InsertPhoneChangeTelcoGatewayAsync(string phone, string telco)
{
if (logger.IsDebugEnabled)
{
stopWatch.Restart();
stopWatch.Start();
}
IDictionary <string, object> resultReturn = new Dictionary <string, object>();
string storedName = "pks_phone_change_telco.pr_post_phone_change_telco";
try
{
OracleDynamicParameters dynamicParams = new OracleDynamicParameters();
dynamicParams.Add("p_refcursor", OracleDbType.RefCursor, ParameterDirection.Output, null);
dynamicParams.Add("p_phone", OracleDbType.Varchar2, ParameterDirection.Input, phone);
dynamicParams.Add("p_telco", OracleDbType.Varchar2, ParameterDirection.Input, telco);
dynamicParams.Add("p_err_code", OracleDbType.Varchar2, ParameterDirection.Output, null, 10);
dynamicParams.Add("p_err_message", OracleDbType.Varchar2, ParameterDirection.Output, null, 50);
using (IDbConnection dbConnection = new OracleConnection(DALConst.ORACLE_CONNECTION))
{
await dbConnection.ExecuteAsync(storedName, param : dynamicParams, commandType : CommandType.StoredProcedure);
string ErrCode = dynamicParams.oracleParameters[3].Value.ToString();
resultReturn.Add(DALConst.ERR_CODE, ErrCode);
if (!ErrCode.Equals("0"))
{
logger.Error(DALConst.A("InsertPhoneChangeTelcoGatewayAsync", storedName, phone, telco, ErrCode));
}
}
}
catch (Exception ex)
{
resultReturn.Add(DALConst.ERR_CODE, "-1");
resultReturn.Add(DALConst.ERR_MESSAGE, ex);
logger.Error(DALConst.A("InsertPhoneChangeTelcoGatewayAsync", storedName, ex));
}
if (logger.IsDebugEnabled)
{
stopWatch.Stop();
logger.Info(DALConst.A("InsertPhoneChangeTelcoGatewayAsync.:Stopwatch", storedName, stopWatch.ElapsedMilliseconds));
}
return(resultReturn);
}
public async Task <IDictionary <string, object> > UpdateStatusSMSAsync(string storedName, object[] keyValues = null)
{
if (logger.IsDebugEnabled)
{
stopWatch.Restart();
stopWatch.Start();
}
IDictionary <string, object> resultReturn = new Dictionary <string, object>();
string v_ErrCode = String.Empty;
string v_ErrMessage = String.Empty;
object result = new object();
var dynamicParam = new OracleDynamicParameters();
dynamicParam.Add("p_id", OracleDbType.Long, ParameterDirection.Input, keyValues[0]);
dynamicParam.Add("p_err_code", OracleDbType.Varchar2, ParameterDirection.Output, null, 100);
dynamicParam.Add("p_err_message", OracleDbType.Varchar2, ParameterDirection.Output, null, 100);
try
{
using (IDbConnection dbConnection = new OracleConnection(DALConst.ORACLE_CONNECTION))
{
dbConnection.Open();
result = await SqlMapper.QueryAsync(dbConnection, storedName, param : dynamicParam, commandType : CommandType.StoredProcedure);
foreach (var parameter in dynamicParam.oracleParameters)
{
if (parameter.Direction == ParameterDirection.Output || parameter.Direction == ParameterDirection.InputOutput)
{
switch (parameter.ParameterName)
{
case DALConst.P_ERR_CODE:
if (parameter.Value != DBNull.Value)
{
v_ErrCode = (parameter.Value.ToString() == DALConst.VALUE_NULL) ? DALConst.SYS_ERR_EXCEPTION : parameter.Value.ToString();
}
break;
case DALConst.P_ERR_MESSAGE:
v_ErrMessage = parameter.Value.ToString();
break;
default:
break;
}
}
}
resultReturn.Add(DALConst.ERR_CODE, v_ErrCode);
resultReturn.Add(DALConst.ERR_MESSAGE, v_ErrMessage);
resultReturn.Add(DALConst.DATA, result);
}
}
catch (Exception ex)
{
resultReturn.Add(DALConst.ERR_CODE, DALConst.SYS_ERR_EXCEPTION);
resultReturn.Add(DALConst.ERR_MESSAGE, ex);
resultReturn.Add(DALConst.DATA, result);
logger.Error(DALConst.A("ExecBOFunctionAsync", storedName, ex));
}
if (logger.IsDebugEnabled)
{
stopWatch.Stop();
logger.Info(DALConst.A("ExecBOFunctionAsync.:Stopwatch", storedName, stopWatch.ElapsedMilliseconds));
}
return(resultReturn);
}
public async Task <IDictionary <string, object> > InsertSmsAsync(string storedName, long accountID, string senderName, string sms_type, string smsContent, string partnerName, int smsCount, string phone, string telco, string scheduleTime, string order_name, long?campaign_id, int?is_schedule, string client_sms_id, string via)
{
if (logger.IsDebugEnabled)
{
stopWatch.Restart();
stopWatch.Start();
}
IDictionary <string, object> resultReturn = new Dictionary <string, object>();
string v_ErrCode = String.Empty;
string v_ErrMessage = String.Empty;
OracleDynamicParameters dynamicParams = new OracleDynamicParameters();
dynamicParams.Add("p_refcursor", OracleDbType.RefCursor, ParameterDirection.Output, null);
dynamicParams.Add("p_account_id", OracleDbType.Long, ParameterDirection.Input, accountID);
dynamicParams.Add("p_sender_name", OracleDbType.Varchar2, ParameterDirection.Input, senderName, 11);
dynamicParams.Add("p_sms_type", OracleDbType.Varchar2, ParameterDirection.Input, sms_type, 11);
dynamicParams.Add("p_sms_content", OracleDbType.Varchar2, ParameterDirection.Input, smsContent, 712);
dynamicParams.Add("p_partner_name", OracleDbType.Varchar2, ParameterDirection.Input, partnerName, 25);
dynamicParams.Add("p_sms_count", OracleDbType.Int16, ParameterDirection.Input, smsCount);
dynamicParams.Add("p_phone", OracleDbType.Varchar2, ParameterDirection.Input, phone, 20);
dynamicParams.Add("p_telco", OracleDbType.Varchar2, ParameterDirection.Input, telco, 20);
dynamicParams.Add("p_schedule_time", OracleDbType.Varchar2, ParameterDirection.Input, scheduleTime, 20);
dynamicParams.Add("p_order_name", OracleDbType.Varchar2, ParameterDirection.Input, order_name, 100);
dynamicParams.Add("p_campaign_id", OracleDbType.Int64, ParameterDirection.Input, campaign_id);
dynamicParams.Add("p_is_schedule", OracleDbType.Int16, ParameterDirection.Input, is_schedule);
dynamicParams.Add("p_client_sms_id", OracleDbType.Varchar2, ParameterDirection.Input, client_sms_id);
dynamicParams.Add("p_via", OracleDbType.Varchar2, ParameterDirection.Input, via, 50);
dynamicParams.Add("p_err_code", OracleDbType.Varchar2, ParameterDirection.Output, null, 100);
dynamicParams.Add("p_err_message", OracleDbType.Varchar2, ParameterDirection.Output, null, 100);
try
{
using (IDbConnection dbConnection = new OracleConnection(DALConst.ORACLE_CONNECTION))
{
dbConnection.Open();
await dbConnection.ExecuteAsync(storedName, param : dynamicParams, commandType : CommandType.StoredProcedure);
foreach (var parameter in dynamicParams.oracleParameters)
{
if (parameter.Direction == ParameterDirection.Output || parameter.Direction == ParameterDirection.InputOutput)
{
switch (parameter.ParameterName)
{
case DALConst.P_ERR_CODE:
if (parameter.Value != DBNull.Value)
{
v_ErrCode = (parameter.Value.ToString() == DALConst.VALUE_NULL) ? DALConst.SYS_ERR_EXCEPTION : parameter.Value.ToString();
}
break;
case DALConst.P_ERR_MESSAGE:
v_ErrMessage = parameter.Value.ToString();
break;
default:
break;
}
}
}
resultReturn.Add(DALConst.ERR_CODE, v_ErrCode);
resultReturn.Add(DALConst.ERR_MESSAGE, v_ErrMessage);
}
}
catch (Exception ex)
{
resultReturn.Add(DALConst.ERR_CODE, DALConst.SYS_ERR_EXCEPTION);
resultReturn.Add(DALConst.ERR_MESSAGE, ex);
logger.Error(DALConst.A("InsertSmsAsync", storedName, ex));
}
if (logger.IsDebugEnabled)
{
stopWatch.Stop();
logger.Info(DALConst.A("InsertSmsAsync.:Stopwatch", storedName, stopWatch.ElapsedMilliseconds));
}
return(resultReturn);
}
public async Task <IDictionary <string, object> > UpdateSMSErrorAsync(string storedName, long idSms, string smsType, string partnerName, string errorCode)
{
if (logger.IsDebugEnabled)
{
stopWatch.Restart();
stopWatch.Start();
}
IDictionary <string, object> resultReturn = new Dictionary <string, object>();
string v_ErrCode = String.Empty;
string v_ErrMessage = String.Empty;
OracleDynamicParameters dynamicParams = new OracleDynamicParameters();
dynamicParams.Add("p_id", OracleDbType.Long, ParameterDirection.Input, idSms);
dynamicParams.Add("p_sms_type", OracleDbType.Varchar2, ParameterDirection.Input, smsType);
dynamicParams.Add("p_partner_name", OracleDbType.Varchar2, ParameterDirection.Input, partnerName);
dynamicParams.Add("p_partner_err_code", OracleDbType.Varchar2, ParameterDirection.Input, errorCode);
dynamicParams.Add("p_err_code", OracleDbType.Varchar2, ParameterDirection.Output, null, 100);
dynamicParams.Add("p_err_message", OracleDbType.Varchar2, ParameterDirection.Output, null, 100);
try
{
using (IDbConnection dbConnection = new OracleConnection(DALConst.ORACLE_CONNECTION))
{
dbConnection.Open();
await dbConnection.ExecuteAsync(storedName, param : dynamicParams, commandType : CommandType.StoredProcedure);
foreach (var parameter in dynamicParams.oracleParameters)
{
if (parameter.Direction == ParameterDirection.Output || parameter.Direction == ParameterDirection.InputOutput)
{
switch (parameter.ParameterName)
{
case DALConst.P_ERR_CODE:
if (parameter.Value != DBNull.Value)
{
v_ErrCode = (parameter.Value.ToString() == DALConst.VALUE_NULL) ? DALConst.SYS_ERR_EXCEPTION : parameter.Value.ToString();
}
break;
case DALConst.P_ERR_MESSAGE:
v_ErrMessage = parameter.Value.ToString();
break;
default:
break;
}
}
}
resultReturn.Add(DALConst.ERR_CODE, v_ErrCode);
resultReturn.Add(DALConst.ERR_MESSAGE, v_ErrMessage);
}
}
catch (Exception ex)
{
resultReturn.Add(DALConst.ERR_CODE, DALConst.SYS_ERR_EXCEPTION);
resultReturn.Add(DALConst.ERR_MESSAGE, ex);
logger.Error(DALConst.A("UpdateSMSSentAsync", storedName, ex));
}
if (logger.IsDebugEnabled)
{
stopWatch.Stop();
logger.Info(DALConst.A("UpdateSMSSentAsync.:Stopwatch", storedName, stopWatch.ElapsedMilliseconds));
}
return(resultReturn);
}
