public object ExecuteReplace(DistributorReplace distributorReplace)
{
try
{
using (var connection = this.GetConnection())
{
var parameter = new OracleDynamicParameters();
parameter.Add("ExMobileNo", OracleDbType.Varchar2, ParameterDirection.Input, distributorReplace.ExMobileNo);
parameter.Add("NewMobileNo", OracleDbType.Varchar2, ParameterDirection.Input, distributorReplace.NewMobileNo);
parameter.Add("isWithDSR", OracleDbType.Varchar2, ParameterDirection.Input, distributorReplace.IsWithDSR);
parameter.Add("MSGID", OracleDbType.Varchar2, ParameterDirection.Input, "999999999");
parameter.Add("V_FLAG", OracleDbType.Double, ParameterDirection.Output);
parameter.Add("OUTMSG", OracleDbType.Varchar2, ParameterDirection.Output, null, 32767);
//var result = SqlMapper.Query<string>(connection, "SP_Execute_Replacement", param: parameter, commandType: CommandType.StoredProcedure).FirstOrDefault();
SqlMapper.Query(connection, dbUser + "SP_Execute_Replacement", param: parameter, commandType: CommandType.StoredProcedure);
this.CloseConnection(connection);
string flag = parameter.oracleParameters[4].Value != null ? parameter.oracleParameters[4].Value.ToString() : null;
string successOrErrorMsg = null;
if (flag == "0")
{
successOrErrorMsg = parameter.oracleParameters[5].Value != null ? parameter.oracleParameters[5].Value.ToString() : null;
}
else
{
successOrErrorMsg = flag;
}
return(successOrErrorMsg);
}
}
catch (Exception)
{
throw;
}
}
public object ExecuteReplace(DistributorReplace distributorReplace)
{
try
{
return(_distributorRepository.ExecuteReplace(distributorReplace));
}
catch (Exception)
{
throw;
}
}
public object ExecuteReplace([FromBody] DistributorReplace distributorReplace)
{
try
{
return(_distributorService.ExecuteReplace(distributorReplace));
}
catch (Exception ex)
{
return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString()));
}
}
