コード例 #1
0
        public async Task <int> UpdateCountry([FromBody] Country country)
        {
            var dyParam = new OracleDynamicParameters();

            dyParam.Add(Params.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)country.ID ?? DBNull.Value);
            dyParam.Add(Params.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)country.NAME ?? DBNull.Value, 500);
            dyParam.Add(Params.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)country.NAME2 ?? DBNull.Value, 500);
            dyParam.Add(Params.PARAMETER_COUNTRY_NATIONALITY, OracleDbType.Varchar2, ParameterDirection.Input, (object)country.NATIONALITY ?? DBNull.Value, 100);
            dyParam.Add(Params.PARAMETER_COUNTRY_CURRENCY_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)country.ST_CUR_CODE ?? DBNull.Value, 30);
            dyParam.Add(Params.PARAMETER_REFERNCE_NO, OracleDbType.Varchar2, ParameterDirection.Input, (object)country.REFERNCE_NO ?? DBNull.Value, 500);
            dyParam.Add(Params.PARAMETER_LOC_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)country.LOC_STATUS ?? DBNull.Value);
            dyParam.Add(Params.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)country.STATUS_DATE ?? DBNull.Value);
            dyParam.Add(Params.PARAMETER_PHONE_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)country.PHONE_CODE ?? DBNull.Value, 50);
            dyParam.Add(Params.PARAMETER_COUNTRY_FLAG, OracleDbType.Varchar2, ParameterDirection.Input, (object)country.FLAG ?? DBNull.Value, 500);

            int result = await _UpdateRepository.UpdateObjectAsync(SPName.SP_UPADTE_COUNTRY, dyParam);

            if (result == -1)
            {
                return(Convert.ToInt32(HttpStatusCode.OK));
            }
            else
            {
                return(Convert.ToInt32(HttpStatusCode.NotModified));
            }
        }