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