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