public ItemResult CheckBasketResourcesByInventorNumbers(BasketInventors inBasketInventors) { ItemResult itemResult = new ItemResult(); using (NpgsqlConnection connection = this.CreateConnection()) { try { connection.Open(); this.CreateFunctionCallQuery(LibraryFunctions.fn_resource_check_basket_resource_by_inventor_no, connection); this.Cmd.Parameters.AddWithValue("p_basket_resource_inventor_numbers", JsonConvert.SerializeObject(inBasketInventors)); NpgsqlDataReader dataReader = null; dataReader = this.Cmd.ExecuteReader(); using (dataReader) { while (dataReader.Read()) { itemResult.Item = JsonConvert.DeserializeObject <OutBasketInventors>((string)dataReader[0]); } } connection.Close(); } catch (PostgresException e) { itemResult.Code = e.MessageText; itemResult.Message = LibraryErrorMessages.GetErrorMessage(itemResult.Code); } catch (NpgsqlException e) { itemResult.Code = (e.ErrorCode).ToString(); itemResult.Message = LibraryErrorMessages.GetErrorMessage(itemResult.Code); } } return(itemResult); }
public ItemResult CheckResourceByInvantarId([FromBody] BasketInventors inventarIds) { return(pgResource.CheckBasketResourcesByInventorNumbers(inventarIds)); }